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();
}
}
protected override void Update()
{
using (TransactionScope ts = new TransactionScope())
{
List <SearchCondition> conditions = new List <SearchCondition>();
conditions.Add(SearchCondition.CreateSearchCondition(GlobalParams.PKLeaveInfoID, PKLeaveInfoID.ToString(), SearchComparator.Equal, SearchType.SearchString));
CommonDAL <LeaveInfo> .Update(this, conditions);
foreach (TimeDurationInfo item in timeDurationList)
{
if (item.IsNew)
{
item.FKLeaveInfoID = this.PKLeaveInfoID;
}
item.Save();
}
//#region For transact unit test
//throw new Exception();
//#endregion
if (this.PreStatus != LeaveStatus.Accepted && this.Status == LeaveStatus.Accepted ||
this.status == LeaveStatus.Rejected && this.PreStatus == LeaveStatus.Accepted)
{
int year;
double usedHours = GetDurationHours(timeDurationList, out year);
if (usedHours != 0 && year != 0)
{
conditions.Clear();
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);
if (null == leaveSummary)
{
leaveSummary = EmployeeLeaveSummary.CreateEmployeeLeaveSummary(FKSubmitEmployeeID, FKLeaveTypeID, year);
}
if (this.status == LeaveStatus.Rejected)
{
usedHours = -usedHours;
}
leaveSummary.UsedHours += usedHours;
if (leaveSummary.UsedHours < 0)
{
leaveSummary.UsedHours = 0; // used hours cannot be a negative number
}
leaveSummary.Save();
}
}
ts.Complete();
}
}
public static EmployeeLeaveSummary CreateEmployeeLeaveSummary(Guid fkEmployeeID, Guid fkLeaveTypeID, int year)
{
EmployeeLeaveSummary emLeaveSummary = new EmployeeLeaveSummary();
emLeaveSummary.FKEmployeeID = fkEmployeeID;
emLeaveSummary.FKLeaveTypeID = fkLeaveTypeID;
emLeaveSummary.Year = year;
return(emLeaveSummary);
}
protected override void Insert()
{
using (TransactionScope ts = new TransactionScope())
{
CommonDAL <LeaveInfo> .Insert(this);
foreach (TimeDurationInfo item in timeDurationList)
{
item.FKLeaveInfoID = this.PKLeaveInfoID;
item.Save();
}
//#region For transact unit test
//throw new Exception();
//#endregion
// When the leave is accepted, update the employee leave summary.
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);
if (null == leaveSummary)
{
leaveSummary = EmployeeLeaveSummary.CreateEmployeeLeaveSummary(FKSubmitEmployeeID, FKLeaveTypeID, year);
}
leaveSummary.UsedHours += usedHours;
leaveSummary.Save();
}
}
ts.Complete();
}
}
