public override void Delete() { using (TransactionScope ts = new TransactionScope()) { // If the leave record is accepted we should update the leave summary when we want remove the leave record. // This case only happened in Unit Test as delete method is not allowed to invoke in real business logic. if (this.Status == LeaveStatus.Accepted) { int year; double usedHours = GetDurationHours(timeDurationList, out year); if (usedHours != 0 && year != 0) { List <SearchCondition> conditions = new List <SearchCondition>(); conditions.Add(SearchCondition.CreateSearchCondition(GlobalParams.FKEmployeeID, FKSubmitEmployeeID.ToString(), SearchComparator.Equal, SearchType.SearchString)); conditions.Add(SearchCondition.CreateSearchCondition(GlobalParams.FKLeaveTypeID, FKLeaveTypeID.ToString(), SearchComparator.Equal, SearchType.SearchString)); conditions.Add(SearchCondition.CreateSearchCondition(GlobalParams.Year, year.ToString(), SearchComparator.Equal, SearchType.SearchNotString)); EmployeeLeaveSummary leaveSummary = CommonDAL <EmployeeLeaveSummary> .GetSingleObject(conditions); leaveSummary.UsedHours -= usedHours; leaveSummary.Save(); } } foreach (TimeDurationInfo item in timeDurationList) { item.Delete(); } CommonDAL <LeaveInfo> .Delete(this); ts.Complete(); } }
public bool Delete(TEntity entity) { try { dal.Delete(entity); return(true); } catch (Exception ex) { return(false); throw (ex); } }
public override void Delete() { using (TransactionScope ts = new TransactionScope()) { foreach (EmployeeRoleRL item in employeeRoleList) { item.Delete(); } CommonDAL <Employee> .Delete(this); ts.Complete(); } }
public static bool RecallLeave(string leaveID) { bool result = false; LeaveInfo leave = null; try { if (!string.IsNullOrEmpty(leaveID)) { List <SearchCondition> conditions = new List <SearchCondition>(); conditions.Add(SearchCondition.CreateSearchCondition(GlobalParams.PKLeaveInfoID, leaveID, SearchComparator.Equal, SearchType.SearchString)); leave = CommonDAL <LeaveInfo> .GetSingleObject(conditions); } if (leave == null) { throw new DataException("Record not found in DB"); } else if (leave.Status != LeaveStatus.Applying) { throw new DataException(string.Format("Record has been locked since it's {0} already.", leave.Status.ToString())); } // delete FK time duration first List <SearchCondition> conditionsTimeDuration = new List <SearchCondition>(); conditionsTimeDuration.Add(SearchCondition.CreateSearchCondition(GlobalParams.FKLeaveInfoID, leaveID, SearchComparator.Equal, SearchType.SearchString)); List <TimeDurationInfo> timeDurations = CommonDAL <TimeDurationInfo> .GetObjects(conditionsTimeDuration); for (int i = timeDurations.Count - 1; i >= 0; i--) { CommonDAL <TimeDurationInfo> .Delete(timeDurations[i]); } // delete leave info CommonDAL <LeaveInfo> .Delete(leave); result = true; } catch (Exception ex) { result = false; throw new Exception(ex.Message); } return(result); }
/// <summary> /// 删除记录 /// </summary> /// <param name="tableName">表名</param> /// <param name="where">条件</param> /// <returns></returns> public static bool Delete(string tableName, string where) { int obj = CommonDAL.Delete(tableName, where); return(obj > 0); }
public override void Delete() { CommonDAL <TimeDurationInfo> .Delete(this); }
public override void Delete() { CommonDAL <ReportPeriod> .Delete(this); }
public static void DeleteEmployee(Employee employee) { CommonDAL <Employee> .Delete(employee); }
public override void Delete() { CommonDAL <EmployeeLeaveSummary> .Delete(this); }
public override void Delete() { CommonDAL <Role> .Delete(this); }
public override void Delete() { CommonDAL <EmployeeRoleRL> .Delete(this); }
public override void Delete() { CommonDAL <LeaveType> .Delete(this); }