private void showAdvisorToolStripMenuItem_Click(object sender, EventArgs e)
{
Manage_Advisors manage_advisor = new Manage_Advisors();
this.Hide();
manage_advisor.Show();
}
private void cmdCancel_Click(object sender, EventArgs e)
{
GeneralID.selectedObjectid = 0;
Manage_Advisors showAdvisor = new Manage_Advisors();
this.Hide();
showAdvisor.Show();
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (!is_invalid())
{
if (!is_editMode())
{
string queryProject = "";
try
{
int maxId;
string querymx = "select max(Id) from Advisor";
maxId = DataBaseConnection.getInstance().getRowsCount(querymx) + 1;
if (txtBxSalary.Text == "")
{
queryProject = string.Format("insert into Advisor(Id,Designation) values('{0}',(select Id from Lookup where Value='{1}'))", maxId, cmbBxDesignation.Text);
}
else
{
queryProject = string.Format("insert into Advisor(Id,Designation,Salary) values('{0}',(select Id from Lookup where Value='{1}'),'{2}')", maxId, cmbBxDesignation.Text, int.Parse(txtBxSalary.Text));
}
}
catch
{
if (txtBxSalary.Text == "")
{
queryProject = string.Format("insert into Advisor(Id,Designation) values(1,(select Id from Lookup where Value='{0}'),'{1}')", cmbBxDesignation.Text);
}
else
{
queryProject = string.Format("insert into Advisor(Id,Designation,Salary) values(1,(select Id from Lookup where Value='{0}'),'{1}')", cmbBxDesignation.Text, int.Parse(txtBxSalary.Text));
}
}
DataBaseConnection.getInstance().executeQuery(queryProject);
MessageBox.Show("Added Success");
}
else
{
string queryUpdateAdvisor;
if (txtBxSalary.Text == "")
{
queryUpdateAdvisor = string.Format("update Advisor set Designation=(select Id from Lookup where Value='{0}'),Salary='{1}' where Id='{2}'", cmbBxDesignation.Text, null, GeneralID.selectedObjectid);
}
else
{
queryUpdateAdvisor = string.Format("update Advisor set Designation=(select Id from Lookup where Value='{0}'),Salary='{1}' where Id='{2}'", cmbBxDesignation.Text, int.Parse(txtBxSalary.Text), GeneralID.selectedObjectid);
}
DataBaseConnection.getInstance().executeQuery(queryUpdateAdvisor);
MessageBox.Show("Update Success");
GeneralID.selectedObjectid = 0; //reset it to zero after successfull update
}
Manage_Advisors showAdvisor = new Manage_Advisors();
this.Hide();
showAdvisor.Show();
}
}
