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