public void finishproject(int id)
{
AdminClass adm = new AdminClass();
ProjectClass pro = new ProjectClass();
adm.projectview(ref list);
for (int i = 0; i < list.Count; i++)
{
if (list[i].id == id)
{
pro = list[i];
break;
}
}
SqlConnection connect = new SqlConnection(connectstr);
SqlCommand cmd = new SqlCommand("select dbo.check_finish('" + pro.id + "')", connect);
try
{
connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
pro.status = reader.GetString(0);
}
reader.Close();
SqlCommand cmd2 = new SqlCommand("execute edit_project '" + pro.id + "', '" + pro.name + "', '" + pro.description + "', '" + pro.start_time + "', '" + pro.end_time + "', '" + pro.status + "'", connect);
cmd2.ExecuteNonQuery();
connect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void FinishProjBtn_Click(object sender, EventArgs e)
{
ProjectClass pro = new ProjectClass();
pro.name = ProjNameTextbox.Text;
pro.start_time = Convert.ToDateTime(startTime.Text);
pro.end_time = Convert.ToDateTime(EndTime.Text);
pro.clinet_name = cNameBox.Text;
pro.client_mail = cMailBox.Text;
pro.status = "running";
pro.client_phone = cPhoneBox.Text;
for (int i = 0; i < managername.Count; i++)
{
if (managername[i].name == comboBox1.Text)
{
pro.id_manger = managername[i].id;
break;
}
}
pro.description = ProjDescription.Text;
AdminClass adm = new AdminClass();
adm.addproject(pro);
ProjNameTextbox.Clear();
cNameBox.Clear();
cMailBox.Clear();
cPhoneBox.Clear();
ProjDescription.Clear();
comboBox1.Text = "";
MessageBox.Show("Project Added Successfully");
}
private void Finisheditbtn_MouseClick(object sender, MouseEventArgs e)
{
ProjectClass pro = new ProjectClass();
pro.id = project_id;
pro.name = ProjNameTextbox.Text;
pro.start_time = Convert.ToDateTime(startTime.Text);
pro.end_time = Convert.ToDateTime(EndTime.Text);
pro.description = ProjDescription.Text;
AdminClass adm = new AdminClass();
adm.editproject(pro);
MessageBox.Show("Edited Successfully");
this.Hide();
}
public void editproject(ProjectClass pro)
{
SqlConnection connect = new SqlConnection(connectstr);
SqlCommand cmd = new SqlCommand("execute edit_project '" + pro.id + "','" + pro.name + "','" + pro.description + "','" + pro.start_time + "','" + pro.end_time + "','" + pro.status + "'", connect);
try
{
connect.Open();
cmd.ExecuteNonQuery();
connect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void addproject(ProjectClass pro)
{
SqlConnection connect = new SqlConnection(connectstr);
SqlCommand cmd = new SqlCommand("select * from client where client_name='" + pro.clinet_name + "'", connect);
try
{
connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
pro.id_client = (int)reader["client_id"];
}
reader.Close();
connect.Close();
connect.Open();
cmd = new SqlCommand("execute insert_project '" + pro.name + "','" + pro.description + "','" + pro.start_time + "','" + pro.end_time + "','" + pro.id_client + "','" + pro.status + "','" + pro.id_manger + "'", connect);
cmd.ExecuteNonQuery();
reader.Close();
connect.Close();
}
catch (Exception ex)
{
SqlCommand cmd2 = new SqlCommand("execute insert_client '" + pro.clinet_name + "','" + pro.client_phone + "','" + pro.client_mail + "'", connect);
cmd2.ExecuteNonQuery();
SqlCommand cmd3 = new SqlCommand("select * from client where client_name='" + pro.clinet_name + "'", connect);
reader = cmd3.ExecuteReader();
while (reader.Read())
{
pro.id_client = (int)reader["client_id"];
}
reader.Close();
SqlCommand cmd4 = new SqlCommand("execute insert_project '" + pro.name + "','" + pro.description + "','" + pro.start_time + "','" + pro.end_time + "','" + pro.id_client + "','" + pro.status + "','" + pro.id_manger + "'", connect);
cmd4.ExecuteNonQuery();
connect.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void projectview(ref List <ProjectClass> list)
{
//List<ProjectClass> list = new List<ProjectClass>();
SqlConnection connect = new SqlConnection("Data Source=LAPTOP-MP5TT4VU\\SQLEXPRESS;Initial Catalog=ISPROJECT1;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select * from project inner join client on project.project_client_id = client.client_id inner join employee on project.manger_id=employee.employee_id", connect);
try
{
connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ProjectClass pro = new ProjectClass();
pro.id = (int)reader["project_id"];
pro.name = (string)reader["project_name"];
pro.description = (string)reader["project_description"];
pro.start_time = reader.GetDateTime(3);
pro.end_time = reader.GetDateTime(4);
pro.id_client = (int)reader["project_client_id"];
pro.status = (string)reader["project_status"];
pro.id_manger = (int)reader["manger_id"];
pro.clinet_name = (string)reader["client_name"];
pro.client_phone = (string)reader["client_phone"];
pro.client_mail = (string)reader["client_mail"];
pro.manger_name = (string)reader["employee_name"];
list.Add(pro);
}
reader.Close();
connect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void displayprojects(ref List <ProjectClass> list, int id)
{
SqlConnection connect = new SqlConnection(connectstr);
SqlCommand cmd = new SqlCommand("select * from project inner join client on project.project_client_id = client.client_id inner join employee on project.manger_id=employee.employee_id where project.manger_id='" + id + "' ", connect);
try
{
connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ProjectClass pro = new ProjectClass();
pro.id = (int)reader["project_id"];
pro.name = (string)reader["project_name"];
pro.description = (string)reader["project_description"];
pro.start_time = reader.GetDateTime(3);
pro.end_time = reader.GetDateTime(4);
pro.id_client = (int)reader["project_client_id"];
pro.status = (string)reader["project_status"];
pro.id_manger = (int)reader["manger_id"];
pro.clinet_name = (string)reader["client_name"];
pro.client_phone = (string)reader["client_phone"];
pro.client_mail = (string)reader["client_mail"];
pro.manger_name = (string)reader["employee_name"];
list.Add(pro);
}
reader.Close();
connect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ViewProjUC(ProjectClass pro)
{
InitializeComponent();
Region = System.Drawing.Region.FromHrgn(CreateRoundRectRgn(0, 0, Width, Height, 20, 20));
project = pro;
}
