public IActionResult CollectionEntry() { SalesCollectionVM model = new SalesCollectionVM(); model.FOSList = _commonRepo.BindDropdown("FOSM").ToSelectList(); model.RetailerList = _commonRepo.BindDropdown("RETAILER").ToSelectList(); return(View(model)); }
public DataTable InsertCollectionEntry(SalesCollectionVM model) { string strSelectedSalesIds = String.Join(',', model.SelectedSalesIds); SqlParameter[] arrproc; string spName = "InsertCollectionEntry"; arrproc = new SqlParameter[6]; arrproc[0] = new SqlParameter("@FOSCode", model.FOSCode); arrproc[1] = new SqlParameter("@RetailerCode", model.RetailerCode); arrproc[2] = new SqlParameter("@ReceivedAmount", model.ReceivedAmount); arrproc[3] = new SqlParameter("@ReceiptNumber", model.ReceiptNumber); arrproc[4] = new SqlParameter("@ReceiptDate", model.ReceiptDate); arrproc[5] = new SqlParameter("@SelectedSalesIds", strSelectedSalesIds); return(_dbContext.ExecSQLProc(spName, arrproc)); }
public IActionResult CollectionEntry(SalesCollectionVM model) { try { _SalesRepo.InsertCollectionEntry(model); Success("Record Saved Successfully"); return(RedirectToAction("CollectionEntry")); } catch (Exception) { Error("Something Went Wrong!!"); } model.FOSList = _commonRepo.BindDropdown("FOSM").ToSelectList(); model.RetailerList = _commonRepo.BindDropdown("RETAILER").ToSelectList(); return(View(model)); }