public partial class frmemplicense : Form
{
public frmemplicense()
{
InitializeComponent();
}
string licenseKey;
string employeeName;
string serialNumber;
public string pageAction;
private void frmemplicense_Load(object sender, EventArgs e)
{
LoadGrid();
SetEditState(false);
ClearFields();
LoadData();
}
private void LoadGrid()
{
try
{
ConnectionClass l_ConnectionClass = new ConnectionClass();
DataSet l_employeelicense = l_ConnectionClass.FetchDataInDataSet("SELECT tblantivirus.licenseKey, tblemployeelicense.licenseKey, tblemployeelicense.employeeName, tblemployeelicense.serialNumber, tblemployee.employeeName, tblemployee.serialNumber FROM tblantivirus RIGHT JOIN (tblemployeelicense LEFT JOIN tblemployee ON tblemployeelicense.employeeName = tblemployee.employeeName) ON tblantivirus.licenseKey = tblemployeelicense.licenseKey;");
dgvemplicense.DataSource = l_employeelicense.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SetEditState(bool edit)
{
btnadd.Enabled = !edit;
btnclose.Enabled = !edit;
btndelete.Enabled = !edit;
dgvemplicense.Enabled = !edit;
btncancel.Enabled = edit;
btnsave.Enabled = edit;
cbemployee.Enabled = edit;
cblicense.Enabled = edit;
cbserial.Enabled = edit;
}
private void ClearFields()
{
cbemployee.Text = String.Empty;
cblicense.Text = String.Empty;
cbserial.Text = String.Empty;
}
private void LoadData()
{
try
{
ConnectionClass l_ConnectionClass = new ConnectionClass();
DataSet KeyData = l_ConnectionClass.FetchDataInDataSet("select licenseKey from tblantivirus");
cblicense.ValueMember = "licenseId";
cblicense.DisplayMember = "licenseKey";
cblicense.DataSource = KeyData.Tables[0];
DataSet EmployeeData = l_ConnectionClass.FetchDataInDataSet("select employeeName from tblemployee");
cbemployee.ValueMember = "employeeId";
cbemployee.DisplayMember = "employeeName";
cbemployee.DataSource = EmployeeData.Tables[0];
DataSet SerialData = l_ConnectionClass.FetchDataInDataSet("select serialNumber from tblemployee");
cbserial.ValueMember = "employeeId";
cbserial.DisplayMember = "serialNumber";
cbserial.DataSource = SerialData.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnadd_Click(object sender, EventArgs e)
{
pageAction = "ADD";
ClearFields();
SetEditState(true);
cblicense.Focus();
}
private void btnsave_Click(object sender, EventArgs e)
{
try
{
ConnectionClass l_ConnectionClass = new ConnectionClass();
licenseKey = Convert.ToString(cblicense.SelectedValue);
employeeName = Convert.ToString(cbemployee.SelectedValue);
serialNumber = Convert.ToString(cbserial.SelectedValue);
l_ConnectionClass.SaveEmployeeLicense(licenseKey, employeeName, serialNumber);
LoadGrid();
ClearFields();
cblicense.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btncancel_Click(object sender, EventArgs e)
{
LoadGrid();
ClearFields();
SetEditState(false);
}
private void btnclose_Click(object sender, EventArgs e)
{
this.Close();
}
private void dgvemplicense_SelectionChanged(object sender, EventArgs e)
{
try
{
if (dgvemplicense.SelectedRows.Count > 0)
{
cblicense.SelectedValue = dgvemplicense.CurrentRow.Cells["licenseKey"].Value.ToString();
cbemployee.SelectedValue = dgvemplicense.CurrentRow.Cells["employeeName"].Value.ToString();
cbserial.SelectedValue = dgvemplicense.CurrentRow.Cells["serialNumber"].Value.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Please help because i am fully confused what to do.