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);
}
}
