private void linkLabel7_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
ProjectandAdvisorDetails frm = new ProjectandAdvisorDetails();
this.Hide();
frm.Show();
}
private void button2_Click(object sender, EventArgs e)
{
this.Hide();
ProjectandAdvisorDetails frm = new ProjectandAdvisorDetails();
frm.Show();
}
private void linkLabel7_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
ProjectandAdvisorDetails d = new ProjectandAdvisorDetails();
d.Show();
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
lbladvisor.Text = "";
}
else if (comboBox1.Text == "")
{
lbladvisor.Text = "Please SElect the Advisor";
lbladvisor.Visible = true;
}
if (comboBox2.Text != "")
{
lbltitle.Text = "";
}
else if (comboBox2.Text == "")
{
lbltitle.Text = "Select the Title";
}
if (comboBox3.Text != "")
{
lblrole.Text = "";
}
else if (comboBox3.Text == "")
{
lblrole.Text = "Select the Role of Advisor";
}
if (dateTimePicker1.Value > DateTime.Now)
{
label4.Text = "Enter correct Assignment Date";
label4.Visible = true;
}
else if (dateTimePicker1.Value <= DateTime.Now)
{
label4.Text = "";
}
if (lbladvisor.Text == "" && lblrole.Text == "" && lbltitle.Text == "" && label4.Text == "")
{
string cmnd = "Select Id from Project where Title = '" + comboBox2.Text + "'";
int id = dbConnection.getInstance().getScalerData(cmnd);
string b = "Select Id from Lookup where Value = '" + comboBox3.Text + "'";
int o = dbConnection.getInstance().getScalerData(b);
string query = "Select Count(AdvisorId) from ProjectAdvisor where ProjectId = '" + id + "' and AdvisorId = '" + Convert.ToInt32(comboBox1.Text) + "'";
int count = dbConnection.getInstance().getScalerData(query);
bool c = true;
if (count >= 1)
{
label4.Text = "This Advisor is already serving project '" + comboBox2.Text + "'";
label4.Visible = true;
c = false;
}
else if (c == true)
{
try
{
string s = "Select Id from Lookup where Value = '" + comboBox3.Text + "'";
int i = dbConnection.getInstance().getScalerData(s);
string os = "Update ProjectAdvisor SET ProjectId = '" + id + "', AdvisorId = '" + Convert.ToInt32(comboBox1.Text) + "',AdvisorRole = '" + i + "',AssignmentDate = '" + dateTimePicker1.Value + "' where ProjectId = '" + dataGridView1.CurrentRow.Cells["ProjectId"].Value + "'and AdvisorId = '" + dataGridView1.CurrentRow.Cells["AdvisorId"].Value + "'";
dbConnection.getInstance().exectuteQuery(os);
MessageBox.Show("Updated");
this.Hide();
ProjectandAdvisorDetails frm = new ProjectandAdvisorDetails();
frm.Show();
}
catch (Exception et)
{
throw (et);
}
}
}
}
