public ActionResult Vat6P6Rpt(string errMsg)
{
if (Session["UserID"] != null)
{
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
ViewBag.FinYear = LoadDropDown.LoadAllFinYears(_FYDDService);
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult GetCrNoteByCrNoteNo(string CrNoteNo)
{
HttpResponseMessage response = GlobalVariabls.VatApiClient.GetAsync("VM_CrNote/GetVM_CrNote?CrNoteNo=" + CrNoteNo.ToString()).Result;
VM_CrNote VM_CrNote = response.Content.ReadAsAsync <VM_CrNote>().Result;
string returnValue = "";
if (Convert.ToBoolean(Session["MaintVAT"]) == true)
{
string respse = LoadDropDown.CallApi(ConfigurationManager.AppSettings["VATApiUrl"] + "/api/VAT/" + "GetVM_6P7?TransNo=" + CrNoteNo.ToString(), Session["token"].ToString());
JavaScriptSerializer js = new JavaScriptSerializer();
returnValue = js.Deserialize <string>(respse);
}
return(Json(new { VM_CrNote = VM_CrNote, returnValue = returnValue }, JsonRequestBehavior.AllowGet));
}
// GET: VM_CrNote
public ActionResult VM_CrNote()
{
if (Session["UserID"] != null)
{
ViewBag.Reason = LoadDropDown.LoadCrNoteReason();
ViewBag.NoteList = GetCrNote();
ViewBag.CrNoteNo = GetNewCrNote();
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintVAT = sysSet.MaintVAT;
Session["MaintVAT"] = sysSet.MaintVAT;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Create(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.SubCode = GenerateSubsidiaryCode();
ViewBag.Items = GetSubInfo();
ViewBag.SubType = new SelectList(_subsidiaryTypeAppService.All().ToList(), "TypeCode", "SubType");
ViewBag.CountryCode = LoadDropDown.LoadCountryDDL();
ViewBag.SubGrp = LoadDropDown.LoadSubGrpDDL();
ViewBag.errMsg = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult GetAllDataForOpenBalance(string Proj, string BrCode)
{
try
{
List <OpenBal> OBInfoList = new List <OpenBal>();
OBInfoList = _pR_OpenBalanceService.All().Where(s => s.ProjCode == Proj && s.BranchCode == BrCode).ToList();
// Convert the object member "Acccode" to its name from newChart table
var defAc = LoadDropDown.GetDefAc();
foreach (var item in OBInfoList)
{
item.AccName = _NewChartAppService.All().Where(x => x.Accode == item.Accode).Select(s => s.AcName).FirstOrDefault();
string isAsset = item.Accode.Substring(0, 1);
if (isAsset == defAc.AssAc)
{
item.YrCrBal = 0;
item.YrDrBal = item.OpenBalance;
}
else
{
item.YrDrBal = 0;
item.YrCrBal = item.OpenBalance * (-1);
}
}
Session["mydata"] = OBInfoList;
if (OBInfoList != null)
{
return(Json(new { data = OBInfoList }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { data = new EmptyResult() }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetCustomerWiseSaleSummaryRpt(CustWiseSaleRptSearchVModel saleRpt)
{
if (saleRpt.LocCode == null)
{
saleRpt.LocCode = "";
}
if (saleRpt.RptType == 1)
{
string finYear = Session["FinYear"].ToString();
string JsonResponse = LoadDropDown.CallApi(ConfigurationManager.AppSettings["ApiUrl"] + "/api/" + "CustomerWiseSaleRpt?finYear=" + finYear + "&locCode=" + saleRpt.LocCode.ToString() + "&fdate=" + saleRpt.fDate.ToString("MM/dd/yyyy") + "&tdate=" + saleRpt.toDate.ToString("MM/dd/yyyy"), Session["token"].ToString());
JavaScriptSerializer js = new JavaScriptSerializer();
IEnumerable <CustWiseSummSaleRpt> itemList = js.Deserialize <IEnumerable <CustWiseSummSaleRpt> >(JsonResponse);
if (saleRpt.LocCode != null && saleRpt.LocCode != "0" && saleRpt.LocCode != "")
{
ViewBag.Location = _locationService.All().FirstOrDefault(x => x.LocCode == saleRpt.LocCode.Trim()).LocName.ToString();
}
else
{
ViewBag.Location = "All";
}
ViewBag.fDate = saleRpt.fDate.ToString("dd-MMM-yyyy");
ViewBag.tDate = saleRpt.toDate.ToString("dd-MMM-yyyy");
if (saleRpt.LocCode != null && saleRpt.LocCode != "")
{
Session["LocCode"] = saleRpt.LocCode;
}
Session["RptType"] = saleRpt.RptType;
//ViewBag.LocCode = new SelectList(_locationService.All().ToList(), "LocCode", "LocName");
if (itemList.ToList().Count == 0)
{
string errMsg = "There is no data in this combination. Please try again !!!";
return(RedirectToAction("CustomerWiseSaleRptSearch", "RptSalesPurchase", new { errMsg }));
}
return(View(itemList));
}
else
{
return(View());
}
}
// GET: ProductionRpt
public ActionResult ProductionRpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.ItemType = new SelectList(_itemTypeService.All().ToList(), "ItemTypeCode", "ItemTypeName");
ViewBag.ItemCode = LoadDropDown.LoadItemByItemType("", _CommonVmService);
ViewBag.BranchCode = new SelectList(_branchService.All().ToList(), "BranchCode", "BranchName");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Vat9P1_SF_Ka_2_Rpt(string errMsg)
{
if (Session["UserID"] != null)
{
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
ViewBag.FinYear = LoadDropDown.LoadAllFinYears(_FYDDService);
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.projCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Search(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.LedgerTypeCode = new SelectList(_SumRptTypeService.All().ToList(), "ReportTypeCode", "ReportTypeName");
ViewBag.BranchCode = PermittedBranch();//new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.BookType = LoadDropDown.LoadBookType();
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Search(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.LedgerTypeCode = new SelectList(_LedgerTypeService.All().ToList(), "LedgerTypeCode", "LedgerTypeName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); //GardenSelection();
ViewBag.AccountCode = LoadDropDown.LoadAccount("", _ItemService, _SubsidiaryService, _NewChartService);
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
//var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult RateChart(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.CustGroup = LoadDropDown.LoadSubGrpDDL();
ViewBag.CustCode = LoadDropDown.LoadSubsidiary(_ISubsidiaryInfoService);
ViewBag.ItemCode = LoadDropDown.LoadItem(_IItemInfoAppService);
ViewBag.CustType = new SelectList(ISubsidiaryTypeService.All().ToList(), "TypeCode", "SubType");
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult ItemWiseSalesStatementRpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.LocCode = new SelectList(_locationService.All().ToList(), "LocCode", "LocName");
ViewBag.ItemCode = LoadDropDown.LoadItems(_ItemService);
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: JobWiseRecPay
public ActionResult JobWiseRecPay(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.ProjCode = new SelectList(_ProjInfoService.All().ToList(), "ProjCode", "ProjName");
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName");
//ViewBag.FYDD = new SelectList(_FYDDService.All().ToList(), "FinYear", "FinYear");
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
var Fydd = _FYDDService.All().FirstOrDefault(s => s.FinYear == Session["FinYear"].ToString());
ViewBag.FyddFDate = Fydd.FYDF;
ViewBag.FyddTDate = Fydd.FYDT;
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult GetOpenBalForEdit(int OpenBalId)
{
try
{
OpenBal GLOB = new OpenBal();
var defAc = LoadDropDown.GetDefAc();
var Obal = _pR_OpenBalanceService.All().ToList().FirstOrDefault(x => x.Id == OpenBalId);
string isAsset = Obal.Accode.Substring(0, 1);
if (Obal != null)
{
GLOB.Id = Obal.Id;
GLOB.ProjCode = Obal.ProjCode;
GLOB.BranchCode = Obal.BranchCode;
GLOB.Accode = Obal.Accode;
if (isAsset == defAc.AssAc)
{
GLOB.OpenBalance = Obal.OpenBalance;
}
else if (isAsset == defAc.LiaAc)
{
GLOB.OpenBalance = Obal.OpenBalance * (-1);
}
}
var serializerSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string json = JsonConvert.SerializeObject(GLOB, Formatting.Indented, serializerSettings);
if (GLOB != null && GLOB.Id > 0)
{
return(Json(json, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new EmptyResult(), JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetMoneyReceiptPdf(string ReceiptNo)
{
MoneyReceiptVM MRVM = new MoneyReceiptVM();
var crPfd = _chequeReceiptService.All().FirstOrDefault(x => x.ChqReceiptNo == ReceiptNo);
if (crPfd != null)
{
var todayDate = DateTime.Now;
var TingCount = _chequeReceiptService.All().FirstOrDefault(x => x.ChqReceiptNo == ReceiptNo);
TingCount.MRTing = TingCount.MRTing + 1;
TingCount.MRTingTime = todayDate.AddHours(todayDate.Hour).AddMinutes(todayDate.Minute).AddSeconds(todayDate.Second).AddMilliseconds(todayDate.Millisecond);
MRVM.MRNo = crPfd.ChqReceiptNo;
MRVM.CustCode = crPfd.SubCode.Trim();
MRVM.ChequeDate = (DateTime)crPfd.ChqDate;
MRVM.CustName = (from s in _subsidiaryService.All().ToList() where s.SubCode == crPfd.SubCode.Trim() select s.SubName).FirstOrDefault();
MRVM.Address = (from se in _SubsidiaryExtService.All().ToList() where se.SubCode.Trim() == crPfd.SubCode.Trim() select se.SubAddress).FirstOrDefault();
MRVM.InWord = InWord.ConvertToWords(crPfd.Amount.ToString());
MRVM.AcType = LoadDropDown.GetMrAgainst(crPfd.MRAgainst);
MRVM.MRDate = crPfd.ChqReceiptDate;
MRVM.Amount = crPfd.Amount;
MRVM.PayMode = "ChequeReceipt";
MRVM.ChequeNo = crPfd.ChqNo;
MRVM.BankName = _bankInfoService.All().FirstOrDefault(s => s.BankCode == crPfd.BankCode).BankName;;
MRVM.Branch = crPfd.BranchName;
_chequeReceiptService.Update(TingCount);
_chequeReceiptService.Save();
return(new Rotativa.ViewAsPdf("~/Views/CashReceipt/MoneyReceiptPdf.cshtml", MRVM)
{
PageSize = Rotativa.Options.Size.A4
});
}
else
{
string errMsg = "NF";
return(RedirectToAction("ChequeReceipts", "ChequeReceipts", new { errMsg }));
}
}
// GET: CustAdjustment
public ActionResult CustAdjustment()
{
if (Session["UserID"] != null)
{
DateTime datetime = DateTime.Now;
ViewBag.GLProvition = Counter("JB");
ViewBag.GLEntries = CountEntries("JB", datetime);
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintJob = sysSet.MaintJob;
ViewBag.CustCode = new SelectList(_subsidiaryInfoService.All().ToList().Where(x => x.SubType == "1").OrderBy(x => x.SubName), "SubCode", "SubName");
ViewBag.InvNo = LoadDropDown.LoadEmpDlList();
ViewBag.AdjReason = LoadDropDown.LoadAdjReason();
ViewBag.ApprBy = new SelectList(_EmployeeService.All().ToList(), "Id", "UserName");
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
var VchrConv = _vchrSetService.All().ToList().FirstOrDefault().VchrConv;
Session["VchrConv"] = VchrConv;
ViewBag.AdjNo = LoadDropDown.GenerateAdjustmentNo(_custAdjustmentService, "", Session["BranchCode"].ToString(), "", Session["VchrConv"].ToString());
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult UpdateDepositToBank(Deposit deposit, DateTime dateTime)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankDeposit_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>();
if (ModelState.IsValid)
{
deposit.BranchCode = Session["BranchCode"].ToString();
var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
deposit.FinYear = Session["FinYear"].ToString();
deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim());
CashOperation cashOperation = new CashOperation();
var isClosed = _CashOperationService.All().LastOrDefault(x => x.BranchCode == deposit.BranchCode && Convert.ToDateTime(x.TrDate.ToShortDateString()) <= Convert.ToDateTime(dateTime.ToShortDateString()));
if (isClosed.IsClosed == false)
{
using (var transaction = new TransactionScope())
{
try
{
_DepositToBankService.Update(deposit);
_DepositToBankService.Save();
//delete to provision
var entryNo = deposit.DepositNo;
//var entryNo = Convert.ToInt64(deposit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
LoadDropDown.journalVoucherRemoval("BD", entryNo, deposit.VoucherNo, deposit.FinYear);
//insert to provision
LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Update", deposit.DepositNo, Session["UserName"].ToString());
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate);
}
CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
}
return(Json("0", JsonRequestBehavior.AllowGet));
}
public ActionResult GetVchrNoByVchrType(string VchrType)
{
return(Json(LoadDropDown.LoadVchrNoByVchrType(VchrType, _vchrMainService), JsonRequestBehavior.AllowGet));
}
public ActionResult SavePayment(Payment payment)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankPayment_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
try
{
var IfExit = _paymentService.All().Where(x => x.PayCode == payment.PayCode).FirstOrDefault();
if (IfExit == null)
{
payment.BranchCode = Session["BranchCode"].ToString();
payment.FinYear = Session["FinYear"].ToString();
payment.bankAccode = Session["BankAccode"].ToString();
var openBal = GetOpenBal(payment.PayDate);
var rcecBal = GetAllRemittances(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount);
var payTotal = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount);
var closBal = openBal + rcecBal - payTotal;
BankOperation bankOperation = new BankOperation(payment.PayDate, openBal, 0.0, payment.Amount, closBal, payment.BranchCode, payment.FinYear, false, payment.bankAccode);
// BankOperation bankOperation = new BankOperation(payment.PayDate, 0.0, 0.0, 0.0, 0.0, payment.BranchCode, payment.FinYear, false, payment.bankAccode);
var isAlreadySaved = _bankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == payment.PayDate.ToString("MM-dd-yyyy") && x.BranchCode == payment.BranchCode && x.bankAccode == payment.bankAccode);
if (isAlreadySaved == null)
{
using (var transaction = new TransactionScope())
{
try
{
_bankOperationService.Add(bankOperation);
_bankOperationService.Save();
_paymentService.Add(payment);
_paymentService.Save();
//Insert to provision
LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Save", payment.PayCode, User.Identity.Name);
CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
else
{
var payTotals = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount);
isAlreadySaved.PayTotal = payTotals + payment.Amount;
isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal;
using (var transaction = new TransactionScope())
{
try
{
_bankOperationService.Update(isAlreadySaved);
_bankOperationService.Save();
_paymentService.Add(payment);
_paymentService.Save();
//Insert to provision
LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString());
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.BankRecalculate(payment.PayDate, Convert.ToDecimal(payment.Amount), Session["ProjCode"].ToString(), payment.BranchCode, payment.FinYear, payment.bankAccode);
}
TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Save", payment.PayCode, User.Identity.Name);
CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdatePayment(Payment payment)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankPayment_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
payment.BranchCode = Session["BranchCode"].ToString();
payment.FinYear = Session["FinYear"].ToString();
payment.bankAccode = Session["BankAccode"].ToString();
string branchCode = Session["BranchCode"].ToString();
string finYear = Session["FinYear"].ToString();
string bankAccode = Session["BankAccode"].ToString();
var bankOperation = _bankOperationService.All().ToList().LastOrDefault(x => x.BranchCode == branchCode && x.bankAccode == bankAccode && x.TrDate == payment.PayDate);
var Payment = _paymentService.All().ToList().Where(x => x.PayCode == payment.PayCode.Trim()).FirstOrDefault();
if (bankOperation != null && Payment != null)
{
bankOperation.PayTotal = bankOperation.PayTotal + Payment.Amount - payment.Amount;
bankOperation.CloseBal = bankOperation.OpenBal + bankOperation.RecTotal - bankOperation.PayTotal;
_bankOperationService.Update(bankOperation);
_bankOperationService.Save();
Payment = payment;
_paymentService.All().ToList().Where(y => y.PayCode == payment.PayCode).ToList().ForEach(x => _paymentService.Delete(x));
_paymentService.Save();
_paymentService.Add(Payment);
_paymentService.Save();
// Delete Provision
var entryNo = payment.PayCode;
LoadDropDown.journalVoucherRemoval("BP", entryNo, payment.VoucherNo, payment.FinYear);
//Insert to provision
LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Update", payment.PayCode, User.Identity.Name);
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.BankRecalculate(payment.PayDate, Convert.ToDecimal(payment.Amount), Session["ProjCode"].ToString(), payment.BranchCode, payment.FinYear, payment.bankAccode);
}
CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode);
transaction.Complete();
return(Json(new { CashOPVM, data = 1 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
transaction.Dispose();
return(Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult UpdateCashMR(MoneyReceiptVM MrVM)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MoneyReceiptCash_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
var VchrExist = _pVchrmainService.All().FirstOrDefault(s => s.VchrNo == MrVM.VchrNo);
if (VchrExist == null)
{
return(Json("3", JsonRequestBehavior.AllowGet));
}
var MR = _moneyReceiptService.All().Where(x => x.MRSL == MrVM.MRSL && x.MRNo == MrVM.MRNo && MrVM.Posted == false).FirstOrDefault();
var CR = _CashReceiptService.All().Where(s => s.RefNo == MrVM.MRSL).FirstOrDefault();
var CRSD = _CashReceiptSubDetailsAppService.All().Where(s => s.CashReceiptNo == CR.ReceiptNo).FirstOrDefault();
if (MR != null && CR != null && CRSD != null)
{
//var cabkop = _defACService.All().ToList().FirstOrDefault().CashAc;
var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
//For MR
MR.MRSL = MrVM.MRSL;
MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode;
MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode;
MR.MRNo = MrVM.MRNo;
MR.MRDate = MrVM.MRDate;
MR.MRAgainst = MrVM.MRAgainst;
MR.VchrNo = MrVM.VchrNo;
MR.Posted = MrVM.Posted;
MR.AdjWithBill = MrVM.AdjWithBill;
MR.MRAmount = MrVM.Amount;
MR.Accode = MrVM.Accode;
MR.CustCode = MrVM.CustCode;
MR.FinYear = Session["FinYear"].ToString();
MR.JobNo = MrVM.JobNo;
MR.Remarks = MrVM.Remarks;
MR.Ca_Bk = GCa;
CR.ReceiptDate = (DateTime)MrVM.MRDate;
CR.purAccode = MrVM.MRAgainst;// "1.2.004";
CR.RefNo = MrVM.MRSL;
CR.Amount = (Double)MrVM.Amount;
CR.Remarks = MrVM.Remarks;
CR.VoucherNo = MrVM.VchrNo;
CRSD.SubCode = MrVM.CustCode;
CRSD.Accode = MrVM.MRAgainst;
CRSD.Amount = (Double)MrVM.Amount;
_moneyReceiptService.Update(MR);
_CashReceiptService.Update(CR);
_CashReceiptSubDetailsAppService.Update(CRSD);
_CashReceiptService.Save();
_CashReceiptSubDetailsAppService.Save();
_moneyReceiptService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Cash MR", "Update", MR.MRSL, Session["UserName"].ToString());
LoadDropDown.journalVoucherRemoval("CR", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString());
LoadDropDown.journalVoucherSave("CR", "I", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), GCa, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
transaction.Dispose();
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
// GET: Language
public ActionResult Language()
{
ViewBag.LangName = LoadDropDown.LoadLanguage();
return(View());
}
public ActionResult SaveCashMR(MoneyReceiptVM MrVM, List <MoneyReceiptExt> AdjBills)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MoneyReceiptCash_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
//----Edit Nasir---//
//var cabkop = "";
//var sysSet = _sysSetService.All().FirstOrDefault();
//if (sysSet.ActualBasis == true)
//{
//var cabkop = _defACService.All().ToList().FirstOrDefault().CashAc;
//}
//else
//{
// cabkop = _defACService.All().ToList().FirstOrDefault().CashAc;
//}
//--- ---//
string CRNo = "";
var IfExit = _moneyReceiptService.All().Where(x => x.MRNo == MrVM.MRNo).FirstOrDefault();
if (IfExit == null)
{
//var todayDate = DateTime.Now;
CashReceipt CR = new CashReceipt();
CashReceiptSubDetails CRSD = new CashReceiptSubDetails();
MoneyReceipt MR = new MoneyReceipt();
MR.MRSL = MrVM.MRSL;
MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode;
MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode;
MR.MRNo = MrVM.MRNo;
MR.MRDate = MrVM.MRDate; //.AddHours(todayDate.Hour).AddMinutes(todayDate.Minute).AddSeconds(todayDate.Second).AddMilliseconds(todayDate.Millisecond);
MR.MRAgainst = MrVM.MRAgainst;
MR.VchrNo = MrVM.VchrNo;
MR.PayMode = "Ca";
MR.Posted = MrVM.Posted;
MR.AdjWithBill = MrVM.AdjWithBill;
MR.MRAmount = MrVM.Amount;
// Accode ????
MR.Accode = MrVM.MRAgainst; // "1.2.001";
MR.CustCode = MrVM.CustCode;
MR.FinYear = Session["FinYear"].ToString();
MR.Remarks = MrVM.Remarks;
MR.JobNo = MrVM.JobNo;
//MR.Ca_Bk = cabkop;
// CR.ReceiptNo = _CashReceiptController.GenerateReceiptNo(MR.BranchCode).Substring(6, 0);//MrVM.MRNo;
CR.ReceiptNo = _CashReceiptController.GenerateReceiptNo(MR.BranchCode);
// CR.ReceiptNo = MrVM.MRNo;
CRNo = CR.ReceiptNo;
CR.ReceiptDate = (DateTime)MrVM.MRDate;
CR.purAccode = MrVM.MRAgainst;// "1.2.004";
CR.RefNo = MrVM.MRSL;
CR.Amount = (Double)MrVM.Amount;
CR.Advance = false;
CR.Remarks = MrVM.Remarks;
CR.GLPost = false;
CR.BranchCode = MrVM.BranchCode;
CR.VoucherNo = MrVM.VchrNo;
CR.BranchCode = MR.BranchCode;
CR.FinYear = Session["FinYear"].ToString();
CRSD.SubCode = MrVM.CustCode;
CRSD.Accode = MrVM.MRAgainst;
CRSD.Amount = (Double)MrVM.Amount;
CRSD.CashReceiptNo = CRNo;
//CR.purAccode = cabkop; // "1.2.004";
_moneyReceiptService.Add(MR);
_CashReceiptService.Add(CR);
_CashReceiptSubDetailsAppService.Add(CRSD);
_CashReceiptService.Save();
_moneyReceiptService.Save();
_CashReceiptSubDetailsAppService.Save();
//List<MoneyReceiptExt> MRExtList = new List<MoneyReceiptExt>();
if (AdjBills != null)
{
decimal TotAmt = MrVM.Amount;
foreach (var bill in AdjBills)
{
MoneyReceiptExt MRExt = new MoneyReceiptExt();
var saleMain = _salesMainService.All().Where(s => s.SaleNo == bill.SaleNo).FirstOrDefault();
MRExt.MRId = _moneyReceiptService.All().OrderBy(s => s.MRId).LastOrDefault().MRId;
MRExt.SaleNo = bill.SaleNo;
MRExt.InstallNo = _moneyReceiptExtService.All().OrderBy(s => s.InstallNo).Where(x => x.SaleNo == bill.SaleNo).Select(s => s.InstallNo).LastOrDefault();
MRExt.InstallNo = MRExt.InstallNo + 1;
MRExt.InstallDate = DateTime.Now;
if (TotAmt >= bill.Amount)
{
MRExt.Amount = bill.Amount;
TotAmt = TotAmt - bill.Amount;
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = bill.Amount;
saleMain.IsPaid = true;
_salesMainService.Update(saleMain);
_salesMainService.Save();
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
}
else
{
if (bill.IsPaid_mre)
{
saleMain.IsPaid = true;
MRExt.Amount = TotAmt;
//TotAmt = TotAmt - bill.Amount;
}
else
{
saleMain.IsPaid = false;
MRExt.Amount = TotAmt;
// MRExt.Amount = bill.Amount;
//TotAmt = TotAmt - bill.Amount;
}
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = TotAmt;
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
string sql = string.Format("select sm.ReceiptAmt,sm.SaleNo, sm.SaleDate, (sm.NetAmount - isnull(sum(mre.Amount),0)) as Billamount from SalesMain sm left join MoneyReceiptExt mre on mre.SaleNo = sm.SaleNo where sm.CustCode = " + MrVM.CustCode + " and sm.IsPaid = 'false' group by sm.ReceiptAmt, mre.SaleNo, sm.NetAmount, sm.SaleNo, sm.SaleDate, mre.Amount order by sm.SaleNo");
IEnumerable <billShow> BillLst;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList();
}
foreach (var Salebill in BillLst)
{
if (Salebill.BillAmount == 0)
{
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = ((Salebill.ReceiptAmt == null) ? 0 : Salebill.ReceiptAmt) + TotAmt;
saleMain.IsPaid = true;
_salesMainService.Update(saleMain);
_salesMainService.Save();
}
}
}
} //end of foreach
}
// New Add By Nasir
var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
//------------------
TransactionLogService.SaveTransactionLog(_transactionLogService, "Cash MR", "Save", MR.MRSL, Session["UserName"].ToString());
LoadDropDown.journalVoucherSave("CR", "I", CRNo, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), GCa, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
transaction.Dispose();
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult GetAdjBills(string CustCode, string MRAgainst, decimal Amount, string isEdit)
{
var Bills = default(dynamic);
string sql = "";
string MrAg = LoadDropDown.GetMrAgainstType(MRAgainst);
if (MrAg == null)
{
MrAg = MRAgainst; //temporary Ashik
}
if (MrAg == "Sales")
{
if (isEdit == "1")
{
Bills = (from mr in _moneyReceiptService.All().ToList()
join mre in _moneyReceiptExtService.All().ToList() on mr.MRId equals mre.MRId
where mr.CustCode == CustCode
select new
{
SaleNo = mre.SaleNo,
SaleDate = mr.MRDate,
BillAmount = mre.Amount,
IsPaid = true
}).ToList();
}
else if (isEdit == "ChqEdit")
{
sql = string.Format("select sm.IsPaid, sm.NetAmount as Billamount, sm.SaleNo, sm.SaleDate , (sm.NetAmount - isnull(sum(cre.BillAmount),0)) as Billamt from SalesMain sm left join ChequeReceiptExt cre on cre.BillNo = sm.SaleNo where sm.CustCode = " + CustCode + " group by sm.IsPaid, cre.BillNo, sm.NetAmount, sm.SaleNo, sm.SaleDate order by sm.SaleNo ");
//sql = string.Format("select sm.IsPaid, sm.NetAmount as Billamount, sm.SaleNo, sm.SaleDate , (sm.NetAmount - isnull(sum(cre.BillAmount),0)) as Billamt from SalesMain sm left join ChequeReceiptExt cre on cre.BillNo = sm.SaleNo where sm.CustCode = " + CustCode + " and sm.Ispaid = 'true' and Billamt = 0 group by sm.IsPaid, cre.BillNo, sm.NetAmount, sm.SaleNo, sm.SaleDate, cre.BillAmount order by sm.SaleNo ");
IEnumerable <billShow> BillLst;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList();
Bills = BillLst;
}
}
else
{
//decimal MrExtAmt = 0;
//Bills = (from sm in _salesMainService.All().ToList()
// join mre in _moneyReceiptExtService.All().ToList() on sm.SaleNo equals mre.SaleNo into SmMre
// from leftJ in SmMre.DefaultIfEmpty()
// where sm.CustCode == CustCode && sm.IsPaid == false
// //group leftJ by leftJ.SaleNo into G
// select new
// {
// SaleNo = sm.SaleNo,
// SaleDate = sm.SaleDate,
// BillAmount = sm.NetAmount - (MrExtAmt = (leftJ == null) ? 0 : leftJ.Amount)
// }).GroupBy(x => x.SaleNo).ToList();
sql = string.Format("select sm.SaleNo, sm.SaleDate, (sm.NetAmount - (select isnull(sum(mre.Amount),0) as Billamount from MoneyReceiptExt mre where SaleNo = sm.SaleNo)) as Billamount from SalesMain sm where sm.CustCode = " + CustCode + " and sm.IsPaid = 'false' group by sm.NetAmount, sm.SaleNo, sm.SaleDate order by sm.SaleNo ");
IEnumerable <billShow> BillLst;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList();
Bills = BillLst;
}
}
}
//else if (true)
//{
//}
return(Json(new { data = Bills }, 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 GetInvMrNoByVchrType(string VchrType, string CustCode)
{
return(Json(LoadDropDown.GetInvMrNoByVchrType(VchrType, CustCode, _SalesMainService, _moneyReceiptService, _FYDDAppService), JsonRequestBehavior.AllowGet));
}
public ActionResult SaveDepositToBank(Deposit deposit)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankDeposit_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>();
try
{
var IfExit = _DepositToBankService.All().Where(x => x.DepositNo == deposit.DepositNo).FirstOrDefault();
if (IfExit == null)
{
if (!string.IsNullOrEmpty(deposit.bankAccode) && deposit.bankAccode.Trim() != "Select Bank A/C")
{
deposit.BranchCode = Session["BranchCode"].ToString();
var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
deposit.FinYear = Session["FinYear"].ToString();
deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim());
//cashReceipt.Customer = _CustomerService.All().ToList().FirstOrDefault(x => x.CustCode == cashReceipt.CustCode);
CashOperation cashOperation = new CashOperation(deposit.DepositDate, 0.0, 0.0, 0.0, 0.0, "", DateTime.Now, false, deposit.FinYear, false, deposit.BranchCode);
var isAlreadyClosed = _CashOperationService.All().ToList().FirstOrDefault(x => x.BranchCode == deposit.BranchCode && x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy"));
var openBal = GetOpenBal(deposit.DepositDate, deposit.bankAccode);
var rcecBal = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount);
var payTotal = GetAllPayment(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount);
var closBal = openBal + rcecBal - payTotal;
BankOperation bankOperation = new BankOperation(deposit.DepositDate, openBal, deposit.Amount, 0.0, closBal, deposit.BranchCode, deposit.FinYear, false, deposit.bankAccode);
var sysSet = _sysSetService.All().FirstOrDefault();
var isAlreadySaved = _BankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy") && x.BranchCode == deposit.BranchCode && x.bankAccode == deposit.bankAccode);
if (isAlreadyClosed == null || isAlreadySaved == null)
{
using (var transaction = new TransactionScope())
{
try
{
_CashOperationService.Add(cashOperation);
_CashOperationService.Save();
_BankOperationService.Add(bankOperation);
_BankOperationService.Save();
_DepositToBankService.Add(deposit);
_DepositToBankService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString());
LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString());
CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else if (isAlreadyClosed != null && sysSet.CashRule == "O" ? true : isAlreadyClosed.IsClosed == false)
{
var rcecBals = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount);
isAlreadySaved.RecTotal = rcecBals + deposit.Amount;
isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal;
using (var transaction = new TransactionScope())
{
try
{
_BankOperationService.Update(isAlreadySaved);
_BankReceiptAppService.Save();
_DepositToBankService.Add(deposit);
_DepositToBankService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString());
LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString());
if (sysSet.CashRule == "O")
{
LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate);
}
CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetRecvNo(string branchCode, string ProjCode)
{
return(Json(LoadDropDown.GenerateRecvSlNo(_moneyReceiptService, branchCode, Session["BranchCode"].ToString(), ProjCode, Session["VchrConv"].ToString()), JsonRequestBehavior.AllowGet));
}
public ActionResult GenerateAdjustmentNo()
{
return(Json(LoadDropDown.GenerateAdjustmentNo(_custAdjustmentService, "", Session["BranchCode"].ToString(), "", Session["VchrConv"].ToString()), JsonRequestBehavior.AllowGet));
}
public ActionResult SaveOpenBalance(OpenBal OpnBal)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("GL_OpenBal_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
string eCode = "";
var defAc = LoadDropDown.GetDefAc();
// Checking and operation Data for save database
string isAsset = OpnBal.Accode.Substring(0, 1);
if (isAsset == defAc.AssAc)
{
OpnBal.OpenBalance = OpnBal.OpenBalance;
}
else if (isAsset == defAc.LiaAc)
{
OpnBal.OpenBalance = OpnBal.OpenBalance * (-1);
}
using (var transaction = new TransactionScope())
{
try
{
// query for check existing data and then if null go to transaction
var objOpnBal = _pR_OpenBalanceService.All().ToList()
.Where(x => x.Accode == OpnBal.Accode && x.BranchCode == OpnBal.BranchCode && x.ProjCode == OpnBal.ProjCode).ToList();
if (objOpnBal.Count == 0)
{
//// should not here , in setOpnBal
OpnBal.FinYear = Session["FinYear"].ToString();
_pR_OpenBalanceService.Add(OpnBal);
_pR_OpenBalanceService.Save();
var OpenBalanceID = 1; // not defined
TransactionLogService.SaveTransactionLog(_transactionLogService, "SaveOpnBal", "Save",
OpenBalanceID.ToString(), Session["UserName"].ToString());
eCode = "1";
}
else
{
eCode = "2";
}
transaction.Complete();
return(Json(eCode, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
