// GET: Accountings/Payments/Create public IActionResult Create() { ViewData["BankAccountId"] = new SelectList(_context.BankAccounts, "BankAccountId", "Account"); ViewData["PartyId"] = new SelectList(_context.Parties, "PartyId", "PartyName"); ViewData["StoreId"] = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, _returnUrl); return(PartialView()); }
public async Task <IActionResult> Create([Bind("ExpenseId,Particulars,PartyName,EmployeeId,OnDate,PayMode,BankAccountId,PaymentDetails,Amount,Remarks,PartyId,LedgerEnteryId,IsCash,StoreId,UserId,EntryStatus")] Expense expense) { if (ModelState.IsValid) { if (expense.PayMode == PaymentMode.Cash) { expense.BankAccountId = null; } _context.Add(expense); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BankAccountId"] = new SelectList(_context.BankAccounts, "BankAccountId", "Account", expense.BankAccountId); ViewData["EmployeeId"] = new SelectList(_context.Employees, "EmployeeId", "StaffName", expense.EmployeeId); ViewData["PartyId"] = new SelectList(_context.Parties.OrderBy(c => c.PartyName), "PartyId", "PartyName", expense.PartyId); ViewData["StoreId"] = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, _returnUrl); Console.WriteLine($"StoreId+{expense.StoreId}\tEnt {expense.EntryStatus},\t us {expense.UserId}, \taa=" + ModelState.IsValid); foreach (var modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { Console.WriteLine(error.ErrorMessage); } } return(View(expense)); }
public IActionResult Index() { // Setting Store Info Here ViewBag.StoreID = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Home/Index"); MasterViewReport mvr = DashboardWidget.GetMasterViewReport(_context); return(View(mvr)); }
// GET: Accounts/CashPayments/Create public IActionResult Create() { ViewData["TranscationModeId"] = new SelectList(_context.TranscationModes, "TranscationModeId", "Transcation"); // ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreId"); ViewData["StoreId"] = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, _returnUrl); return(PartialView()); }
// GET: DailySales/Create public IActionResult Create() { // Setting Store Info Here ViewBag.StoreID = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Sales/DailySales"); ViewData["SalesmanId"] = new SelectList(db.Salesmen, "SalesmanId", "SalesmanName"); return(PartialView()); }
public IActionResult Index() { int StoreId = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Sales/DailySales"); var vm = aprajitaContext.RegularInvoices.Include(c => c.Customer).Include(c => c.SaleItems).Include(c => c.PaymentDetail) .Where(c => c.IsManualBill && c.StoreId == StoreId).OrderByDescending(c => c.OnDate).ThenByDescending(c => c.InvoiceNo).ToList(); return(View(vm)); }
// GET: Tailoring/TalioringBookings/Create public IActionResult Create() { // Setting Store Info Here ViewBag.StoreID = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Tailoring/TalioringBookings"); ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreName"); return(PartialView()); }
public async Task <IActionResult> Create([Bind("TalioringBookingId,BookingDate,CustName,DeliveryDate,TryDate,BookingSlipNo,TotalAmount,TotalQty,ShirtQty,ShirtPrice,PantQty,PantPrice,CoatQty,CoatPrice,KurtaQty,KurtaPrice,BundiQty,BundiPrice,Others,OthersPrice,IsDelivered,StoreId,UserId,EntryStatus,IsReadOnly")] TalioringBooking talioringBooking) { if (ModelState.IsValid) { _context.Add(talioringBooking); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewBag.StoreID = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Tailoring/TalioringBookings"); ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreName", talioringBooking.StoreId); return(View(talioringBooking)); }
public async Task <IActionResult> Create([Bind("CashReceiptId,InwardDate,TranscationModeId,ReceiptFrom,Amount,SlipNo,Remarks,StoreId,UserId,EntryStatus,IsReadOnly")] CashReceipt cashReceipt) { if (ModelState.IsValid) { _context.Add(cashReceipt); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["TranscationModeId"] = new SelectList(_context.TranscationModes, "TranscationModeId", "Transcation", cashReceipt.TranscationModeId); // ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreId", cashReceipt.StoreId); ViewData["StoreId"] = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, _returnUrl); return(View(cashReceipt)); }
// GET: Accountings/Payments/Edit/5 public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } var payment = await _context.Payments.FindAsync(id); if (payment == null) { return(NotFound()); } ViewData["BankAccountId"] = new SelectList(_context.BankAccounts, "BankAccountId", "Account", payment.BankAccountId); ViewData["PartyId"] = new SelectList(_context.Parties, "PartyId", "PartyName", payment.PartyId); ViewData["StoreId"] = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, _returnUrl); return(PartialView(payment)); }
public IActionResult ReprintInvoice(int?id, int?Download) { // Setting Store Info Here int StoreId = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Sales/DailySales"); ViewBag.StoreID = StoreId; var vm = aprajitaContext.RegularInvoices.Include(c => c.Customer).Include(c => c.SaleItems).Include(c => c.PaymentDetail). ThenInclude(c => c.CardDetail).Where(c => c.RegularInvoiceId == id && c.StoreId == StoreId).FirstOrDefault(); string fileName = new RegularSaleManager().RePrintManaulInvoice(aprajitaContext, vm, StoreId); if (Download != null && Download == 101) { return(File(fileName, "application/pdf", Path.GetFileName(fileName))); } return(File(fileName, "application/pdf")); }
public async Task <IActionResult> Create([Bind("ReceiptId,PartyName,RecieptSlipNo,OnDate,PayMode,BankAccountId,PaymentDetails,Amount,Remarks,PartyId,LedgerEnteryId,IsCash,StoreId,UserName")] Receipt receipt) { if (ModelState.IsValid) { if (receipt.PayMode == PaymentMode.Cash) { receipt.BankAccountId = null; } _context.Add(receipt); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BankAccountId"] = new SelectList(_context.BankAccounts, "BankAccountId", "Account", receipt.BankAccountId); ViewData["PartyId"] = new SelectList(_context.Parties, "PartyId", "PartyName", receipt.PartyId); ViewData["StoreId"] = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, _returnUrl); return(View(receipt)); }
public async Task <IActionResult> AddEditPaymentDetails(string InvNo) { // Setting Store Info Here ViewBag.StoreID = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Sales/DailySales"); ViewData["EDCId"] = new SelectList(db.CardMachine, "EDCId", "EDCName"); if (String.IsNullOrEmpty(InvNo)) { return(NotFound()); } else { var paydetails = await db.CardTranscations.Where(c => c.InvoiceNumber == InvNo).FirstOrDefaultAsync(); if (paydetails == null) { return(View(new EDCTranscation { OnDate = DateTime.Today.Date, InvoiceNumber = InvNo, StoreId = ViewBag.StoreID })); } return(View(paydetails)); } }
public async Task <IActionResult> Edit(int id, [Bind("ReceiptId,PartyName,RecieptSlipNo,OnDate,PayMode,BankAccountId,PaymentDetails,Amount,Remarks,PartyId,LedgerEnteryId,IsCash,StoreId,UserName")] Receipt receipt) { if (id != receipt.ReceiptId) { return(NotFound()); } if (ModelState.IsValid) { try { if (receipt.PayMode == PaymentMode.Cash) { receipt.BankAccountId = null; } _context.Update(receipt); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ReceiptExists(receipt.ReceiptId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["BankAccountId"] = new SelectList(_context.BankAccounts, "BankAccountId", "Account", receipt.BankAccountId); ViewData["PartyId"] = new SelectList(_context.Parties, "PartyId", "PartyName", receipt.PartyId); ViewData["StoreId"] = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, _returnUrl); return(View(receipt)); }
// GET: DailySales public async Task <IActionResult> Index(int?id, string salesmanId, string currentFilter, string searchString, DateTime?SaleDate, string sortOrder, int?pageNumber) { // Setting Store Info Here int StoreId = ActiveSession.GetActiveSession(HttpContext.Session, HttpContext.Response, "/Identity/Account/Login?ReturnUrl=/Sales/DailySales"); ViewData["InvoiceSortParm"] = String.IsNullOrEmpty(sortOrder) ? "inv_desc" : ""; ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date"; ViewData["ManualSortParm"] = sortOrder == "Manual" ? "notManual_desc" : "Manual"; if (searchString != null) { pageNumber = 1; } else { searchString = currentFilter; } ViewData["CurrentFilter"] = searchString; //For Current Day var dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.SaleDate == DateTime.Today && c.StoreId == StoreId); if (id != null && id == 101) { //All dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.StoreId == StoreId).OrderByDescending(c => c.SaleDate).ThenByDescending(c => c.DailySaleId); } else if (id != null && id == 104) { dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.SaleDate == DateTime.Today.AddDays(-1) && c.StoreId == StoreId); } else if (id != null && id == 102) { //Current Month dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.SaleDate.Month == DateTime.Today.Month && c.SaleDate.Year == DateTime.Today.Year && c.StoreId == StoreId).OrderByDescending(c => c.SaleDate).ThenByDescending(c => c.DailySaleId); } else if (id != null && id == 103) { //Last Month dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.SaleDate.Month == DateTime.Today.Month - 1 && c.SaleDate.Year == DateTime.Today.Year && c.StoreId == StoreId).OrderByDescending(c => c.SaleDate).ThenByDescending(c => c.DailySaleId); } else { dailySales = dailySales.OrderByDescending(c => c.SaleDate).ThenByDescending(c => c.DailySaleId); } if (!String.IsNullOrEmpty(searchString)) { dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.InvNo == searchString && c.StoreId == StoreId); //return View(await dls.ToListAsync()); } else if (!String.IsNullOrEmpty(salesmanId) || SaleDate != null) { //IEnumerable<DailySale> DailySales; if (SaleDate != null) { dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.SaleDate == SaleDate && c.StoreId == StoreId).OrderByDescending(c => c.DailySaleId); } else { dailySales = db.DailySales.Include(d => d.Salesman).Where(c => c.SaleDate.Month == DateTime.Today.Month && c.SaleDate.Year == DateTime.Today.Year && c.StoreId == StoreId).OrderByDescending(c => c.SaleDate).ThenByDescending(c => c.DailySaleId); } if (!String.IsNullOrEmpty(salesmanId)) { dailySales = dailySales.Where(c => c.Salesman.SalesmanName == salesmanId); } } // For All Invoice #region FixedUI SaleInfoUIVM uIVM = new SaleInfoUIVM(); uIVM = uIVM.GetSaleInfo(db, StoreId); // Fixed UI ViewBag.TodaySale = uIVM.TodaySale; ViewBag.ManualSale = uIVM.ManualSale; ViewBag.MonthlySale = uIVM.MonthlySale; ViewBag.DuesAmount = uIVM.DuesAmount; ViewBag.CashInHand = uIVM.CashInHand; ViewBag.LastMonthSale = uIVM.LastMonthSale; #endregion FixedUI #region bySalesman // By Salesman var salesmanList = new List <string>(); var smQry = from d in db.Salesmen orderby d.SalesmanName select d.SalesmanName; salesmanList.AddRange(smQry.Distinct()); ViewBag.salesmanId = new SelectList(salesmanList); #endregion bySalesman #region ByDate //var dateList = new List<DateTime>(); //var opdQry = from d in db.DailySales // orderby d.SaleDate // select d.SaleDate; //dateList.AddRange(opdQry.Distinct()); //ViewBag.dateID = new SelectList(dateList); #endregion ByDate //By Invoice No Search switch (sortOrder) { case "Manual": dailySales = dailySales.OrderBy(c => c.IsManualBill); break; case "notManual_desc": dailySales = dailySales.OrderByDescending(c => c.IsManualBill); break; case "inv_desc": dailySales = dailySales.OrderByDescending(s => s.InvNo); break; case "Date": dailySales = dailySales.OrderBy(s => s.SaleDate); break; case "date_desc": dailySales = dailySales.OrderByDescending(s => s.SaleDate); break; default: dailySales = dailySales.OrderBy(s => s.InvNo); break; } int pageSize = 10; return(View(await PaginatedList <DailySale> .CreateAsync(dailySales.AsNoTracking(), pageNumber ?? 1, pageSize))); }