public static void AddProject(AddProject_EL e)
{
//write code to add project in ProjectDetails
using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=ALMS;Integrated Security=True;"))
{
SqlCommand cmd = new SqlCommand
{
CommandText = "spAddProject",
Connection = con,
CommandType = CommandType.StoredProcedure
};
//passing values to sql parameter
cmd.Parameters.AddWithValue("@ProjName", e.ProjName);
cmd.Parameters.AddWithValue("@ProjectTechnology", e.ProjectTechnology);
cmd.Parameters.AddWithValue("@Startdate", e.Startdate);
cmd.Parameters.AddWithValue("@Enddate", e.Enddate);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
}
public static AddProject_EL AddProjecInput()
{
AddProject_EL ape = new AddProject_EL();
Console.WriteLine("Project Name");
ape.ProjName = Console.ReadLine();
Console.WriteLine("Enter Technology");
ape.ProjectTechnology = Console.ReadLine();
Console.WriteLine("Enter StartDate");
ape.Startdate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Enter EndDate");
ape.Enddate = DateTime.Parse(Console.ReadLine());
return(ape);
}
