Comments by Member 123CC (Top 9 by date)

public List<getsal> GetEmployeMotnhlySalary(decimal Perdaysalary, string sDesignation)
{
getsal obj = new getsal();

try
{

var EmployeSalarylist = t.Tbl_ResourceTimeSheet.Select(x => new { x.WorkOrderNO, x.Designation, x.ResourceName, x.ResourceID, x.EmployeeID, x.AttendencePeriod, x.NumberofDaysWorked, x.NumberofDaysInMonth, x.Remarks, x.Month, x.Year }).Where(x => x.WorkOrderNO == ddlWorkOrder.Text && x.Month == DLMonth.Text && x.Year == DLYear.Text && x.Designation == sDesignation).ToList();


foreach (var item in EmployeSalarylist)
{

//getsal obj = new getsal();
obj.OrderNO = item.WorkOrderNO;
obj.Name = item.ResourceName;

obj.EmpID = item.EmployeeID;
obj.AttendedDays = item.NumberofDaysWorked;
obj.WorkingDays = item.NumberofDaysInMonth;
obj.Remarks = item.Remarks;
decimal DEBITAMT = Math.Round((Convert.ToDecimal(item.NumberofDaysWorked) * Perdaysalary), 0);

//obj.Month = item.Month;
//obj.Year = item.Year;
obj.AttendencePeriod = item.AttendencePeriod;
obj.Renumeration = TxtSalary.Text;
obj.ActualRenumeration = DEBITAMT;
obj.EPF = Math.Round(((DEBITAMT * Convert.ToDecimal(txtEmployershareEPF.Text)) / 100), 0);
if ((txtEmployershareESI.Text).Trim() != "0")
{
obj.ESI = Math.Round(((DEBITAMT * (Convert.ToDecimal(txtEmployershareESI.Text))) / 100), 0);
}
obj.AgencyCommision = Math.Round(((DEBITAMT * Convert.ToDecimal(txtAgencyCommission.Text)) / 100), 0);

decimal WithTax = (DEBITAMT + obj.EPF + obj.ESI + obj.AgencyCommision);
obj.SubTotal = WithTax;
obj.ServiceTax = Math.Round(((WithTax * Convert.ToDecimal(txtServiceTAX.Text)) / 100), 0);
obj.Sbc = Math.Round(((WithTax * Convert.ToDecimal(TxtSbc.Text)) / 100), 0);
obj.Total = Math.Round((WithTax + obj.ServiceTax + obj.Sbc), 0);
li.Add(obj);

}

}
catch (Exception ex)
{

}

return li;

}