public static void UpdateEmployee(UpdateEmployee_EL e) { try { using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=AttendanceAndLeaveManagementSystem;Integrated Security=True;")) { SqlCommand cmd = new SqlCommand("Update EmployeeDetails set EmpName=@EmpName,EmpDesignation=@EmpDesignation,EmpDOB=@EmpDOB,EmpAddress=@EmpAddress,MgrId=@MgrId, ProjectId=@ProjectId Where EmpId=@EmpId", con); Console.WriteLine("Enter EmpId to update record:"); cmd.Parameters.AddWithValue("@EmpId", e.EmpId); cmd.Parameters.AddWithValue("@EmpName", e.EmpDesignation); cmd.Parameters.AddWithValue("@EmpDesignation", e.EmpDesignation); cmd.Parameters.AddWithValue("@EmpDOB", e.EmpDOB); cmd.Parameters.AddWithValue("@EmpAddress", e.EmpAddress); cmd.Parameters.AddWithValue("@MgrId", e.MgrId); cmd.Parameters.AddWithValue("@ProjectId", e.ProjectId); con.Open(); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { Console.WriteLine(ex.Message); } }
public static void UpdateEmployee(UpdateEmployee_EL e) { try { using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=ALMS;Integrated Security=True;")) { SqlCommand cmd = new SqlCommand { CommandText = "spUpdateEmployee", Connection = con, CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@EmpId", e.EmpId); cmd.Parameters.AddWithValue("@EmpName", e.EmpDesignation); cmd.Parameters.AddWithValue("@EmpDesignation", e.EmpDesignation); cmd.Parameters.AddWithValue("@EmpDOB", e.EmpDOB); cmd.Parameters.AddWithValue("@EmpAddress", e.EmpAddress); cmd.Parameters.AddWithValue("@MgrId", e.MgrId); cmd.Parameters.AddWithValue("@ProjectId", e.ProjectId); con.Open(); cmd.ExecuteNonQuery(); } } catch (SqlException ex) { Console.WriteLine(ex.Message); } }
public static UpdateEmployee_EL UpdateEmployeeInput() { UpdateEmployee_EL ue = new UpdateEmployee_EL(); Console.WriteLine("Enter EmpId to update record:"); ue.EmpId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter EmpName, EmpDesignation, EmpDOB, EmpAddress, MgrId, ProjectId to add record:"); ue.EmpName = Console.ReadLine(); ue.EmpDesignation = Console.ReadLine(); ue.EmpDOB = DateTime.Parse(Console.ReadLine()); ue.EmpAddress = Console.ReadLine(); ue.MgrId = Convert.ToInt32(Console.ReadLine()); ue.ProjectId = Convert.ToInt32(Console.ReadLine()); return(ue); }