private void BindGrid()
{
List <Models.MPaidSalary> Get = new List <Models.MPaidSalary>();
Get = (List <Models.MPaidSalary>)HttpContext.Current.Cache["PaidSalary"];
if (Get == null)
{
Classes.CPaidSalary cp = new Classes.CPaidSalary();
Get = cp.GetAll();
HttpContext.Current.Cache["PaidSalary"] = Get;
}
int FiscalYearId = Convert.ToInt32(Session["FiscalYear"]);
Classes.CFiscalYear cf = new Classes.CFiscalYear();
List <DateTime> Dates = cf.GetDefaultDatesById(FiscalYearId);
Get = (from o in Get
where Convert.ToDateTime(o.MonthPaid) >= Dates[0] && Convert.ToDateTime(o.MonthPaid) <= Dates[1]
select o).ToList();
grdVendor.DataSource = Get;
grdVendor.DataBind();
}
private int SavePaymentOfEmployee()
{
int AccountId = Convert.ToInt32(ddlAccount.SelectedValue);
int CashAccountId = Convert.ToInt32(ddlCashAccount.SelectedValue);
string EmployeeId = ddlEmployee.SelectedValue;
string MonthPaid = txtMonth.Text;
string SalaryId = Session["WareHouse"].ToString();
string Paid = txtPaidAmount.Text;
string DatePaid = txtDateOfPayment.Text;
Classes.CPaidSalary cp = new Classes.CPaidSalary();
Models.MPaidSalary mp = new Models.MPaidSalary();
mp.EmployeeId = EmployeeId;
mp.MonthPaid = MonthPaid;
mp.Paid = Paid;
mp.SalaryId = SalaryId;
mp.DatePaid = DatePaid;
int option = Convert.ToInt32(ddlOption.SelectedValue);
if (option < 1)
{
return(-4);
}
if (cp.Save(mp) > 0)
{
switch (option)
{
case 1:
{
Classes.CBankOfAccount cab = new Classes.CBankOfAccount();
Classes.CAccountTransaction cat = new Classes.CAccountTransaction();
Models.MAccountTransaction mat = new Models.MAccountTransaction();
float AccountTotal = cab.ReturnTotalOfAccountById(AccountId);
AccountTotal = AccountTotal - Convert.ToSingle(Paid);
if (cab.SetNewAccountTotal(AccountId, AccountTotal) > 0)
{
// float PreviousAccountTotal = cab.ReturnTotalOfAccountById(AccountId);
mat.AccountId = AccountId.ToString();
mat.Credit = "0";
mat.CurrentTransaction = "-1";
mat.Debit = Paid;
mat.Description = "Paid Salary for the month of [" + MonthPaid + "] to " +
"Employee[" + ddlEmployee.SelectedItem.Text + "] Amount [" + Paid + "]";
mat.eDate = Convert.ToDateTime(DatePaid);
mat.FiscalYearId = Convert.ToInt32(Session["FiscalYear"]).ToString();
// PreviousAccountTotal = PreviousAccountTotal - Convert.ToSingle(Paid);
mat.Total = AccountTotal.ToString();
if (cat.Save(mat) > 0)
{
Classes.CJournal cj = new Classes.CJournal();
Models.MJournal mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.SalaryExpense).ToString();
mj.amount = mp.Paid;
mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] ";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Debit.ToString();
cj.Save(mj);
mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash).ToString();
mj.amount = mp.Paid;
mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] ";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Credit.ToString();
cj.Save(mj);
return(1);
}
else
{
return(-3);
}
}
else
{
return(-2);
}
}
case 2:
{
Classes.CCashAccount cab = new Classes.CCashAccount();
Classes.CCashTransaction cat = new Classes.CCashTransaction();
Models.MCashTransactions mat = new Models.MCashTransactions();
float AccountTotal = cab.ReturnTotalOfCashAccount(CashAccountId);
AccountTotal = AccountTotal - Convert.ToSingle(Paid);
if (cab.SetNewAccountTotal(CashAccountId, AccountTotal) > 0)
{
// float PreviousAccountTotal = cab.ReturnTotalOfAccountById(AccountId);
mat.CashAccountId = CashAccountId;
mat.Credit = "0";
mat.Debit = Paid;
mat.Description = "Paid Salary for the month of [" + MonthPaid + "] to " +
"Employee[" + ddlEmployee.SelectedItem.Text + "] Amount [" + Paid + "]";
if (cat.Save(mat) > 0)
{
Classes.CJournal cj = new Classes.CJournal();
Models.MJournal mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.SalaryExpense).ToString();
mj.amount = mp.Paid;
mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] ";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Debit.ToString();
cj.Save(mj);
mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash).ToString();
mj.amount = mp.Paid;
mj.des = "Payment of Employee [" + ddlEmployee.SelectedItem.Text + "] ";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Credit.ToString();
cj.Save(mj);
return(1);
}
else
{
return(-3);
}
}
else
{
return(-2);
}
}
default:
return(-5);
}
}
else
{
return(-1);
}
}
