private static SalaryEntity ProjectTo(Salary source, SalaryEntity destination) { destination.Amount = source.Value.Amount; destination.CurrencyCode = source.Value.Currency.Code; destination.ReceivedAt = source.ReceivedAt; return(destination); }
private Salary Map(SalaryEntity source) { return(new Salary( source.SalaryId, new Money(source.Amount, _currencyProvider.Provide(source.CurrencyCode)), source.ReceivedAt )); }
/// <summary> /// Takes the specified receipt voucher. /// </summary> /// <param name="salary">The receipt voucher.</param> /// <returns></returns> private object[] Take(SalaryEntity salary) { return(new object[] { @"EmployeePayrollID", salary.EmployeePayrollId, @"RefTypeID", salary.RefTypeId, @"RefNo", salary.RefNo, @"RefDate", salary.RefDate, @"PostedDate", salary.PostedDate, @"TotalAmountOC", salary.TotalAmountOc, @"JournalMemo", salary.JournalMemo, @"CurrencyCode", salary.CurrencyCode, @"EmployeeID", salary.EmployeeId, @"EmployeePayItemID", salary.EmployeePayItemId, @"ExchangeRate", salary.ExchangeRate, @"TotalAmountExchange", salary.TotalAmountExchange }); }
public void UpdateSalary(DBSite site, SalaryEntity sal) { string qry = " UPDATE tblSalary SET " + " designationId =" + sal.DesignationId + ", YearNo = " + sal.YearNo + ", MonthNo = " + sal.MonthNo + " , BasicSalary =" + sal.BasicSalary + " , Conveyance =" + sal.Conveyance + " , EPF =" + sal.epf + " , ESI =" + sal.esi + " , EMI =" + sal.emi + " , StaffId =" + sal.StaffId + " , UserID =" + Util_BLL.User.UserId + " , FYear = " + Util_BLL.User.fYear + " WHERE SalaryId =" + sal.SalaryId; site.Execute(qry); }
public void SaveBasicSalary(DBSite site, SalaryEntity bs) { string qry = "INSERT INTO tblSalary(DesignationId, YearNo, MonthNo " + " , BasicSalary, Conveyance " + " , EPF, ESI, EMI " + " , StaffId " + ", UserID, FYear) VALUES("; qry += bs.DesignationId + ", " + bs.YearNo + ", " + bs.MonthNo + ", " + bs.BasicSalary + ", " + bs.Conveyance + ", " + bs.epf + ", " + bs.esi + ", " + bs.emi + ", " + bs.StaffId + ", " + Util_BLL.User.UserId + ", " + Util_BLL.User.fYear + ")"; site.Execute(qry); }
public List <SalaryEntity> GetSalaries(DBSite site, int salaryID = -1) { List <SalaryEntity> salList = new List <SalaryEntity>(); string qry = ""; qry += " SELECT SalaryID, sa.DesignationID, Designation, YearNo, MonthNo, BasicSalary "; qry += " , conveyance, EPF, ESI, EMI, StaffID, st.StudentName "; qry += " , sa.userID, sa.FYear "; qry += " FROM tblSalary as sa " + " LEFT OUTER JOIN tblStudentMaster st on st.StudentMasterID = sa.staffID " + " LEFT OUTER JOIN tblDesignation d ON d.designationId = sa.designationId " + " WHERE sa.UserID = " + Util_BLL.User.UserId; if (salaryID != -1) { qry += " AND SalaryID = " + salaryID; } else { qry += " AND SalaryId IN (SELECT MAX(SalaryID) FROM tblSalary GROUP BY StaffID) "; } DataTable dt = site.ExecuteSelect(qry); SalaryEntity sal; foreach (DataRow dr in dt.Rows) { sal = new SalaryEntity(); sal.SalaryId = util.CheckNullInt(dr["SalaryID"]); sal.StaffId = util.CheckNullInt(dr["StaffId"]); sal.StaffName = util.CheckNull(dr["StudentName"]); sal.DesignationId = util.CheckNullInt(dr["DesignationId"]); sal.Designation = util.CheckNull(dr["Designation"]); sal.YearNo = util.CheckNullInt(dr["YearNo"]); sal.MonthNo = util.CheckNullInt(dr["MonthNo"]); sal.BasicSalary = util.CheckNullDouble(dr["BasicSalary"]); sal.Conveyance = util.CheckNullDouble(dr["Conveyance"]); sal.epf = util.CheckNullDouble(dr["epf"]); sal.esi = util.CheckNullDouble(dr["esi"]); sal.emi = util.CheckNullDouble(dr["emi"]); sal.UserID = util.CheckNullInt(dr["UserID"]); sal.FYear = util.CheckNullInt(dr["FYear"]); salList.Add(sal); } return(salList); }
/// <summary> /// Gets the salary. /// </summary> /// <param name="refId">The reference identifier.</param> /// <returns></returns> //public SalaryEntity GetSalary(long refId) //{ // const string procedures = @"uspGet_Salary_ByID"; // object[] parms = { "@SalaryID", refId }; // return Db.Read(procedures, true, Make, parms); //} /// <summary> /// Inserts the salary. /// </summary> /// <param name="salary">The salary.</param> /// <returns></returns> public int CalSalary(SalaryEntity salary) { const string sql = @"uspInsert_CalSalary_EmployeePayroll"; return(Db.Insert(sql, true, Take(salary))); }