public static int LeaveType_Save(Entity.LeaveManagement.LeaveType objLeaveType) { int retValue = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_HR_LeaveType_Save"; cmd.Parameters.AddWithValue("@LeaveTypeId", objLeaveType.LeaveTypeId); cmd.Parameters.AddWithValue("@LeaveTypeName", objLeaveType.LeaveTypeName); cmd.Parameters.AddWithValue("@LeaveTypeDescription", objLeaveType.LeaveTypeDescription); if (con.State == ConnectionState.Closed) { con.Open(); } retValue = cmd.ExecuteNonQuery(); con.Close(); } } return(retValue); }
public int LeaveTypeDelete(Entity.LeaveManagement.LeaveType objLeaveType) { return(DataAccess.LeaveManagement.LeaveType.LeaveType_Delete(objLeaveType)); }
public DataTable LeaveTypeGetAll(Entity.LeaveManagement.LeaveType objLeaveType) { return(DataAccess.LeaveManagement.LeaveType.LeaveType_GetAll()); }