public static void UpdateProject(UpdateProject_EL e)
{
//write code to edit project in ProjectDetails
try
{
using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=ALMS;Integrated Security=True;"))
{
SqlCommand cmd = new SqlCommand
{
CommandText = "spUpdateProject",
Connection = con,
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@ProjectId", e.ProjectId);
cmd.Parameters.AddWithValue("@ProjName", e.ProjName);
cmd.Parameters.AddWithValue("@ProjectTechnology", e.ProjectTechnology);
cmd.Parameters.AddWithValue("@Startdate", e.Startdate);
cmd.Parameters.AddWithValue("@Enddate", e.Enddate);
con.Open();
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
public static UpdateProject_EL UpdateProjectInput()
{
Console.WriteLine("Enter ProjectId to update record:");
UpdateProject_EL upe = new UpdateProject_EL();
upe.ProjectId = Console.ReadLine();
Console.WriteLine("Enter ProjName, ProjectTechnology, Startdate, Enddate to add record:");
upe.ProjName = Console.ReadLine();
upe.ProjectTechnology = Console.ReadLine();
upe.Startdate = DateTime.Parse(Console.ReadLine());
upe.Enddate = DateTime.Parse(Console.ReadLine());
return(upe);
}
