public ActionResult ShowEntryReturnedInvoiceDetails(string invoiceSerialNo, string saleableRows, string unsaleableList) { ViewBag.Title = _saleReturnedSteps[3]; ViewBag.InvoiceSerial = JsonConvert.DeserializeObject <int>(invoiceSerialNo); var saleable = JsonConvert.DeserializeObject(saleableRows); var unsaleable = JsonConvert.DeserializeObject(unsaleableList); #region Table Data var tableData = Connections.SaleBranch.SqlConn.ExecuteReader( "sp_GetSaleReturnInvoiceDetailsTable", new { SerialNo = ViewBag.InvoiceSerial }, commandType: CommandType.StoredProcedure).ToDataTable(); var tblModel = new TableOption() { Id = "saleReturnInvoicesRecipts", Data = tableData, Orders = new[] { Tuple.Create(0, OrderType.desc) }, Checkable = false }; #endregion var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _saleReturnedSteps, CurrentStepIndex = 4 }; return(View("SaleReturnedInvoice/ShowEntryReturnedInvoiceDetails", Tuple.Create(multipleStepOpt, tblModel))); }
public ActionResult CertificationCountingWarehouseDetails(string serial, string countingRows) { ViewBag.Title = "تایید نهایی شمارش انبار"; ViewBag.Serial = JsonConvert.DeserializeObject <int>(serial); var result = new WarehouseApiController().StoreWarehouseCounting(serial, countingRows); var table = new TableOption() { Id = "CountingWarehouseHistoryDetails", Data = result, DisplayRowsLength = 10, Orders = new[] { Tuple.Create(0, OrderType.asc) }, CurrencyColumns = new [] { 3 }, Checkable = false }; var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _countingWarehouseSteps, CurrentStepIndex = 3 }; var model = Tuple.Create(table, multipleStepOpt); return(View("CountingWarehouse/CertificationCountingWarehouseDetails", model)); }
// GET: Warehouse/SaleReturnInvoices public ActionResult SaleReturnInvoices() { ViewBag.Title = "انتخاب یک فاکتور برگشت از فروش"; var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _saleReturnedSteps, CurrentStepIndex = 1 }; return(View("SaleReturnedInvoice/SaleReturnInvoices", multipleStepOpt)); }
// GET: Warehouse/CountingWarehouse public ActionResult CountingWarehouse() { ViewBag.Title = "انتخاب شمارش انبار"; var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _countingWarehouseSteps, CurrentStepIndex = 1 }; return(View("CountingWarehouse/CountingWarehouse", multipleStepOpt)); }
// GET: Warehouse/ChooseReturnedInvoiceDetails/?invoiceSerial={invoiceSerial} public ActionResult ChooseReturnedInvoiceDetails(int invoiceSerial) { ViewBag.Title = $"انتخاب اقلام برگشتی قابل فروش"; ViewBag.InvoiceSerial = invoiceSerial; var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _saleReturnedSteps, CurrentStepIndex = 2 }; return(View("SaleReturnedInvoice/ChooseReturnedInvoiceDetails", multipleStepOpt)); }
// GET: Warehouse/FillCountingWarehouseDetails/?serial={serial} public ActionResult FillCountingWarehouseDetails(int serial) { ViewBag.Title = "شمارش موجودی انبار"; ViewBag.Serial = serial; #region Table Data var tableData = Connections.SaleBranch.SqlConn.ExecuteReader( "sp_GetEmptyCountingWarehouseHistoryDetailsTable", new { CountingSerialNo = serial }, commandType: CommandType.StoredProcedure).ToDataTable(); var table = new TableOption() { Id = "EmptyCountingWarehouseHistoryDetails", Data = tableData, DisplayRowsLength = 10, Orders = new[] { Tuple.Create(0, OrderType.asc) }, //TotalFooterColumns = new string[] { "وزن خالص" }, CurrencyColumns = new int[] { 3 }, Checkable = false }; var txtOpt = new TextBoxOption() { Placeholder = "موجودی", DataStyle = DataStyleType.warning, Max = 999999, Min = 0, Step = 1, Type = InputTypes.Number, DefaultValue = "0" }; table.InputColumnsDataMember["5"] = txtOpt; table.InputColumnsDataMember["6"] = txtOpt; var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _countingWarehouseSteps, CurrentStepIndex = 2 }; var model = Tuple.Create(table, multipleStepOpt); #endregion return(View("CountingWarehouse/FillCountingWarehouseDetails", model)); }
public ActionResult Index() { var opt = new MultipleStepProgressTabOption() { Steps = new List <string>() { "Step 1", "Step 2", "Step 3", "Step 4", "End Step" }, CurrentStepIndex = 3 }; return(View(opt)); }
public ActionResult ShowEntryReturnedInvoiceDetails(string invoiceSerialNo, string saleableRows, string unsaleableList) { ViewBag.Title = "ورود به انبار برگشتی"; var serialNo = JsonConvert.DeserializeObject <int>(invoiceSerialNo); var saleable = JsonConvert.DeserializeObject(saleableRows); var unsaleable = JsonConvert.DeserializeObject(unsaleableList); var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _saleReturnedSteps, CurrentStepIndex = 4 }; return(View("SaleReturnedInvoice/ShowEntryReturnedInvoiceDetails", multipleStepOpt)); }
// GET: Warehouse/SaleReturnInvoices public ActionResult SaleReturnInvoices() { ViewBag.Title = _saleReturnedSteps[0]; #region Clear Temp BusinessDoc in use Connections.SaleCore.SqlConn.ExecuteAsync( "DELETE FROM dbo.TempBusinessDocInUse WHERE UserID = @UserID AND BusinessDocTypeID = 16", new { UserID = CurrentUser.Id }); #endregion var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _saleReturnedSteps, CurrentStepIndex = 1 }; return(View("SaleReturnedInvoice/SaleReturnInvoices", multipleStepOpt)); }
// GET: Warehouse/CertificationSelectedReturnedInvoiceDetails/?invoiceSerial={invoiceSerial}&rows={rows} public ActionResult CertificationSelectedReturnedInvoiceDetails(int invoiceSerial, string rows) { ViewBag.Title = "تایید برگشتی قابل فروش و غیر قابل فروش"; ViewBag.InvoiceSerial = invoiceSerial; string[] sRows = ViewBag.SaleableRows = rows.Split(','); #region Table Data var tableData = Connections.SaleBranch.SqlConn.ExecuteReader( "sp_GetSaleReturnInvoiceDetailsTable", new { SerialNo = invoiceSerial }, commandType: CommandType.StoredProcedure).ToDataTable(); // creates a copy of the schema (columns)only. DataTable lstSaleable = tableData.Clone(), lstUnSaleable = tableData.Clone(); // check row id for saleable list foreach (DataRow row in tableData.Rows) { if (sRows.Contains(row[0].ToString())) // row[0] = row["Id"] { lstSaleable.Rows.Add(row.ItemArray); } else { lstUnSaleable.Rows.Add(row.ItemArray); } } var modelSaleable = new TableOption() { Id = "saleable", Data = lstSaleable, DisplayRowsLength = -1, Orders = new[] { Tuple.Create(0, OrderType.asc) }, Checkable = false }; var modelUnSaleable = new TableOption() { Id = "unsaleable", Data = lstUnSaleable, DisplayRowsLength = -1, Orders = new[] { Tuple.Create(0, OrderType.asc) } }; var reasons = Connections.SaleCore.SqlConn.Query("SELECT ReasonID, ReasonName FROM Reason"); var reasonComboOpt = new ComboBoxOption() { Placeholder = "انتخاب علت برگشتی", MenuHeaderText = "علت برگشتی را انتخاب کنید", ShowOptionSubText = false, DataStyle = Core.Enums.DataStyleType.warning, ShowTick = true, DataLiveSearch = true, DataSize = "8", Data = reasons.Select(x => new ComboBoxDataModel() { Value = ((object)x.ReasonID).ToString(), Text = x.ReasonName }).ToList() }; modelUnSaleable.InputColumnsDataMember["4"] = reasonComboOpt; var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _saleReturnedSteps, CurrentStepIndex = 3 }; var model = Tuple.Create(modelSaleable, modelUnSaleable, multipleStepOpt); #endregion return(View("SaleReturnedInvoice/CertificationSelectedReturnedInvoiceDetails", model)); }
// GET: Warehouse/ChooseReturnedInvoiceDetails/?invoiceSerial={invoiceSerial} public async Task <ActionResult> ChooseReturnedInvoiceDetails(int invoiceSerial) { ViewBag.Title = _saleReturnedSteps[1]; ViewBag.InvoiceSerial = invoiceSerial; #region Insert in use Business Doc into temp // clear older data of this user await Connections.SaleCore.SqlConn.ExecuteAsync( "DELETE FROM SaleCore.dbo.TempBusinessDocInUse WHERE UserID = @UserID AND BusinessDocTypeID = 16", new { UserID = CurrentUser.Id }); await Connections.SaleCore.SqlConn.ExecuteAsync( "INSERT INTO SaleCore.dbo.TempBusinessDocInUse VALUES (@UserID , @BusinessDocNo , @BusinessDocTypeID , @ModifyDate)", new { UserID = CurrentUser.Id, BusinessDocNo = invoiceSerial, BusinessDocTypeID = 16, ModifyDate = DateTime.Now }); #endregion var multipleStepOpt = new MultipleStepProgressTabOption() { Steps = _saleReturnedSteps, CurrentStepIndex = 2 }; #region Warehouse List for Store Combo var customerStoreCode = Connections.SaleBranch.SqlConn.QueryFirst <int>( "SELECT dbo.fn_GetCustomerStoreCode(" + "(SELECT TOP(1) PersonID FROM dbo.udft_BusinessDoc(dbo.fn_GetLongDate()) " + "WHERE BusinessDocNo = dbo.fn_GetBusinessDocNo(@invoiceSerial, 16)))", new { invoiceSerial }); var stores = DatabaseContext.GetWarehouses(true, false, customerStoreCode); var storesOpt = new ComboBoxOption() { AutoComplete = true, Data = stores, Checked = true, AutoFocus = true, MenuHeaderText = "انبار برگشتی", MultipleSelection = false, Placeholder = "انبار برگشتی", Name = "WarehouseSelector", DataStyle = DataStyleType.info, ShowOptionSubText = false, DataLiveSearch = false, ShowSelectDeselectAllOptionsBox = true, DataWidth = "25%", ShowTick = true }; #endregion dynamic model = new ExpandoObject(); model.MultipleStepOpt = multipleStepOpt; model.StoresComboOpt = storesOpt; return(View("SaleReturnedInvoice/ChooseReturnedInvoiceDetails", model)); }