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)));
}
