public ActionResult CostCodeCreate() { MainApplication model = new MainApplication(); //GET LOGIN SHOP DETAILS var username = HttpContext.Session["UserName"].ToString(); // IF EXCEPT SUPERADMIN LOGIN THEN SHOW SHOP OR GODOWN if (username != "SuperAdmin") { string shopcode = string.Empty; int modulelastcount = _ModuleService.GetLastRow().Id; for (int i = 96; i <= modulelastcount; i++) { var assigndetails = _UserCredentialService.GetDetailsByEmailStatusAndModuleId(UserEmail, i); if (assigndetails != null) { if (assigndetails.AssignRightsCode.Contains("SH")) { Session["LOGINSHOPGODOWNCODEOWGS"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAMEOWGS"] = assigndetails.Modules; } else { Session["LOGINSHOPGODOWNCODEOWGS"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAMEOWGS"] = assigndetails.Modules; } break; } } } model.userCredentialList = _UserCredentialService.GetUserCredentialsByEmail(UserEmail); model.modulelist = _ModuleService.getAllModules(); model.CompanyCode = CompanyCode; model.CompanyName = CompanyName; model.FinancialYear = FinancialYear; return(View(model)); }
public ActionResult JobWorkPayment() { MainApplication model = new MainApplication() { JobWorkPaymentDetails = new JobWorkPayment(), }; //CREATE JOB WORK PAYMENT CODE string year = FinancialYear; string[] yr = year.Split(' ', '-'); string FinYr = "/" + yr[2].Substring(2) + "-" + yr[6].Substring(2); string paymentcode = string.Empty; var jobworkpaymentdata = _JobWorkPaymentService.GetLastPaymentByFinYr(FinYr); int PaymentVal = 0; int length = 0; if (jobworkpaymentdata != null) { paymentcode = jobworkpaymentdata.PaymentCode.Substring(3, 6); length = (Convert.ToInt32(paymentcode) + 1).ToString().Length; PaymentVal = Convert.ToInt32(paymentcode) + 1; } else { PaymentVal = 1; length = 1; } paymentcode = _utilityService.getName("JWP", length, PaymentVal); paymentcode = paymentcode + FinYr; model.JobWorkPaymentDetails.PaymentCode = paymentcode; //GET LOGIN SHOP DETAILS var username = HttpContext.Session["UserName"].ToString(); //IF EXCEPT SUPERADMIN LOGIN THEN SHOW SHOP OR GODOWN if (username != "SuperAdmin") { string shopcode = string.Empty; int modulelastcount = _ModuleService.GetLastRow().Id; for (int i = 96; i <= modulelastcount; i++) { var assigndetails = _IUserCredentialService.GetDetailsByEmailStatusAndModuleId(UserEmail, i); if (assigndetails != null) { if (assigndetails.AssignRightsCode.Contains("SH")) { Session["LOGINSHOPGODOWNCODE"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAME"] = assigndetails.Modules; } else { Session["LOGINSHOPGODOWNCODE"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAME"] = assigndetails.Modules; } break; } } } model.userCredentialList = _IUserCredentialService.GetUserCredentialsByEmail(UserEmail); model.modulelist = _ModuleService.getAllModules(); model.CompanyCode = CompanyCode; model.CompanyName = CompanyName; model.FinancialYear = FinancialYear; return(View(model)); }
public ActionResult Create() { MainApplication model = new MainApplication() { OutwardToTailorDetails = new OutwardToTailor(), }; string year = FinancialYear; string[] yr = year.Split(' ', '-'); string FinYr = "/" + yr[2].Substring(2) + "-" + yr[6].Substring(2); string OutwardCode = string.Empty; var details = _OutwardToTailorService.GetLastRowrByFinYr(FinYr); int val = 0; int length = 0; if (details != null) { OutwardCode = details.OutwardCode.Substring(4, 6); length = (Convert.ToInt32(OutwardCode) + 1).ToString().Length; val = Convert.ToInt32(OutwardCode) + 1; val = details.Id; val = val + 1; length = val.ToString().Length; } else { val = 1; length = 1; } OutwardCode = _UtilityService.getName("OWTT", length, val); OutwardCode = OutwardCode + FinYr; model.OutwardToTailorDetails.OutwardCode = OutwardCode; TempData["PreviousOutToTailor"] = OutwardCode; //GET LOGIN SHOP DETAILS var username = HttpContext.Session["UserName"].ToString(); // IF EXCEPT SUPERADMIN LOGIN THEN SHOW SHOP OR GODOWN if (username != "SuperAdmin") { string shopcode = string.Empty; int modulelastcount = _ModuleService.GetLastRow().Id; for (int i = 96; i <= modulelastcount; i++) { var assigndetails = _IUserCredentialService.GetDetailsByEmailStatusAndModuleId(UserEmail, i); if (assigndetails != null) { if (assigndetails.AssignRightsCode.Contains("SH")) { Session["LOGINSHOPGODOWNCODEOWGS"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAMEOWGS"] = assigndetails.Modules; } else { Session["LOGINSHOPGODOWNCODEOWGS"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAMEOWGS"] = assigndetails.Modules; } break; } } } model.userCredentialList = _IUserCredentialService.GetUserCredentialsByEmail(UserEmail); model.modulelist = _ModuleService.getAllModules(); model.CompanyCode = CompanyCode; model.CompanyName = CompanyName; model.FinancialYear = FinancialYear; model.RetailBillList = _RetailBillService.GetAll(); model.JobWorkerList = _JobWorkerService.GetAll(); return(View(model)); }
public ActionResult CreateCarryForward() { MainApplication model = new MainApplication() { BalanceCarryForwardDetails = new BalanceCarryForward(), }; var username = HttpContext.Session["UserName"].ToString(); if (username != "SuperAdmin") { string shopcode = string.Empty; int modulelastcount = _iIModuleService.GetLastRow().Id; for (int i = 95; i <= modulelastcount; i++) { var assigndetails = _IUserCredentialService.GetDetailsByEmailStatusAndModuleId(UserEmail, i); if (assigndetails != null) { if (assigndetails.AssignRightsCode.Contains("SH")) { Session["LOGINSHOPGODOWNCODE"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAME"] = assigndetails.Modules; } else { Session["LOGINSHOPGODOWNCODE"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAME"] = assigndetails.Modules; } break; } } } model.userCredentialList = _IUserCredentialService.GetUserCredentialsByEmail(UserEmail); model.modulelist = _iIModuleService.getAllModules(); model.CompanyCode = CompanyCode; model.CompanyName = CompanyName; model.FinancialYear = FinancialYear; string year = FinancialYear; string[] yr = year.Split(' ', '-'); string FinYr = "/" + yr[2].Substring(2) + "-" + yr[6].Substring(2); var carryforwarddata = _BalanceCarryForwardService.GetLastRowByFinYr(FinYr); string CarryaforwardCode = string.Empty; int carryforwardvalue = 0; int len = 0; if (carryforwarddata != null) { CarryaforwardCode = carryforwarddata.CarryForwardCode.Substring(4, 6); len = (Convert.ToInt32(CarryaforwardCode) + 1).ToString().Length; carryforwardvalue = Convert.ToInt32(CarryaforwardCode) + 1; } else { carryforwardvalue = 1; len = 1; } CarryaforwardCode = _utilityservice.getName("BCFW", len, carryforwardvalue); CarryaforwardCode = CarryaforwardCode + FinYr; model.BalanceCarryForwardDetails.CarryForwardCode = CarryaforwardCode; var TodayDate = DateTime.Now; var PreviousDate = DateTime.Now.AddDays(-1); var newPreviousDate = PreviousDate; double TodayOpeningBalance = 0; double TodayClosingBalance = 0; var CarryForwdDetails = _BalanceCarryForwardService.GetDataByDate(Convert.ToDateTime(TodayDate).Date); if (CarryForwdDetails != null) { Session["TodayCarryForwdData"] = "Yes"; } else { Session["TodayCarryForwdData"] = "No"; } var CarryForwardData = _BalanceCarryForwardService.GetDataByDate(Convert.ToDateTime(PreviousDate).Date); if (CarryForwardData == null) { TodayOpeningBalance = 0; Session["TodayOpeningBalance"] = 0; } else { TodayOpeningBalance = Convert.ToDouble(CarryForwardData.ClosingBalance); Session["TodayOpeningBalance"] = TodayOpeningBalance; } double SOOpeningBal = 0; double RBOpeningBal = 0; double SBOpeningBal = 0; double IIClosingBal = 0; double IEClosingBal = 0; double ROOpeningBal = 0; double CardChequeHandOpeningBal = 0; double CashHandOpeningBal = 0; double TotalOpeningBal = 0; model.CashierSalesOrderList = _CashierSalesOrderService.GetOrderNoByDate(Convert.ToDateTime(TodayDate).Date); foreach (var cashsalesbilldata in model.CashierSalesOrderList) { SOOpeningBal = SOOpeningBal + Convert.ToDouble(cashsalesbilldata.AdvancePayment); } model.CashierRetailBillList = _CashierRetailBillService.GetBillsByDate(Convert.ToDateTime(TodayDate).Date); foreach (var cashretailbilldata in model.CashierRetailBillList) { RBOpeningBal = RBOpeningBal + Convert.ToDouble(cashretailbilldata.Payment); } model.CashierSalesBillList = _CashierSalesBillService.GetBillsByDate(Convert.ToDateTime(TodayDate).Date); foreach (var cashsalesbilldata in model.CashierSalesBillList) { SBOpeningBal = SBOpeningBal + Convert.ToDouble(cashsalesbilldata.Payment); } var IndirectIncomeDetails = _IncomeExchangeVoucherService.GetEntryByDateAndVoucherType(Convert.ToDateTime(TodayDate), "Receipt"); foreach (var entry in IndirectIncomeDetails) { IIClosingBal = IIClosingBal + Convert.ToDouble(entry.Amount); } model.CashierRefundOrderList = _CashierRefundOrderService.GetBillsByDate(Convert.ToDateTime(TodayDate).Date); foreach (var cashdrefundorderdata in model.CashierRefundOrderList) { ROOpeningBal = ROOpeningBal + Convert.ToDouble(cashdrefundorderdata.RefundAmount); } model.CardChequeHandoverList = _CardChequeHandoverService.GetDataByDate(Convert.ToDateTime(TodayDate).Date); foreach (var cardchequedata in model.CardChequeHandoverList) { CardChequeHandOpeningBal = CardChequeHandOpeningBal + Convert.ToDouble(cardchequedata.CardChequeAmount); } model.CashHandoverList = _CashHandoverService.GetDataByDate(Convert.ToDateTime(TodayDate).Date); foreach (var cashdata in model.CashHandoverList) { CashHandOpeningBal = CashHandOpeningBal + Convert.ToDouble(cashdata.HandoverCash); } var IndirectIncData = _IncomeExchangeVoucherService.GetEntryByDateAndVoucherType(Convert.ToDateTime(TodayDate), "Expense"); foreach (var entry in IndirectIncData) { IEClosingBal = IEClosingBal + Convert.ToDouble(entry.Amount); } TodayClosingBalance = TodayOpeningBalance + SOOpeningBal + RBOpeningBal + SBOpeningBal + IIClosingBal - ROOpeningBal - CardChequeHandOpeningBal - CashHandOpeningBal - IEClosingBal; Session["TodayClosingBalance"] = TodayClosingBalance; return(View(model)); }
public ActionResult PurchaseReturn() { MainApplication model = new MainApplication(); model.userCredentialList = _UserCredentialService.GetUserCredentialsByEmail(UserEmail); model.modulelist = _ModuleService.getAllModules(); model.CompanyCode = CompanyCode; model.CompanyName = CompanyName; model.FinancialYear = FinancialYear; var username = HttpContext.Session["UserName"].ToString(); if (username != "SuperAdmin") { int modulelastcount = _ModuleService.GetLastRow().Id; for (int i = 96; i <= modulelastcount; i++) { var assigndetails = _UserCredentialService.GetDetailsByEmailStatusAndModuleId(UserEmail, i); if (assigndetails != null) { Session["LOGINSHOPGODOWNCODE"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAME"] = assigndetails.Modules; break; } } } string shopcode = Session["LOGINSHOPGODOWNCODE"].ToString(); string year = FinancialYear; string[] yr = year.Split(' ', '-'); string FinYr = "/" + yr[2].Substring(2) + "-" + yr[6].Substring(2); var LastPurchaseReturn = _PurchaseReturnService.GetLastPurchaseByFinYr(FinYr, shopcode); string PurchaseReturnCode = string.Empty; int PurchaseReturnLength = 0; int PurchaseReturnNo = 0; if (LastPurchaseReturn == null) { PurchaseReturnLength = 1; PurchaseReturnNo = 1; } else { int PurchaseReturnIndex = LastPurchaseReturn.PurchaseReturnNo.LastIndexOf('P'); PurchaseReturnCode = LastPurchaseReturn.PurchaseReturnNo.Substring(PurchaseReturnIndex + 2, 6); PurchaseReturnLength = (Convert.ToInt32(PurchaseReturnCode) + 1).ToString().Length; PurchaseReturnNo = Convert.ToInt32(PurchaseReturnCode) + 1; } string name = Session["SHOPGODOWNNAME"] as string; string utilityname = string.Empty; if (shopcode.Contains("SH")) { var details = _ShopService.GetShopDetailsByName(name); utilityname = details.ShortCode + "/PR"; } else { var details = _GodownService.GetGodownDetailsByName(name); utilityname = details.ShortCode + "/PR"; } PurchaseReturnCode = _UtilityService.getName(utilityname, PurchaseReturnLength, PurchaseReturnNo); PurchaseReturnCode = PurchaseReturnCode + FinYr; model.PurchaseReturnNo = PurchaseReturnCode; TempData["PreviousPurchaseReturnNo"] = PurchaseReturnCode; return(View(model)); }
public ActionResult Dashboard() { //GET LOGIN SHOP DETAILS var username = HttpContext.Session["UserName"].ToString(); // IF EXCEPT SUPERADMIN LOGIN THEN SHOW SHOP OR GODOWN if (username != "SuperAdmin") { int modulelastcount = _iIModuleService.GetLastRow().Id; var AssignRights = _IUserCredentialService.GetUserCredentialsByEmail(UserEmail); if (AssignRights.Count() == 0) { TempData["NotEnoughRights"] = "Yes"; return(RedirectToAction("Login", "User")); } else { int rightscount = 0; for (int i = 96; i <= modulelastcount; i++) { var assigndetails = _IUserCredentialService.GetDetailsByEmailStatusAndModuleId(UserEmail, i); if (assigndetails != null) { Session["LOGINSHOPGODOWNCODE"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAME"] = assigndetails.Modules; break; } else { rightscount++; } } if (modulelastcount - 96 == rightscount) { Session["LOGINSHOPGODOWNCODE"] = null; Session["SHOPGODOWNNAME"] = null; } } } MainApplication model = new MainApplication(); model.userCredentialList = _IUserCredentialService.GetUserCredentialsByEmail(UserEmail); model.modulelist = _iIModuleService.getAllModules(); model.CompanyCode = CompanyCode; model.CompanyName = CompanyName; model.FinancialYear = FinancialYear; string loggedinshopname = Session["SHOPGODOWNNAME"] as string; TempData["PendingPoes"] = _IPurchaseOrderDetailService.GetPendingPo("Pending"); TempData["Inward"] = _IPurchaseOrderDetailService.GetInwardDetailsByDate(); TempData["OutwardToShop"] = _OutwardToShopService.GetDailyOutwardsToShop(); TempData["OutwardShopToGodown"] = _OutwardShopToGodownService.GetDailyOutwardsToGodown(); TempData["OutwardInterGodown"] = _OutwardInterGodownService.GetDailyOutwardInterGodown(); TempData["OutwardInterShop"] = _OutwardInterShopService.GetDailyOutwardInterShop(); TempData["OutwardToClient"] = _IOutwardToClientService.GetOutWardToClientByDate(); TempData["InwardWithoutPO"] = _InwardFromSupplierService.GetDailyInwardWithoutPo(); TempData["InwardFromGodown"] = _InwardFromGodownService.GetDailyInwardsFromGodown(); TempData["InwardShopToGodown"] = _InwardFromShopToGodownService.GetDailyInwardsShopToGodown(); TempData["InwardInterGodown"] = _InwardInterGodownService.GetDailyInwardInterGodown(); TempData["InwardInterShop"] = _InwardInterShopService.GetDailyInwardInterShop(); TempData["EntryStock"] = _EntryStockItemService.GetAllItems(); TempData["ShopStock"] = _IShopStockService.GetShopStockTillDate(); TempData["GodownStock"] = _GodownStockService.GetGodownStockTillDate(); TempData["RetailBill"] = _IRetailInvoiceMasterService.GetRetailBillByDate(); TempData["SalesBill"] = _ISalesBillService.GetSalesBillByDate(); TempData["Quotations"] = _QuotationService.GetDailyQuotations(); TempData["SalesOrders"] = _SalesOrderService.GetDailySalesOrders(); TempData["DeliveryChallans"] = _DeliveryChallanService.GetDailyChallans(); TempData["SalesReturns"] = _SalesReturnService.GetDailySalesReturns(); TempData["PurchaseReturns"] = _PurchaseReturnService.GetDailyPurchaseReturns(); TempData["CashierSalesOrder"] = _CashierSalesOrderService.GetDailyCashierSalesOrder(); TempData["CashierRetailBill"] = _CashierRetailBillService.GetDailyCashierRetailBill(); TempData["CashierTempCashMemo"] = _CashierTemporaryCashMemoService.GetDailyCashierTempCashMemo(); TempData["CashierSalesBill"] = _CashierSalesBillService.GetDailyCashierSalesBill(); TempData["CashierRefundOrder"] = _CashierRefundOrderService.GetDailyCashierRefundOrder(); TempData["CashHandover"] = _CashHandoverService.GetDailyCashHandover(); TempData["CardChequeHandover"] = _CardChequeHandoverService.GetDailyCardChequeHandover(); TempData["IncomeExchangeVoucher"] = _IncomeExchangeVoucherService.GetDailyIncomeExchangeVoucher(); TempData["Requisitionsshops"] = _RequisitionForShopService.GetDailyRequisitionsForShops(loggedinshopname); TempData["Requisitionsgodowns"] = _RequisitionForShopService.GetDailyRequisitionsForGodowns(loggedinshopname); TempData["Requisitionssuperadmin"] = _RequisitionForShopService.GetDailyRequisitionsForSuperAdmin(loggedinshopname); TempData["Requisitionsgodowns1"] = _RequisitionForGodownService.GetDailyRequisitionsForGodowns(loggedinshopname); TempData["Requisitionssuperadmin1"] = _RequisitionForGodownService.GetDailyRequisitionsForSuperAdmin(loggedinshopname); //DASHBOARD FOR LOGIN PERSON FOR EXCEPT SUPERADMIN var loginuserdetails = _EmployeeMasterService.getEmpByEmail(UserEmail); TempData["EmployeeDesignation"] = loginuserdetails.Designation; TempData["EmployeeDepartment"] = loginuserdetails.department; if (loginuserdetails.Designation == "PurchaseManager") { Session["LOGINSHOPGODOWNCODE"] = "PurchaseManager"; Session["SHOPGODOWNNAME"] = "PurchaseManager"; } return(View(model)); }
public ActionResult CreateBillPayment() { MainApplication model = new MainApplication() { BillPaymentDetails = new BillPayment(), }; var details = _BillPaymentService.GetLastRow(); int val = 0; int length = 0; if (details != null) { val = details.Id; val = val + 1; length = val.ToString().Length; } else { val = 1; length = 1; } String code = _utilityservice.getName("BP", length, val); model.BillPaymentDetails.BillPaymentCode = code; //GET LOGIN SHOP DETAILS var username = HttpContext.Session["UserName"].ToString(); // IF EXCEPT SUPERADMIN LOGIN THEN SHOW SHOP OR GODOWN if (username != "SuperAdmin") { string shopcode = string.Empty; int modulelastcount = _iIModuleService.GetLastRow().Id; for (int i = 96; i <= modulelastcount; i++) { var assigndetails = _IUserCredentialService.GetDetailsByEmailStatusAndModuleId(UserEmail, i); if (assigndetails != null) { if (assigndetails.AssignRightsCode.Contains("SH")) { Session["LOGINSHOPGODOWNCODEOWGS"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAMEOWGS"] = assigndetails.Modules; } else { Session["LOGINSHOPGODOWNCODEOWGS"] = assigndetails.AssignRightsCode; Session["SHOPGODOWNNAMEOWGS"] = assigndetails.Modules; } break; } } } model.userCredentialList = _IUserCredentialService.GetUserCredentialsByEmail(UserEmail); model.modulelist = _iIModuleService.getAllModules(); model.CompanyCode = CompanyCode; model.CompanyName = CompanyName; model.FinancialYear = FinancialYear; return(View(model)); }