public void BindSalary(int Id)
{
try
{
List <EntityAllowanceDeduction> lst = mobjSalBLL.GetDeductionsForEdit(Id);
DgvAllowance.DataSource = lst;
DgvAllowance.DataBind();
Session["FromEdit"] = lst;
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
decimal totalAllowances = 0;
decimal totalDed = 0;
tblEmployee objFac = mobjSalBLL.GetEmployee(Convert.ToInt32(ddlEmployee.SelectedValue));
if (objFac != null)
{
tblSalary obj = new tblSalary();
if (chkIspayment.Checked == true)
{
obj.IsPaymentDone = true;
}
else
{
obj.IsPaymentDone = false;
}
if (mobjSalBLL.ValidateAllocation(obj, Convert.ToInt32(Session[" LedgerId"])))
{
tblSalary sal = new tblSalary();
List <tblSalaryDetail> lst = new List <tblSalaryDetail>();
foreach (GridViewRow item in DgvAllowance.Rows)
{
lst.Add(new tblSalaryDetail {
SalDetail_Id = Convert.ToInt32(item.Cells[0].Text), SalDate = Convert.ToDateTime(txtDos.Text), SalId = Convert.ToInt32(Session["LedgerId"]), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text)
});
totalAllowances += Convert.ToDecimal(item.Cells[3].Text);
}
foreach (GridViewRow item in dgvDeduction.Rows)
{
lst.Add(new tblSalaryDetail {
SalDetail_Id = Convert.ToInt32(item.Cells[0].Text), SalDate = Convert.ToDateTime(txtDos.Text), SalId = Convert.ToInt32(Session["LedgerId"]), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text)
});
totalDed += Convert.ToDecimal(item.Cells[3].Text);
}
//List<tblSalaryDetail> lstDeletedAllDed = new List<tblSalaryDetail>();
List <EntityAllowanceDeduction> lstDel = (List <EntityAllowanceDeduction>)Session["FromEdit"];
List <EntityAllowanceDeduction> lstDelDed = (List <EntityAllowanceDeduction>)Session["FromEditDeduction"];
foreach (EntityAllowanceDeduction item in lstDel)
{
if (item.IsDelete)
{
lst.Add(new tblSalaryDetail()
{
AllowanceDeduction_Id = item.AllowDedId, SalId = Convert.ToInt32(Session["LedgerId"]), IsDelete = item.IsDelete, Amount = item.Amount
});
}
}
foreach (EntityAllowanceDeduction item in lstDelDed)
{
if (item.IsDelete)
{
lst.Add(new tblSalaryDetail()
{
AllowanceDeduction_Id = item.AllowDedId, SalId = Convert.ToInt32(Session["LedgerId"]), IsDelete = item.IsDelete, Amount = item.Amount
});
}
}
decimal netPay = totalAllowances - totalDed;
decimal dayPayment = netPay / Convert.ToInt32(txtDays.Text);
decimal hours = dayPayment / 8;
decimal Payment = Convert.ToInt32(txtOTHours.Text) * decimal.Round(hours, 2);
decimal monthpayment = dayPayment * Convert.ToDecimal(txtAttendDays.Text);
decimal NetPayment = monthpayment + Payment;
obj.IsPaymentDone = chkIspayment.Checked;
obj.SalId = Convert.ToInt32(Session["LedgerId"]);
obj.LeavesTaken = Convert.ToInt32(txtLeavesTaken.Text);
obj.OTHours = Convert.ToInt32(txtOTHours.Text);
obj.Attend_Days = Convert.ToInt32(txtAttendDays.Text);
obj.NetPayment = decimal.Round(NetPayment, 0);
mobjSalBLL.Update(obj, lst);
lblMessage.Text = "Record Updated successfully.";
List <EntityAllowanceDeduction> lstallow = new List <EntityAllowanceDeduction>();
List <EntityAllowanceDeduction> lstded = new List <EntityAllowanceDeduction>();
DgvAllowance.DataSource = lstallow;
DgvAllowance.DataBind();
dgvDeduction.DataSource = lstded;
dgvDeduction.DataBind();
BindSalaryAllocation();
Session["FromEditDeduction"] = null;
Session["FromEdit"] = null;
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
MultiView1.SetActiveView(View1);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
bool flag = false;
foreach (GridViewRow item in DgvAllowance.Rows)
{
bool IsBasic = mobjSalBLL.CheckIsBasic(Convert.ToInt32(item.Cells[1].Text));
if (IsBasic)
{
flag = true;
break;
}
else
{
flag = false;
}
}
if (!flag)
{
lblMsg.Text = "You shuould be add Basic in Salary";
return;
}
tblSalary sal = new tblSalary();
EntitySalaryDetails obj = new EntitySalaryDetails();
EntitySalary salobj = new EntitySalary();
sal.EmpId = Convert.ToInt32(ddlEmployee.SelectedValue);
sal.SalDate = Convert.ToDateTime(txtDos.Text);
sal.Sal_Month = string.Format("{0:MMM-yyyy}", txtMonth.Text);
sal.No_of_Days = Convert.ToInt32(txtDays.Text);
sal.Attend_Days = Convert.ToInt32(txtAttendDays.Text);
sal.LeavesTaken = Convert.ToInt32(txtLeavesTaken.Text);
sal.OTHours = Convert.ToInt32(txtOTHours.Text);
decimal day = Convert.ToDecimal(txtNetAmount.Text) / Convert.ToDecimal(txtDays.Text);
decimal month = day * Convert.ToDecimal(txtAttendDays.Text);
decimal hour = day / 8;
decimal tothour = Convert.ToInt32(txtOTHours.Text) * decimal.Round(hour, 2);
decimal payment = Convert.ToDecimal(month + tothour);
txtNetAmount.Text = Convert.ToString(payment);
sal.NetPayment = decimal.Round(payment, 0);
if (chkIspayment.Checked == true)
{
sal.IsPaymentDone = true;
}
else
{
sal.IsPaymentDone = false;
}
tblEmployee objFac = mobjSalBLL.GetEmployee(Convert.ToInt32(ddlEmployee.SelectedValue));
if (objFac != null)
{
tblSalary objExist = mobjSalBLL.CheckExistRecord(objFac.PKId, Convert.ToString(txtMonth.Text));
if (objExist == null)
{
if (mobjSalBLL.ValidateAllocation(sal))
{
List <tblSalaryDetail> lst = new List <tblSalaryDetail>();
foreach (GridViewRow item in DgvAllowance.Rows)
{
lst.Add(new tblSalaryDetail {
SalDate = Convert.ToDateTime(txtDos.Text), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text)
});
}
foreach (GridViewRow item in dgvDeduction.Rows)
{
lst.Add(new tblSalaryDetail {
SalDate = Convert.ToDateTime(txtDos.Text), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text)
});
}
int SalId = Convert.ToInt32(mobjSalBLL.Save(sal, lst));
lblMessage.Text = "Record Saved Successfully.....";
Clear();
}
}
else
{
Clear();
List <EntityAllowanceDeduction> lst = new List <EntityAllowanceDeduction>();
List <EntityAllowanceDeduction> lstded = new List <EntityAllowanceDeduction>();
DgvAllowance.DataSource = lst;
DgvAllowance.DataBind();
dgvDeduction.DataSource = lstded;
dgvDeduction.DataBind();
lblMsg.Text = string.Empty;
MultiView1.SetActiveView(View1);
lblMessage.Text = "Salary Is Already Allocated To Employee!!";
}
}
else
{
lblMsg.Text = "Invalid Employee";
}
Session["allowance"] = new List <EntityAllowanceDeduction>();
Session["Deduction"] = new List <EntityAllowanceDeduction>();
BindSalaryAllocation();
MultiView1.SetActiveView(View1);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void btnAllowAdd_Click(object sender, EventArgs e)
{
try
{
if (ddlAllowance.SelectedIndex > 0)
{
List <EntityAllowanceDeduction> lst = null;
//DgvAllowance.DataSource = null;
//DgvAllowance.DataBind();
//dgvDeduction.DataSource = null;
//dgvDeduction.DataBind();
if (Convert.ToString(Session["MyFlag"]).Equals("ADD", StringComparison.CurrentCultureIgnoreCase))
{
lst = (List <EntityAllowanceDeduction>)Session["allowance"];
}
else
{
lst = (List <EntityAllowanceDeduction>)Session["FromEdit"];
}
if (lst != null)
{
int cnt = (from tbl in lst
where tbl.AllowDedId == Convert.ToInt32(ddlAllowance.SelectedValue)
select tbl).ToList().Count;
if (cnt > 0)
{
lblMsg.Text = "This Allowance is Already Added";
}
else
{
lst.Add(new EntityAllowanceDeduction()
{
Description = Convert.ToString(ddlAllowance.SelectedItem.Text), Amount = Convert.ToDecimal(txtAllowAmount.Text), AllowDedId = Convert.ToInt32(ddlAllowance.SelectedValue), SalDetail_Id = 0
});
if (Convert.ToString(Session["MyFlag"]).Equals("ADD", StringComparison.CurrentCultureIgnoreCase))
{
Session["allowance"] = lst;
}
else
{
Session["FromEdit"] = lst;
}
DgvAllowance.DataSource = lst;
DgvAllowance.DataBind();
txtNetAmount.Text = Convert.ToString(Convert.ToDecimal(txtNetAmount.Text) + Convert.ToDecimal(txtAllowAmount.Text));
ddlAllowance.SelectedIndex = 0;
txtAllowAmount.Text = string.Empty;
}
}
else
{
lst.Add(new EntityAllowanceDeduction()
{
Description = Convert.ToString(ddlAllowance.SelectedItem.Text), Amount = Convert.ToDecimal(txtAllowAmount.Text), AllowDedId = Convert.ToInt32(ddlAllowance.SelectedValue), SalDetail_Id = 0
});
if (Convert.ToString(Session["MyFlag"]).Equals("ADD", StringComparison.CurrentCultureIgnoreCase))
{
Session["allowance"] = lst;
}
else
{
Session["FromEdit"] = lst;
}
DgvAllowance.DataSource = lst;
DgvAllowance.DataBind();
txtNetAmount.Text = Convert.ToString(Convert.ToDecimal(txtNetAmount.Text) + Convert.ToDecimal(txtAllowAmount.Text));
ddlAllowance.SelectedIndex = 0;
txtAllowAmount.Text = string.Empty;
}
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
ImageButton imgDelete = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgDelete.NamingContainer;
Session["Delete_Charge"] = Convert.ToInt32(row.Cells[1].Text);
decimal amt = Convert.ToDecimal(row.Cells[3].Text);
List <EntityAllowanceDeduction> lstFinal = new List <EntityAllowanceDeduction>();
bool IsRemoveBasic = mobjSalBLL.CheckIsBasic(Convert.ToInt32(row.Cells[1].Text));
if (IsRemoveBasic)
{
lblMsg.Text = "You are not allowed to remove Basic.";
return;
}
if (Session["MyFlag"] == "ADD")
{
List <EntityAllowanceDeduction> lst = (List <EntityAllowanceDeduction>)Session["allowance"];
foreach (EntityAllowanceDeduction item in lst)
{
if (item.AllowDedId != Convert.ToInt32(row.Cells[1].Text))
{
lstFinal.Add(item);
}
}
Session["allowance"] = lstFinal;
txtNetAmount.Text = Convert.ToString(Convert.ToDecimal(txtNetAmount.Text) - amt);
DgvAllowance.DataSource = Session["allowance"];
DgvAllowance.DataBind();
}
if (Session["MyFlag"] == "Edit")
{
List <EntityAllowanceDeduction> lst = (List <EntityAllowanceDeduction>)Session["FromEdit"];
if (IsRemoveBasic)
{
lblMsg.Text = "You are not allowed to remove Basic.";
}
foreach (EntityAllowanceDeduction item in lst)
{
if (item.AllowDedId != Convert.ToInt32(row.Cells[1].Text))
{
item.IsDelete = false;
}
else
{
item.IsDelete = true;
}
lstFinal.Add(item);
}
Session["FromEdit"] = lstFinal;
txtNetAmount.Text = Convert.ToString(Convert.ToDecimal(txtNetAmount.Text) - amt);
}
DgvAllowance.DataSource = lstFinal.Where(p => p.IsDelete == false).ToList();
DgvAllowance.DataBind();
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
