public List <BankOperationVModel> GetAllRemittances(DateTime dateTime, string branchCode, string bankAccode)
{
branchCode = Session["BranchCode"].ToString();
// bankAccode = Session["BankAccode"].ToString();
var bank = new List <BankOperationVModel>();
int i = 0;
_HORemitService.All().ToList().Where(x => x.BranchCode == branchCode && x.bankAccode == bankAccode &&
x.RemitDate.ToString("MM-dd-yyyy") == dateTime.ToString("MM-dd-yyyy")).ToList().ForEach(x => bank.Add(
new BankOperationVModel(++i, "H/O Remittance", x.Amount, x.RemitNo, "RT", x.VoucherNo)));
_BankReceiptAppService.All().ToList().Where(x => x.BranchCode == branchCode && x.bankAccode == bankAccode &&
x.BReceiptDate.ToString("MM-dd-yyyy") == dateTime.ToString("MM-dd-yyyy")).ToList().ForEach(x => bank.Add(
new BankOperationVModel(++i, x.NewChart.AcName, x.Amount, x.BReceiptNo, "BR", x.VoucherNo)));
_DepositToBankService.All().ToList().Where(x => x.BranchCode == branchCode && x.bankAccode == bankAccode &&
x.DepositDate.ToString("MM-dd-yyyy") == dateTime.ToString("MM-dd-yyyy")).ToList().ForEach(x => bank.Add(
new BankOperationVModel(++i, "Deposit To Bank", x.Amount, x.DepositNo, "BD", x.VoucherNo)));
return(bank);
}
public ActionResult DelBankOperation(string tag, string transactionNo, string dateTime)
{
if (tag == "RT")
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Remittance_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
}
if (tag == "BR")
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankReceipt_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
}
if (tag == "BP")
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankPayment_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
string branchCode = Session["BranchCode"].ToString();
string bankAccode = Session["BankAccode"].ToString();
switch (tag)
{
case "RT":
{
var hoRemit = _hoRemitService.All().ToList().FirstOrDefault(x => x.RemitNo == transactionNo.Trim());
if (hoRemit != null)
{
using (var transaction = new TransactionScope())
{
try
{
_hoRemitService.Delete(hoRemit);
_hoRemitService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "H/O Remittance", "Delete", hoRemit.RemitNo, User.Identity.Name);
var entryNo = hoRemit.RemitNo;
// var entryNo = Convert.ToInt64(hoRemit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
LoadDropDown.journalVoucherRemoval("RT", entryNo, hoRemit.VoucherNo, hoRemit.FinYear);
CashOPVM = GetAllRemittances(Convert.ToDateTime(dateTime), branchCode, bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
case "BR":
{
var bankReceipt = _BankReceiptAppService.All().ToList().FirstOrDefault(x => x.BReceiptNo == transactionNo.Trim());
if (bankReceipt != null)
{
//bankReceipt.BranchCode = Session["BranchCode"].ToString();
//bankReceipt.FinYear = Session["FinYear"].ToString();
//bankReceipt.bankAccode = Session["BankAccode"].ToString();
//bankReceipt.NewChart = _newChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.purAccode.Trim());
//bankReceipt.bankNewChart = _newChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.bankAccode.Trim());
using (var transaction = new TransactionScope())
{
try
{
_BankReceiptAppService.Delete(bankReceipt);
_BankReceiptAppService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Bank Receipt", "Delete", bankReceipt.BReceiptNo, User.Identity.Name);
var entryNo = bankReceipt.BReceiptNo;
// var entryNo = Convert.ToInt64(bankReceipt.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
LoadDropDown.journalVoucherRemoval("BR", entryNo, bankReceipt.VoucherNo, bankReceipt.FinYear);
CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
case "BW":
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
case "BP":
{
var payment = _paymentService.All().ToList().FirstOrDefault(x => x.PayCode == transactionNo.Trim());
if (payment != null)
{
using (var transaction = new TransactionScope())
{
try
{
_paymentService.Delete(payment);
_paymentService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Expene", "Delete", payment.PayCode, User.Identity.Name);
var entryNo = payment.PayCode;
// var entryNo = Convert.ToInt64(payment.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
LoadDropDown.journalVoucherRemoval("BP", entryNo, payment.VoucherNo, payment.FinYear);
CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
case "BD":
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
default:
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SaveBankReceipt(BankReceipt bankReceipt)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankReceipt_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
try
{
var IfExit = _BankReceiptAppService.All().Where(x => x.BReceiptNo == bankReceipt.BReceiptNo).FirstOrDefault();
if (IfExit == null)
{
if (!string.IsNullOrEmpty(bankReceipt.purAccode) && bankReceipt.purAccode.Trim() != "Select Purpose")
{
bankReceipt.BranchCode = Session["BranchCode"].ToString();
bankReceipt.bankAccode = Session["BankAccode"].ToString();
bankReceipt.FinYear = Session["FinYear"].ToString();
bankReceipt.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.purAccode.Trim());
bankReceipt.bankNewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.bankAccode.Trim());
var openBal = GetOpenBal(bankReceipt.BReceiptDate);
var rcecBal = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode).Sum(x => x.Amount);
var payTotal = GetAllPayment(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode).Sum(x => x.Amount);
var closBal = openBal + rcecBal - payTotal;
BankOperation bankOperation = new BankOperation(bankReceipt.BReceiptDate, openBal, bankReceipt.Amount, 0.0, closBal, bankReceipt.BranchCode, bankReceipt.FinYear, false, bankReceipt.bankAccode);
//cashReceipt.Customer = _CustomerService.All().ToList().FirstOrDefault(x => x.CustCode == cashReceipt.CustCode);
//BankOperation bankOperation = new BankOperation(bankReceipt.BReceiptDate, 0.0, 0.0, 0.0, 0.0, bankReceipt.BranchCode, bankReceipt.FinYear, false, bankReceipt.bankAccode);
var isAlreadySaved = _BankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == bankReceipt.BReceiptDate.ToString("MM-dd-yyyy") && x.BranchCode == bankReceipt.BranchCode && x.bankAccode == bankReceipt.bankAccode);
if (isAlreadySaved == null)
{
using (var transaction = new TransactionScope())
{
try
{
_BankOperationService.Add(bankOperation);
_BankOperationService.Save();
_BankReceiptAppService.Add(bankReceipt);
_BankReceiptAppService.Save();
//insert to provision
LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "BankReceipt", "Save", bankReceipt.BReceiptNo, User.Identity.Name);
CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
else
{
var rcecBals = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode).Sum(x => x.Amount);
isAlreadySaved.RecTotal = rcecBals + bankReceipt.Amount;
isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal;
using (var transaction = new TransactionScope())
{
try
{
_BankOperationService.Update(isAlreadySaved);
_BankReceiptAppService.Save();
_BankReceiptAppService.Add(bankReceipt);
_BankReceiptAppService.Save();
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString());
}
//insert to provision
LoadDropDown.BankRecalculate(bankReceipt.BReceiptDate, Convert.ToDecimal(bankReceipt.Amount), Session["ProjCode"].ToString(), bankReceipt.BranchCode, bankReceipt.FinYear, bankReceipt.bankAccode);
TransactionLogService.SaveTransactionLog(_transactionLogService, "BankReceipt", "Save", bankReceipt.BReceiptNo, User.Identity.Name);
CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateCheRec(ChequeReceipt CheRec)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("ChequeReceipt_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
var VchrExist = _vchrMainService.All().FirstOrDefault(s => s.VchrNo == CheRec.VchrNo);
var chqArcExist = _chequeArchiveService.All().ToList().Where(x => x.ChqNo == CheRec.oldChqNo).Select(s => s.ChqStatus).ToList();
if (chqArcExist.Contains("Receive") && CheRec.ChqStatus == "Receive" || chqArcExist.Contains("Receive") && CheRec.ChqStatus == "Deposit" || chqArcExist.Contains("Deposit") && CheRec.ChqStatus == "Encash" ||
chqArcExist.Contains("Encash") && CheRec.ChqStatus != "Dishonour" && CheRec.ChqStatus != "Return")
{
if (VchrExist == null)
{
ChequeReceipt cr = new ChequeReceipt();
cr = CheRec;
cr.MRTing = 0;
cr.MRTingTime = null;
cr.ProjCode = Session["ProjCode"].ToString();
cr.FinYear = Session["FinYear"].ToString();
_chequeReceiptService.Update(cr);
_chequeReceiptService.Save();
var chqArc = _chequeArchiveService.All().FirstOrDefault(s => s.ChqNo == CheRec.oldChqNo && s.ChqStatus == CheRec.ChqStatus);
if (chqArc != null && chqArc.ChqStatus == CheRec.ChqStatus)
{
chqArc.ChqNo = CheRec.ChqNo;
chqArc.UpdateBy = CheRec.UpdateBy;
chqArc.UpdateDate = CheRec.UpdateDate;
chqArc.Reason = CheRec.Reason;
chqArc.Remarks = CheRec.Remarks;
_chequeArchiveService.Update(chqArc);
_chequeArchiveService.Save();
}
else
{
ChequeArchive ca = new ChequeArchive();
ca.ChqStatus = CheRec.ChqStatus;
ca.ChqNo = CheRec.ChqNo;
ca.UpdateBy = CheRec.UpdateBy;
ca.UpdateDate = CheRec.UpdateDate;
ca.Reason = CheRec.Reason;
ca.Remarks = CheRec.Remarks;
_chequeArchiveService.Add(ca);
_chequeArchiveService.Save();
}
BankReceipt br = _bankReceiptService.All().Where(s => s.RefNo == CheRec.ChqReceiptNo && s.ChequeNo == CheRec.ChqNo).FirstOrDefault();
if (CheRec.ChqStatus == "Deposit")
{
br.BReceiptDate = CheRec.ChqReceiptDate;
br.purAccode = CheRec.MRAgainst.ToString();
br.RefNo = CheRec.ChqReceiptNo;
br.bankAccode = CheRec.DepositBank;
br.ChequeNo = CheRec.ChqNo;
br.ChequeDate = CheRec.ChqDate;
br.Amount = (double)CheRec.Amount;
br.Advance = false;
br.Remarks = CheRec.Remarks;
br.FinYear = Session["FinYear"].ToString();
br.GLPost = CheRec.GLPost;
br.BranchCode = CheRec.BranchCode;
br.VoucherNo = CheRec.VchrNo;
br.SubCode = CheRec.SubCode;
br.bankCode = CheRec.BankCode;
_bankReceiptService.Update(br);
_bankReceiptService.Save();
}
var MoneyR = _moneyReceiptService.All().Where(s => s.MRNo == CheRec.ChqReceiptNo).FirstOrDefault();
//insert to provision and money receipt table
if (CheRec.ChqStatus == "Encash" && (MoneyR == null ? "000000" : MoneyR.MRNo) != CheRec.ChqReceiptNo)
{
MoneyReceipt MR = new MoneyReceipt();
MR.MRSL = LoadDropDown.GenerateRecvSlNo(_moneyReceiptService, CheRec.BranchCode, Session["BranchCode"].ToString(), CheRec.ProjCode, Session["VchrConv"].ToString());
MR.BranchCode = (CheRec.BranchCode == null) ? Session["BranchCode"].ToString() : CheRec.BranchCode;
MR.ProjCode = (CheRec.ProjCode == null) ? Session["ProjCode"].ToString() : CheRec.ProjCode;
MR.MRNo = CheRec.ChqReceiptNo;
MR.MRDate = CheRec.ChqReceiptDate;
MR.MRAgainst = CheRec.MRAgainst;
MR.VchrNo = CheRec.VchrNo;
MR.PayMode = "Cq";
MR.Posted = CheRec.PostDated;
MR.AdjWithBill = CheRec.AdjWithBill;
MR.MRAmount = CheRec.Amount;
MR.Accode = CheRec.MRAgainst;
MR.CustCode = CheRec.SubCode;
MR.FinYear = Session["FinYear"].ToString();
MR.Remarks = CheRec.Remarks;
MR.JobNo = CheRec.JobNo;
MR.Ca_Bk = CheRec.DepositBank;
MR.ChqNo = CheRec.ChqNo;
MR.ChqDate = CheRec.ChqDate;
MR.EncashDate = CheRec.EncashDate;
MR.DepositBank = CheRec.DepositBank;
_moneyReceiptService.Add(MR);
_moneyReceiptService.Save();
var chqExt = _chqRecExtService.All().ToList().Where(s => s.ChqReceiptID == CheRec.ChqReceiptId);
foreach (var chqExtitem in chqExt)
{
MoneyReceiptExt MRExt = new MoneyReceiptExt();
MRExt.MRId = _moneyReceiptService.All().OrderBy(s => s.MRId).LastOrDefault().MRId;
MRExt.SaleNo = chqExtitem.BillNo;
MRExt.Amount = chqExtitem.BillAmount;
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
}
LoadDropDown.journalVoucherSave("BR", "I", br.BReceiptNo, CheRec.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), CheRec.BranchCode, CheRec.ChqReceiptDate, CheRec.DepositBank, Session["UserName"].ToString());
}
////update to provision
//LoadDropDown.journalVoucherRemoval("BR", CheRec.ChqReceiptNo, CheRec.VchrNo, Session["FinYear"].ToString());
//LoadDropDown.journalVoucherSave("BR", "I", CheRec.ChqReceiptNo, CheRec.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), CheRec.BranchCode, CheRec.ChqReceiptDate, CheRec.DepositBank, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "ChequeReceipt", "Update", CheRec.ChqReceiptNo, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}