// GET: Warehouse/InWay/?code={code}
public ActionResult InWay(string code)
{
ViewBag.Title = "توراهی";
var model = new TableOption()
{
Id = "entryInWay"
};
if (!string.IsNullOrEmpty(code))
{
ViewBag.QrCode = code.Length < 8 ? code : code.RepairCipher()?.Decrypt();
#region Table Data
var tableData = Connections.SaleBranch.SqlConn.ExecuteReader(
"sp_GetInWayDetailsByOldInvoicId",
new { OldInvoicId = ViewBag.QrCode },
commandType: CommandType.StoredProcedure).ToDataTable();
model.Data = tableData;
model.DisplayRowsLength = 50;
model.TotalFooterColumns = new[] { "TotalPrice", "Qty" }; // column by name "تعداد" and "قیمت کل"
model.CurrencyColumns = new[] { 7, 8, 9 };
#endregion
}
return(View("InWay/InWay", model));
}
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));
}
public ActionResult CheckAndRepairUser(string empId)
{
if (string.IsNullOrEmpty(empId))
{
return(View());
}
using (var multi = Connections.SaleDistributeIdentity.SqlConn.QueryMultiple("sp_CheckAndCreateEmployeesRoles", new { EmployeId = empId }, commandType: CommandType.StoredProcedure))
{
var customer = multi.Read(); // don't use .ToDataTable() here because it is read twice !!!
var menus = multi.Read(); // don't use .ToDataTable() here because it is read twice !!!
var optCustomer = new TableOption()
{
Data = customer.ToDataTable()
};
var optMenus = new TableOption()
{
Data = menus.ToDataTable()
};
ApplicationDbContext.Create().SaveChanges();
return(View(Tuple.Create(optCustomer, optMenus)));
}
}
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)));
}
/// <exclude/>
public ITableBuilder Apply(TableOption option, object[] value)
{
if (option.GetType() == typeof(TableOption) && ((TableOption)option) == TableOption.columns)
return Columns(value.Select(o => o.ToString()).ToArray());
else
return ApplyToTable(option.FieldName(), string.Format("[{0}]", string.Join(",", value)));
}
// GET: Warehouse/ChooseReturnedInvoiceDetailsTable/?invoiceSerial={invoiceSerial}
public ActionResult ChooseReturnedInvoiceDetailsTable(int invoiceSerial)
{
ViewBag.InvoiceSerial = invoiceSerial;
#region Table Data
var tableData = Connections.SaleBranch.SqlConn.ExecuteReader(
"sp_GetSaleReturnInvoiceDetailsTable", new { SerialNo = invoiceSerial },
commandType: CommandType.StoredProcedure).ToDataTable();
var model = new TableOption()
{
Id = "saleReturnInvoices",
Data = tableData,
DisplayRowsLength = -1,
Orders = new[] { Tuple.Create(0, OrderType.asc) },
TotalFooterColumns = new string[] { "تعداد" },
CurrencyColumns = new int[] { 8 },
Checkable = true
};
#endregion
return(PartialView("SaleReturnedInvoice/_ChooseReturnedInvoiceDetailsTablePartial", model));
}
// GET: ReceiptsTable
public ActionResult ReceiptsTable()
{
ViewBag.Username = CurrentUser.UserName;
// Fill Table data ------------------------------------------
#region Table Data
var tableData = Connections.SaleBranch.SqlConn.ExecuteReader(
"sp_GetInvoiceRemain",
new { EmployeeID = CurrentUser.UserName, EmployeeTypeid = CurrentUser.EmployeeType, RunDate = "2" },
commandType: CommandType.StoredProcedure).ToDataTable();
var model = new TableOption()
{
Id = "receipts",
Data = tableData,
DisplayRowsLength = 10,
Orders = new[] { Tuple.Create(0, OrderType.desc) },
TotalFooterColumns = new[] { "InvoiceRemain", "Payable" },
AverageFooterColumns = new[] { "ShamsiDateDiff" },
CurrencyColumns = new[] { 8, 9 }
};
#endregion
//-----------------------------------------------------------
ToolsController.SetLastUserRunningAction(CurrentUser.UserName, "ReceiptsTable", tableData);
return(PartialView("Receipt/ReceiptsTable", model));
}
/// <exclude/>
public ITableBuilder Apply(TableOption option, object[] value)
{
if (option.GetType() == typeof(TableOption) && option == TableOption.Columns)
{
return(Columns(value.Select(o => o.ToString()).ToArray()));
}
else
{
return(ApplyToTable(option.FieldName(), $"[{string.Join(",", value)}]"));
}
}
// 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 DynamicView()
{
var model = new TableOption()
{
Id = "entryInWay"
};
#region Table Data
var tableData = Connections.Localhost.SqlConn.ExecuteReader("Select * From TestTable").ToDataTable();
model.Data = tableData;
model.DisplayRowsLength = 5;
#endregion
return(View(model));
}
// GET: Warehouse/CountingWarehouseHeaderTable
public ActionResult CountingWarehouseHeaderTable()
{
#region Table Data
var tableData = Connections.SaleBranch.SqlConn.ExecuteReader(
"sp_GetCountingWarehouseHistoryTable", commandType: CommandType.StoredProcedure).ToDataTable();
var model = new TableOption()
{
Id = "CountingWarehouseHeaderTable",
Data = tableData,
DisplayRowsLength = 10,
Orders = new[] { Tuple.Create(0, OrderType.desc) },
Checkable = false
};
#endregion
return(PartialView("CountingWarehouse/_CountingWarehouseHeaderTablePartial", model));
}
// GET: Warehouse/SaleReturnInvoicesTable
public ActionResult SaleReturnInvoicesTable()
{
#region Table Data
var tableData = Connections.SaleBranch.SqlConn.ExecuteReader(
"sp_GetSaleReturnInvoicesTable", commandType: CommandType.StoredProcedure).ToDataTable();
var model = new TableOption()
{
Id = "saleReturnInvoices",
Data = tableData,
DisplayRowsLength = 10,
Orders = new[] { Tuple.Create(0, OrderType.desc) },
TotalFooterColumns = new string[] { "مبلغ برگشتي" },
CurrencyColumns = new int[] { 6 },
Checkable = false
};
#endregion
return(PartialView("SaleReturnedInvoice/_SaleReturnInvoicesTablePartial", model));
}
private double GetUVWindHelper(double lat, double lon, TableOption para)
{
var x = (int)(Math.Floor(lat));
var y = (int)(Math.Floor(lon));
// Prevent interpolation using data that is out of range of array.
if (x == 90)
{
x = 89;
}
if (y == 180)
{
y = 179;
}
return(Interpolate2D.Interpolate(
new double[] { x, x + 1 },
new double[] { y, y + 1 },
new[] {
new[] { GetWindHelper(x, y, para), GetWindHelper(x, y + 1, para) },
new[] { GetWindHelper(x + 1, y, para), GetWindHelper(x + 1, y + 1, para) }
},
x, y));
}
// 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));
}
public override void ExplicitVisit(TableOption node) { this.action(node); }
/// <exclude/>
public ITableBuilder Apply(TableOption option, object value)
{
return(ApplyToTable(option.FieldName(), value));
}
private double GetWindHelper(int lat, int lon, TableOption para)
{
return(para == TableOption.U ?
uTable[lat + 90, lon + 180] :
vTable[lat + 90, lon + 180]);
}
/// <exclude/>
public ITableBuilder Apply(TableOption option, object value)
{
return ApplyToTable(option.FieldName(), value);
}
public override void ExplicitVisit(TableOption fragment)
{
_fragments.Add(fragment);
}
/// <inheritDoc/>
new public ITableBuilderT <TModel> Apply(TableOption option, object[] value)
{
base.Apply(option, value);
return(this);
}
