private void SaveCommission(TRecPeriod recPeriod, EnumCommissionType enumCommissionType, EnumDepartment department, MEmployee mEmployee, int level, decimal?commissionFactor, decimal?commissionValue, string desc = null)
{
TCommission comm = new TCommission();
comm.SetAssignedIdTo(Guid.NewGuid().ToString());
comm.CommissionLevel = level;
comm.CommissionFactor = commissionFactor;
comm.CommissionValue = commissionValue;
comm.EmployeeId = mEmployee;
comm.CommissionType = enumCommissionType.ToString();
comm.CommissionStatus = department.ToString();
comm.RecPeriodId = recPeriod;
comm.CommissionDesc = desc;
comm.CreatedBy = User.Identity.Name;
comm.CreatedDate = DateTime.Now;
comm.DataStatus = EnumDataStatus.Updated.ToString();
_tCommissionRepository.Save(comm);
}
public MCommission GetCommissionByDate(EnumDepartment department, DateTime?startDate, DateTime?endDate)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@" from MCommission as comm ");
sql.AppendLine(@" where comm.CommissionStatus = :department ");
sql.AppendLine(@" and comm.CommissionStartDate <= :startDate ");
sql.AppendLine(@" and comm.CommissionEndDate >= :endDate ");
string query = string.Format(" select comm {0} ", sql);
IQuery q = Session.CreateQuery(query);
q.SetString("department", department.ToString());
q.SetDateTime("startDate", startDate.Value);
q.SetDateTime("endDate", endDate.Value);
q.SetMaxResults(1);
MCommission comm = q.UniqueResult <MCommission>();
return(comm);
}