public static void DeleteLeaveRequest(DelLeaveRequest_EL e)
{
using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=ALMS;Integrated Security=True;"))
{
SqlCommand cmd = new SqlCommand
{
CommandText = "spDelLeaveRequest",
Connection = con,
CommandType = CommandType.StoredProcedure
};
//passing values to sql parameter
cmd.Parameters.AddWithValue("@EmpId", e.EmpId);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
}
public static DelLeaveRequest_EL DelLeaveRequestInput()
{
Console.WriteLine("Enter: EmpId");
DelLeaveRequest_EL dlr = new DelLeaveRequest_EL()
{
EmpId = int.Parse(Console.ReadLine()),
};
return(dlr);
}
