public void AddAssignProject(AssignProject assignProject) { using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("sp_AddAssignProject", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("Project_Assign_ID", assignProject.Project_Assign_ID); cmd.Parameters.AddWithValue("Emp_Id", assignProject.Emp_Id); cmd.Parameters.AddWithValue("Project_ID", assignProject.Project_ID); cmd.Parameters.AddWithValue("Assign_Project_StartDate", assignProject.Assign_Project_StartDate); cmd.Parameters.AddWithValue("Assign_Project_EndDate", assignProject.Assign_Project_EndDate); cmd.Parameters.AddWithValue("Billable", assignProject.Billable); cmd.Parameters.AddWithValue("Billing_Percentage", assignProject.Billing_Percentage); cmd.Parameters.AddWithValue("Location", assignProject.Location); cmd.Parameters.AddWithValue("Onsite", assignProject.Onsite); cmd.ExecuteNonQuery(); conn.Close(); } }
public AssignProject GetAssignProjectData(string Project_Assign_ID) //doubt { AssignProject assignProject = new AssignProject(); using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("select Project_Assign_ID,Emp_Id, Project_ID,Assign_Project_StartDate,Assign_Project_EndDate,Billable,Billing_Percentage,Location,Onsite from pact_rmg_customer WHERE Project_Assign_ID=" + Project_Assign_ID, conn); conn.Open(); using (var rdr = cmd.ExecuteReader()) { while (rdr.Read()) { assignProject.Project_Assign_ID = rdr["Project_Assign_ID"].ToString(); assignProject.Emp_Id = rdr["Emp_Id"].ToString(); assignProject.Project_ID = rdr["Project_ID"].ToString(); assignProject.Assign_Project_StartDate = rdr["Assign_Project_StartDate"].ToString(); assignProject.Assign_Project_EndDate = rdr["Assign_Project_EndDate"].ToString(); assignProject.Billable = rdr["Billable"].ToString(); assignProject.Billing_Percentage = rdr["Billing_Percentage"].ToString(); assignProject.Location = rdr["Location"].ToString(); assignProject.Onsite = rdr["Onsite"].ToString(); } } return(assignProject); } }