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