public static HR_LeavesRuleEmployee GetHR_LeavesRuleEmployeeByLeavesRuleEmployeeID(int LeavesRuleEmployeeID) { HR_LeavesRuleEmployee hR_LeavesRuleEmployee = new HR_LeavesRuleEmployee(); SqlHR_LeavesRuleEmployeeProvider sqlHR_LeavesRuleEmployeeProvider = new SqlHR_LeavesRuleEmployeeProvider(); hR_LeavesRuleEmployee = sqlHR_LeavesRuleEmployeeProvider.GetHR_LeavesRuleEmployeeByLeavesRuleEmployeeID(LeavesRuleEmployeeID); return hR_LeavesRuleEmployee; }
public static int InsertHR_LeavesRuleEmployee(HR_LeavesRuleEmployee hR_LeavesRuleEmployee) { SqlHR_LeavesRuleEmployeeProvider sqlHR_LeavesRuleEmployeeProvider = new SqlHR_LeavesRuleEmployeeProvider(); return sqlHR_LeavesRuleEmployeeProvider.InsertHR_LeavesRuleEmployee(hR_LeavesRuleEmployee); }
public bool UpdateHR_LeavesRuleEmployee(HR_LeavesRuleEmployee hR_LeavesRuleEmployee) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_LeavesRuleEmployee", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@LeavesRuleEmployeeID", SqlDbType.Int).Value = hR_LeavesRuleEmployee.LeavesRuleEmployeeID; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_LeavesRuleEmployee.EmployeeID; cmd.Parameters.Add("@LeaveRuleID", SqlDbType.Int).Value = hR_LeavesRuleEmployee.LeaveRuleID; cmd.Parameters.Add("@LeaveRuleID", SqlDbType.Int).Value = hR_LeavesRuleEmployee.LeaveRuleID; cmd.Parameters.Add("@LeaveRuleID", SqlDbType.Int).Value = hR_LeavesRuleEmployee.LeaveRuleID; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_LeavesRuleEmployee.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_LeavesRuleEmployee.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public static bool UpdateHR_LeavesRuleEmployee(HR_LeavesRuleEmployee hR_LeavesRuleEmployee) { SqlHR_LeavesRuleEmployeeProvider sqlHR_LeavesRuleEmployeeProvider = new SqlHR_LeavesRuleEmployeeProvider(); return sqlHR_LeavesRuleEmployeeProvider.UpdateHR_LeavesRuleEmployee(hR_LeavesRuleEmployee); }
public HR_LeavesRuleEmployee GetHR_LeavesRuleEmployeeFromReader(IDataReader reader) { try { HR_LeavesRuleEmployee hR_LeavesRuleEmployee = new HR_LeavesRuleEmployee ( DataAccessObject.IsNULL<int>(reader["LeavesRuleEmployeeID"]), DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()), DataAccessObject.IsNULL<int>(reader["LeaveRuleID"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_LeavesRuleEmployee; } catch(Exception ex) { return null; } }