public static DelProject_EL DelProjectInput()
{
Console.WriteLine("Enter ProjectId to delete record:");
DelProject_EL dpe = new DelProject_EL
{
ProjectId = Console.ReadLine()
};
return(dpe);
}
public static void DeleteProject(DelProject_EL e)
{
//write code to delete project in ProjectDetails
try
{
using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=ALMS;Integrated Security=True;"))
{
SqlCommand cmd = new SqlCommand
{
CommandText = "spDeleteProject",
Connection = con,
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@ProjectId", e.ProjectId);
con.Open();
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
