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));
}
