// GET: PurchaseReturn
public ActionResult PurchaseReturn(string errMsg)
{
if (Session["UserID"] != null)
{
DateTime datetime = DateTime.Now;
ViewBag.GLProvition = Counter("PR");
ViewBag.GLEntries = CountEntries("PR", datetime);
ViewBag.LocCode = new SelectList(_locationService.All().Where(s => s.LocCode != "900").ToList(), "LocCode", "LocName");
ViewBag.CustCode = new SelectList(_subsidiaryInfoService.All().ToList().Where(x => x.SubType == "2").OrderBy(x => x.SubName), "SubCode", "SubName");
ViewBag.ItemCode = LoadDropDown.LoadEmpDlList();
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintJob = sysSet.MaintJob;
Session["MaintLot"] = sysSet.MaintLot;
ViewBag.MaintVAT = sysSet.MaintVAT;
Session["MaintVAT"] = sysSet.MaintVAT;
ViewBag.Reason = 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.PurRetNo = LoadDropDown.GeneratePurRetNo(_PurRetMainService, "", Session["BranchCode"].ToString(), "", Session["VchrConv"].ToString());
ViewBag.errMsg = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: StockLedgerRpt
public ActionResult StockLedgerRpt(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.BranchCode = new SelectList(_BranchService.All().ToList(), "BranchCode", "BranchName"); //GardenSelection();
ViewBag.AccountCode = new SelectList(_ItemService.All().ToList(), "ItemCode", "ItemName");
ViewBag.ItemType = new SelectList(_itemTypeService.All().ToList(), "ItemTypeCode", "ItemTypeName");
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.Group = LoadDropDown.LoadGroupInfoByItemType("", _CommonVmService);
ViewBag.SubGroup = LoadDropDown.LoadSGroupByGroupId("", "", _CommonVmService);
ViewBag.SubSubGroup = LoadDropDown.LoadSSGroupInfo("", "", "", _CommonVmService);
#region For item Filtering option
ViewBag.NoGrp = sysSet.NoGrp;
ViewBag.OnlyGrp = sysSet.OnlyGrp;
ViewBag.GrpAndSubGrp = sysSet.GrpAndSubGrp;
ViewBag.SubSubGrp = sysSet.SubSubGrp;
#endregion
ViewBag.Message = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult GetCashBook(RptSearchVModel vmodel)
{
var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString());
if (ChkFYR != "")
{
return(RedirectToAction("Search", "CashBook", new { errMsg = ChkFYR }));
}
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("RptCashBook_Preview"))
{
string errMsg = "No Preview Permission for this User !!";
return(RedirectToAction("Search", "CashBook", new { errMsg }));
}
Session["fDate"] = vmodel.fDate;
Session["tDate"] = vmodel.toDate;
string finyear = Session["FinYear"].ToString();
vmodel.BranchCode = (vmodel.BranchCode == "0") ? "" : vmodel.BranchCode;
Session["Branch"] = vmodel.BranchCode;
ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch;
if (vmodel.BranchCode != "" && vmodel.BranchCode != "0")
{
ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString();
}
else
{
ViewBag.Branch = "All";
}
string sql = string.Format("EXEC rptCashBook '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.fDate.ToString("yyyy/MM/dd") + "','" + vmodel.toDate.ToString("yyyy/MM/dd") + "'");
List <CashBook> cashBook = _CashBookService.SqlQueary(sql).ToList();
//For us Culture Ex: 0.00
const string culture = "en-US";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentCulture = ci;
Thread.CurrentThread.CurrentUICulture = ci;
if (cashBook.Count == 0)
{
string errMsg = "There is no data on this date. Please try another !!!";
return(RedirectToAction("Search", "CashBook", new { errMsg }));
}
else
{
ViewBag.Datef = InWord.GetAbbrMonthNameDate(vmodel.fDate);
ViewBag.Datet = InWord.GetAbbrMonthNameDate(vmodel.toDate);
return(View(cashBook));
}
}
public ActionResult GetDynaSysSet()
{
VMDynSysSet DsSet = new VMDynSysSet();
DsSet.SysSet = _sysSetService.All().ToList().FirstOrDefault();
DsSet.DynaCap = _dynaCapService.All().ToList().FirstOrDefault();
if (DsSet.SysSet != null && DsSet.DynaCap != null)
{
return(Json(DsSet, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ChequeReceipts(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.BranchCode = new SelectList(_branchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.Accode = LoadDropDown.LoadMRAgainstDDL();
ViewBag.SubCode = new SelectList(_subsidiaryService.All().Where(x => x.SubType == "1").ToList(), "SubCode", "SubName");//LoadDropDown.LoadSubsidiaryByPurpuse("", _subsidiaryService, _subsidiaryCtrlService);
ViewBag.BankCode = new SelectList(_bankInfoService.All().ToList(), "BankCode", "BankName");
ViewBag.DepositBank = LoadDropDown.LoadDepositBankDDL();
ViewBag.UpdateBy = new SelectList(_employeeInfoService.All().ToList(), "Id", "UserName");
DateTime datetime = DateTime.Now;
ViewBag.GLProvition = Counter("BR");
ViewBag.GLEntries = CountEntries("BR", datetime);
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintJob = sysSet.MaintJob;
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
var VchrConv = _vchrSetService.All().ToList().FirstOrDefault().VchrConv;
Session["VchrConv"] = VchrConv;
ViewBag.errMsg = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: OnlineMoneyReceipt
public ActionResult OnlineMoneyReceipt()
{
if (Session["UserID"] != null)
{
ViewBag.BranchCode = new SelectList(_branchService.All().ToList(), "BranchCode", "BranchName");
ViewBag.MRAgainst = LoadDropDown.LoadMRAgainstDDL();
ViewBag.CustCode = new SelectList(_subsidiaryInfoService.All().Where(x => x.SubType == "1").ToList(), "SubCode", "SubName");
ViewBag.bankCode = new SelectList(_bankInfoService.All().ToList(), "BankCode", "BankName");
ViewBag.DepositBank = LoadDropDown.LoadDepositBankDDL();
ViewBag.CollectedBy = new SelectList(_employeeInfoService.All().ToList(), "Id", "UserName");
var CashAc = _defACService.All().ToList().FirstOrDefault().CashAc;
ViewBag.Accode = LoadDropDown.LoadGLAc(CashAc, _newChartService);
DateTime datetime = DateTime.Now;
ViewBag.GLProvition = Counter("BR");
ViewBag.GLEntries = CountEntries("BR", datetime);
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintJob = sysSet.MaintJob;
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
ViewBag.GetwayId = LoadDropDown.LoadGetwayProvider();
var VchrConv = _vchrSetService.All().ToList().FirstOrDefault().VchrConv;
Session["VchrConv"] = VchrConv;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// GET: CashMoneyReceipt
public ActionResult CashMoneyReceipt(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.MRAgainst = LoadDropDown.LoadMRAgainstDDL();
ViewBag.CustCode = new SelectList(_subsidiaryInfoService.All().ToList().Where(x => x.SubType == "1"), "SubCode", "SubName");
var VchrConv = _vchrSetService.All().ToList().FirstOrDefault().VchrConv;
Session["VchrConv"] = VchrConv;
ViewBag.MRSL = LoadDropDown.GenerateRecvSlNo(_moneyReceiptService, "", Session["BranchCode"].ToString(), "", Session["VchrConv"].ToString());
DateTime datetime = DateTime.Now;
ViewBag.GLProvition = Counter("CR");
ViewBag.GLEntries = CountEntries("CR", datetime);
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintJob = sysSet.MaintJob;
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
ViewBag.errMsg = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
public ActionResult Item(string errMsg)
{
if (Session["UserID"] != null)
{
ViewBag.ItemCode = GenerateItemCode();
var item = _ItemInfoService.All().ToList().LastOrDefault();
ViewBag.ItemType = new SelectList(_ItemTypeService.All().ToList(), "ItemTypeCode", "ItemTypeName");
ViewBag.UnitCode = new SelectList(_UnitService.All().ToList(), "UnitCode", "UnitName");
ViewBag.DetUnitCode = new SelectList(_UnitService.All().ToList(), "UnitCode", "UnitName");
ViewBag.PackItemCode = new SelectList(_ItemInfoService.All().ToList(), "ItemCode", "ItemName");
ViewBag.AltItemCode = new SelectList(_ItemInfoService.All().ToList(), "ItemCode", "ItemName");
ViewBag.Items = GetItemAll();
ViewBag.Group = LoadDropDown.LoadGroupInf(_CommonVmService);
ViewBag.SubGroup = LoadDropDown.LoadSGroupInfo(_CommonVmService);
ViewBag.SubSubGroup = LoadDropDown.LoadAllSSGroupInfo(_CommonVmService);
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MaintVAT = sysSet.MaintVAT;
Session["MaintVAT"] = sysSet.MaintVAT;
#region For item Filtering option
ViewBag.NoGrp = sysSet.NoGrp;
ViewBag.OnlyGrp = sysSet.OnlyGrp;
ViewBag.GrpAndSubGrp = sysSet.GrpAndSubGrp;
ViewBag.SubSubGrp = sysSet.SubSubGrp;
#endregion
ViewBag.errMsg = errMsg;
return(View());
}
else
{
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
// 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"));
}
}
// 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 ListOfTransectionPreview(RptSearchVModel vmodel, string pType)
//{
// string finyear = Session["FinYear"].ToString();
// Session["Branch"] = vmodel.BranchCode;
// Session["LedgerType"] = vmodel.LedgerTypeCode;
// Session["fDate"] = vmodel.fDate;
// Session["tDate"] = vmodel.tDate;
// var BranchCode = Session["BranchCode"].ToString();
// if (BranchCode != null)
// {
// ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == BranchCode).BranchName.ToString();
// }
// else
// {
// ViewBag.Branch = "All";
// }
// string sql = string.Format("EXEC rptListTran '" + finyear + "','01','" + vmodel.BranchCode + "','" + vmodel.JTrGrpId + "','" + Convert.ToDateTime(vmodel.fDate) + "','" + Convert.ToDateTime(vmodel.tDate) + "'");
// List<JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList();
// if (glReport.Count == 0)
// {
// string errMsg = "Data not found !!!";
// //ViewBag.msg = errMsg;
// return RedirectToAction("CashOperation", "CashOperation", new { errMsg });
// }
// else
// {
// if (pType == "A4") { return new Rotativa.ViewAsPdf("~/Views/CashOperation/ListOfTransectionPreview.cshtml", glReport) { PageSize = Rotativa.Options.Size.A4 }; }
// else if (pType == "A3") { return new Rotativa.ViewAsPdf("~/Views/CashOperation/ListOfTransectionPreview.cshtml", glReport) { PageSize = Rotativa.Options.Size.A3 }; }
// else { return new Rotativa.ViewAsPdf("~/Views/CashOperation/ListOfTransectionPreview.cshtml", glReport) { PageSize = Rotativa.Options.Size.A5 }; }
// }
//}
public ActionResult ListOfTransactionPreview(RptSearchVModel vmodel)
{
vmodel.fDate = Convert.ToDateTime(Session["fDate"]);
vmodel.toDate = Convert.ToDateTime(Session["tDate"]);
vmodel.BranchCode = Session["Branch"].ToString();
string finyear = Session["FinYear"].ToString();
if (Session["Data"] == null)
{
vmodel.JTrGrpId = "";
}
else
{
vmodel.JTrGrpId = Session["Data"].ToString();
}
//vmodel.JTrGrpId = Session["Data"].ToString();
//if (vmodel.JTrGrpId == null)
//{
// vmodel.JTrGrpId = "";
//}
// string x = "" = Session["NullData"].ToString();
string sql = string.Format("EXEC rptListTran '" + finyear + "','01','" + vmodel.BranchCode + "','" + vmodel.JTrGrpId + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.toDate.ToString("MM/dd/yyyy") + "'");
List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList();
ViewBag.BranchCode = vmodel.BranchCode;
ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate);
ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate);
ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch;
if (ViewBag.HasBranch == true)
{
if (vmodel.BranchCode != null && vmodel.BranchCode != "0")
{
ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString();
}
else
{
ViewBag.Branch = "All";
}
}
// var glReport = Session["Data"].ToString();
//if (glReport == null)
//{
// string errMsg = "Data not found !!!";
// return RedirectToAction("ListOfTransaction", "Search", new { errMsg });
//}
//else
//{
double amt = 0;
//foreach (var item in glReport)
//{
// double amt = 0;
List <JarnalVoucher> sList = new List <JarnalVoucher>(); //InWord.ConvertToWords(amt.ToString()).ToList();
foreach (var item in glReport)
{
if (item.DrAmount > 0)
{
amt = item.DrAmount;
}
else if (item.CrAmount > 0)
{
amt = item.CrAmount;
}
JarnalVoucher sAmt = new JarnalVoucher();
sAmt.ACCode = item.ACCode;
sAmt.VDate = item.VDate;
sAmt.AcName = item.AcName;
sAmt.InWords = InWord.ConvertToWords(amt.ToString());
sAmt.AcName = item.AcName;
sAmt.Narration = item.Narration;
sAmt.SubSidiary = item.SubSidiary;
sAmt.CrAmount = item.CrAmount;
sAmt.DrAmount = item.DrAmount;
sAmt.VchrNo = item.VchrNo;
sAmt.Posted = item.Posted;
sAmt.Sub_Ac = item.Sub_Ac;
sList.Add(sAmt);
// }
}
//string InWordsamt = InWord.ConvertToWords(amt.ToString());
//ViewBag.InWordsAmt = InWordsamt;
// ViewBag.glDate = date;
// return View("~/Views/ListOfTransection/TransectionList.cshtml", glReport);
return(new Rotativa.ViewAsPdf("ListOfTransactionPreview", sList)
{
CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\""
});
//}
}
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 GetVoucherPreviewPdf(string FinYear, string vchrNo, string pType)
{
var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == "rptVoucher");
ViewBag.RptCap = ledger.RptCap;
ViewBag.Col1Cap = ledger.Col1Cap;
ViewBag.Col2Cap = ledger.Col2Cap;
ViewBag.Col3Cap = ledger.Col3Cap;
ViewBag.Col4Cap = ledger.Col4Cap;
ViewBag.Col5Cap = ledger.Col5Cap;
ViewBag.Col6Cap = ledger.Col6Cap;
ViewBag.Col7Cap = ledger.Col7Cap;
ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch;
if (ViewBag.HasBranch == true)
{
var BranchCode = Session["BranchCode"].ToString();
if (BranchCode != null)
{
ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == BranchCode).BranchName.ToString();
}
else
{
ViewBag.Branch = "All";
}
}
string sql = string.Format("EXEC rptVoucher '" + FinYear + "','" + vchrNo + "'");
List <VchrPreviewVM> rptVchr = _VchrPreviewVMService.SqlQueary(sql).ToList();
//if (rptVchr.Count == 0)
//{
// string errMsg = "There is no data in this combination. Please try again !!!";
// return RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg });
//}
//else
//{
double amt = 0;
foreach (var item in rptVchr)
{
if (item.cramount != 0)
{
amt += item.cramount;
}
}
string InWordsamt = InWord.ConvertToWords(amt.ToString());
ViewBag.InWordsAmt = InWordsamt;
if (pType == "A4")
{
return(new Rotativa.ViewAsPdf("~/Views/VchrPreview/VchrPreviewPdf.cshtml", rptVchr)
{
PageSize = Rotativa.Options.Size.A4
});
}
else if (pType == "A3")
{
return(new Rotativa.ViewAsPdf("~/Views/VchrPreview/VchrPreviewPdf.cshtml", rptVchr)
{
PageSize = Rotativa.Options.Size.A3
});
}
else
{
return(new Rotativa.ViewAsPdf("~/Views/VchrPreview/VchrPreviewPdf.cshtml", rptVchr)
{
PageSize = Rotativa.Options.Size.A5
});
}
//}
}
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 SummaryReportPdf(RptSearchVModel vmodel, string finyear)
{
vmodel.BranchCode = Session["Branch"].ToString();
vmodel.LedgerTypeCode = Session["LedgerType"].ToString();
if (Session["LevelNo"] == null)
{
vmodel.LevelNo = "0";
}
else
{
vmodel.LevelNo = Session["LevelNo"].ToString();
}
// vmodel.LevelNo =Session["LevelNo"].ToString();
var rptCap = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == vmodel.LedgerTypeCode);
ViewBag.LedgerCap = rptCap.LedgerCap;
ViewBag.RptCap = rptCap.RptCap;
ViewBag.Col1Cap = rptCap.Col1Cap;
ViewBag.Col2Cap = rptCap.Col2Cap;
ViewBag.Col3Cap = rptCap.Col3Cap;
ViewBag.Col4Cap = rptCap.Col4Cap;
ViewBag.Col5Cap = rptCap.Col5Cap;
ViewBag.Col6Cap = rptCap.Col6Cap;
ViewBag.Col7Cap = rptCap.Col7Cap;
ViewBag.Col8Cap = rptCap.Col8Cap;
ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate);
ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.tDate);
ViewBag.BranchCode = vmodel.BranchCode;
if (vmodel.BranchCode != "" && vmodel.BranchCode != "0")
{
ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString();
}
else
{
ViewBag.Branch = "All";
}
ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch;
ViewBag.PrintDate = DateTime.Now.ToShortDateString();
finyear = Session["FinYear"].ToString();
if (Session["LevelNo"] == null)
{
vmodel.LevelNo = "0";
}
else
{
vmodel.LevelNo = Session["LevelNo"].ToString();
}
string sql = string.Format(" EXEC " + rptCap.SP_Name + " '" + finyear + "','','" + vmodel.BranchCode + "','" + vmodel.fDate.ToString("MM/dd/yyyy") + "','" + vmodel.tDate.ToString("MM/dd/yyyy") + "','" + Session["Discardcntl"] + "','" + vmodel.LevelNo + "'");
List <SummaryReport> summaryReport = _SumRptService.SqlQueary(sql).ToList();
Session["Discardcntl"] = "";
Session["LevelNo"] = "";
//if (summaryReport.Count == 0)
//{
// string errMsg = "There is no data in this combination. Please try again !!!";
// return RedirectToAction("GetSummaryReport2", "SummaryReport", new { errMsg });
//}
//else
//{
//For us Culture Ex: 0.00
const string culture = "en-US";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentCulture = ci;
Thread.CurrentThread.CurrentUICulture = ci;
if (rptCap.RptCap == "Stock Summary")
{
return(new Rotativa.ViewAsPdf("SummaryStockReportPdf", summaryReport)
{
CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\""
});
}
return(new Rotativa.ViewAsPdf("SummaryReportPdf", summaryReport)
{
CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\""
});
//}
}
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 Login(VMLogin user)
{
try
{
string Pass = SHA1.Encode(user.Password);
var UserInfo = (from mi in _secUserInfoService.All().ToList()
where mi.UserName == user.UserName && mi.Password == SHA1.Encode(user.Password)
select new
{
UserID = mi.UserID,
UserName = mi.UserName,
Password = mi.Password,
Email = mi.Email
}).FirstOrDefault();
var HasBranch = _sysSetService.All().FirstOrDefault().HasBranch;
if (HasBranch == true)
{
if (UserInfo != null)
{
Session["ProjCode"] = "01";
Session["UserID"] = UserInfo.UserID;
Session["UserName"] = UserInfo.UserName;
Session["FinYear"] = user.FinYear;
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.HasSale == true)
{
string token = GetToken(ConfigurationManager.AppSettings["ApiUrl"], UserInfo.UserName, UserInfo.Password);
Session["token"] = token;
}
return(RedirectToAction("LogInWithBranch", "SecUserLogin"));
}
else
{
ViewBag.Message = "Login data is incorrect!";
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
else
{
if (UserInfo != null)
{
Session["ProjCode"] = "01";
Session["UserID"] = UserInfo.UserID;
Session["UserName"] = UserInfo.UserName;
Session["FinYear"] = user.FinYear;
Session["BranchCode"] = _branchService.All().FirstOrDefault().BranchCode;
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.HasSale == true)
{
string token = GetToken(ConfigurationManager.AppSettings["ApiUrl"], UserInfo.UserName, UserInfo.Password);
Session["token"] = token;
}
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Message = "Login data is incorrect!";
return(RedirectToAction("SecUserLogin", "SecUserLogin"));
}
}
}
catch (System.Exception)
{
throw;
}
}
public ActionResult BankOperation(BankOperation bankOperation, string errMsg)
{
if (bankOperation.bankAccode == null)
{
bankOperation.bankAccode = Session["BankAccode"].ToString();
var bankInfo = _newChartService.All().ToList().FirstOrDefault(x => x.Accode == bankOperation.bankAccode);
ViewBag.bankAccode = bankInfo.AcName;
Session["BankAccode"] = bankInfo.Accode;
}
else
{
var bankInfo = _newChartService.All().ToList().FirstOrDefault(x => x.Accode == bankOperation.bankAccode);
ViewBag.bankAccode = bankInfo.AcName;
Session["BankAccode"] = bankInfo.Accode;
}
List <NewChart> charts = _newChartService.All().ToList().Where(x => x.Accode.Substring(0, 1) == "1" || x.Accode.Substring(0, 1) == "3" || x.Accode.Substring(0, 1) == "2").ToList();
// List<NewChart> charts = _newChartService.All().ToList().Where(x => x.Accode.Substring(0, 1) == "3").ToList();
List <NewChart> finalList = new List <NewChart>();
foreach (var chart in charts)
{
bool key = true;
foreach (var temp in charts)
{
if (chart == temp)
{
}
else
{
if (chart.Accode == temp.ParentAcCode)
{
key = false;
}
}
}
if (key)
{
finalList.Add(chart);
}
}
ViewBag.brPurAccode = new SelectList(finalList, "Accode", "AcName");
List <NewChart> echarts = _newChartService.All().ToList().Where(x => x.Accode.Substring(0, 1) == "1" || x.Accode.Substring(0, 1) == "2" || x.Accode.Substring(0, 1) == "4").ToList();
List <NewChart> efinalList = new List <NewChart>();
foreach (var chart in echarts)
{
bool key = true;
foreach (var temp in echarts)
{
if (chart == temp)
{
}
else
{
if (chart.Accode == temp.ParentAcCode)
{
key = false;
}
}
}
if (key)
{
efinalList.Add(chart);
}
}
ViewBag.purAccode = new SelectList(efinalList, "Accode", "AcName");
ViewBag.SubCode = new SelectList(_subsidiaryService.All().ToList(), "SubCode", "SubName");
ViewBag.bankCode = new SelectList(_BankInfoService.All().ToList(), "BankCode", "BankName");
DateTime datetime = DateTime.Now;
ViewBag.Date = datetime.ToString("dd/MM/yyyy");
string branchCode = Session["BranchCode"].ToString();
string bankAccode = Session["BankAccode"].ToString();
//ViewBag.OpenBal = GetOpenBal(DateTime.Now, bankAccode);
ViewBag.OpenBal = GetOpenBal(datetime);
ViewBag.GLProvition = Counter("BOR", "PV");
ViewBag.GLEntries = CountVoucherMain("BOR", "MV", datetime);
ViewBag.GLProvitionB = Counter("BOP", "PV");
ViewBag.GLEntriesB = CountVoucherMain("BOP", "MV", datetime);
var bank = new List <BankOperationVModel>();
bank = GetAllRemittances(datetime, branchCode, bankAccode);
GetAllPayment(datetime, branchCode, bankAccode).ForEach(x => bank.Add(x));
ViewBag.Items = bank;
ViewBag.JobNo = LoadDropDown.LoadJobInfo();
//By Farhad For Remittance button/popup will be show/hide.
var sysSet = _sysSetService.All().ToList().FirstOrDefault();
ViewBag.MrConv = sysSet.MRConv;
ViewBag.MaintJob = sysSet.MaintJob;
Session["MaintLot"] = sysSet.MaintLot;
ViewBag.MaintLot = sysSet.MaintLot;
ViewBag.HasRemittance = sysSet.HasRemittance;
ViewBag.IsSubsidiaryCtrl = sysSet.IsSubsidiaryCtrl;
if (sysSet.IsSubsidiaryCtrl == true)
{
ViewBag.brSubCode = LoadDropDown.LoadSubsidiaryByPurpuse("", _subsidiaryService, _subsidiaryCtrlService);
}
else
{
ViewBag.brSubCode = LoadDropDown.LoadSubsidiary(_subsidiaryService);
}
ViewBag.errMsg = errMsg;
//For us Culture Ex: 0.00
const string culture = "en-US";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentCulture = ci;
Thread.CurrentThread.CurrentUICulture = ci;
return(View());
}
// GET: NewFile
public ActionResult NewFile()
{
ViewBag.ActID = LoadDropDown.LoadAllActions(_actionListService);
ViewBag.Lang = _sysSet.All().Select(x => x.Lang).First();
return(View());
}
public ActionResult GetReportLedger(RptSearchVModel vmodel, string finyear)
{
var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString());
if (ChkFYR != "")
{
return(RedirectToAction("Search", "Report", new { errMsg = ChkFYR }));
}
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("RptGeneralLedger_Preview"))
{
string errMsg = "No Preview Permission for this User !!";
return(RedirectToAction("Search", "Report", new { errMsg }));
}
Session["Branch"] = vmodel.BranchCode;
Session["LedgerType"] = vmodel.LedgerTypeCode;
Session["AccountCode"] = vmodel.AccountCode;
Session["fDate"] = vmodel.fDate;
Session["tDate"] = vmodel.toDate;
var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.LedgerTypeCode == vmodel.LedgerTypeCode);
ViewBag.LedgerCap = ledger.LedgerCap;
ViewBag.RptCap = ledger.RptCap;
ViewBag.OpeningCap = ledger.OpeningCap;
ViewBag.ClosingCap = ledger.ClosingCap;
ViewBag.Col1Cap = ledger.Col1Cap;
ViewBag.Col2Cap = ledger.Col2Cap;
ViewBag.Col3Cap = ledger.Col3Cap;
ViewBag.Col4Cap = ledger.Col4Cap;
ViewBag.Col5Cap = ledger.Col5Cap;
ViewBag.Col6Cap = ledger.Col6Cap;
ViewBag.Col7Cap = ledger.Col7Cap;
ViewBag.Col8Cap = ledger.Col8Cap;
ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate);
ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate);
ViewBag.AccountCode = vmodel.AccountCode;
ViewBag.BranchCode = vmodel.BranchCode;
ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch;
if (vmodel.BranchCode != null && vmodel.BranchCode != "0")
{
ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString();
}
else
{
ViewBag.Branch = "All";
}
if (vmodel.LedgerTypeCode == "01")
{
ViewBag.Account = _NewChartService.All().FirstOrDefault(x => x.Accode == vmodel.AccountCode.Trim()).AcName.ToString();
}
else if (vmodel.LedgerTypeCode == "02")
{
ViewBag.Account = _SubsidiaryService.All().FirstOrDefault(x => x.SubCode == vmodel.AccountCode.Trim()).SubName.ToString();
}
else
{
ViewBag.Account = _ItemService.All().FirstOrDefault(x => x.ItemCode == vmodel.AccountCode.Trim()).ItemName.ToString();
}
finyear = Session["FinYear"].ToString();
string sql = string.Format(" EXEC " + ledger.SP_Name + " '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.AccountCode + "','" + vmodel.fDate.ToString("MM-dd-yyyy") + "','" + vmodel.toDate.ToString("MM-dd-yyyy") + "'");
List <ReportLedger> rptLedger = _ReportLedgerService.SqlQueary(sql).ToList();
//For us Culture Ex: 0.00
const string culture = "en-US";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentCulture = ci;
Thread.CurrentThread.CurrentUICulture = ci;
return(View(rptLedger));
}
