public List <Warehouses> GetWarehouses()
{
CouchRequest <Warehouses> list = new CouchRequest <Warehouses>();
var url = "http://127.0.0.1:5984/_fti/local/warehouse/_design/searchwarehouse/by_flag?q=flag:1";
var user = new User();
var lucene1 = new List <Warehouses> ();
Task <string> task = HTTP_GET(url);
task.Wait();
var res = task.Result;
var lucene = JsonConvert.DeserializeObject <LuceneRequest <Warehouses> >(res);
foreach (var l in lucene.rows)
{
Warehouses ev = new Warehouses();
ev = l.fields;
ev._id = l.id;
lucene1.Add(ev);
}
return(lucene1);
}
public TransactionItemsListViewModel()
{
CleanUp();
_unitOfWork = new UnitOfWork(DbContextUtil.GetDbContextInstance());
FilterStartDate = DateTime.Now.AddYears(-1);
FilterEndDate = DateTime.Now.AddDays(1);
Messenger.Default.Register <ItemDTO>(this, (message) => { SelectedItem = message; });
Messenger.Default.Register <TransactionTypes>(this, (message) => { Transaction = message; });
LoadCategories();
GetLiveItems();
GetWarehouses();
if (Warehouses != null && Warehouses.Any())
{
if (SelectedWarehouse == null)
{
SelectedWarehouse = Warehouses.FirstOrDefault(w => w.IsDefault) ?? Warehouses.FirstOrDefault();
}
else
{
SelectedWarehouse = SelectedWarehouse;
}
}
}
public WareHouseCtrl(string _account, string SID)
{
Account = _account;
string str = "select * from Warehouses where ID='" + SID + "'";
DataTable dt = db.getTable(str, Account);
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
Warehouses = new Warehouses();
Warehouses.ID = int.Parse(SID);
Warehouses.Address = dr["Address"].ToString();
Warehouses.CreatDate = dr["CreatDate"].ToString();
Warehouses.Creator = dr["Creator"].ToString();
Warehouses.HouseName = dr["HouseName"].ToString();
Warehouses.HouseType = dr["HouseType"].ToString();
Warehouses.Remark = dr["Remark"].ToString();
Warehouses.Status = int.Parse(dr["Status"].ToString());
Code = "0000";
Msg = "成功";
}
else
{
Code = "0001";
Msg = "未找到信息";
}
}
private void UpdateReturnEntryProperties()
{
NewEntryVM.PurchaseReturnEntryWarehouse = Warehouses.Single(
warehouse => warehouse.ID.Equals(_selectedPurchaseTransactionLine.Warehouse.ID));
NewEntryVM.PurchaseReturnEntryProduct = _selectedPurchaseTransactionLine.Item.Name;
NewEntryVM.PurchaseReturnEntryQuantity = 0;
}
public ViewResult Edit(int?WarehousesID)
{
Warehouses warehouses = repository.Warehousess.FirstOrDefault(p => p.WarehousesID == WarehousesID);
Populate(warehouses.actID);
return(View(warehouses));
}
private void AddNewPayment()
{
if (Warehouses != null)
{
SelectedWarehouse = Warehouses.FirstOrDefault();
}
else
{
return;
}
if (SelectedWarehouse != null && SelectedWarehouse.Id != -1 && SelectedPayment == null)
{
SelectedPayment = new PaymentDTO
{
Type = PaymentType,
PaymentDate = DateTime.Now,
ReceiptDate = DateTime.Now,
PaymentMethod = PaymentMethods.Cash,
Status = PaymentStatus.NotCleared,
WarehouseId = SelectedWarehouse.Id //,
//Check=new CheckDTO()
//{
// CheckDate = DateTime.Now
//}
}
}
;
}
private void UpdateWarehouses()
{
var oldSelectedWarehouse = _selectedWarehouse;
Warehouses.Clear();
var allWarehouse = new Warehouse {
ID = -1, Name = "All"
};
Warehouses.Add(new WarehouseVM {
Model = allWarehouse
});
using (var context = new ERPContext())
{
var warehousesFromDatabase = context.Warehouses.OrderBy(warehouse => warehouse.Name);
foreach (var warehouse in warehousesFromDatabase)
{
Warehouses.Add(new WarehouseVM {
Model = warehouse
});
}
}
UpdateSelectedWarehouse(oldSelectedWarehouse);
}
public ActionResult AjaxShippingMethod(int warehouseID)
{
IRepository <Warehouses> Warehouses = new GenericRepository <Warehouses>(db);
IRepository <ShippingMethod> Method = new GenericRepository <ShippingMethod>(db);
JsonResult result = new JsonResult();
try
{
Warehouses warehouse = Warehouses.Get(warehouseID);
if (warehouse == null)
{
throw new Exception("Not found warehouse!");
}
var methodData = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, bool> >(warehouse.CarrierData);
result.data = Method.GetAll(true).Where(m => methodData.ContainsKey(m.ID.ToString()) && methodData[m.ID.ToString()]).ToDictionary(m => m.ID.ToString(), m => m.Name);
}
catch (Exception e)
{
result.Error(e.InnerException != null ? e.InnerException.Message : e.Message);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(int id)
{
ViewBag.Exception = null;
string msg = null;
Warehouses warehouses = db.Warehouses.Find(id);
db.Warehouses.Remove(warehouses);
try
{
db.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException == null)
{
msg = e.Message;
}
else
{
msg = e.InnerException.InnerException.Message;
}
ViewBag.Exception = msg;
return(View(warehouses));
}
return(RedirectToAction("Index"));
}
public void bntCreate_Click(Object sender, EventArgs e)
{
var id = Page.Request.Params["id"];
var userInSession = (Users)Session["userinsession"];
var warehouse = new Warehouses()
{
Name = tbName.Text.Trim(),
StreetPrefix = ddlStreetPrefix.SelectedValue,
StreetName = tbStreetName.Text.Trim(),
StreetNumber = tbStreetNumber.Text.Trim(),
Housing = tbHousing.Text.Trim(),
ApartmentNumber = tbApartmentNumber.Text.Trim(),
CityID = Convert.ToInt32(hfCityID.Value)
};
if (id == null)
{
warehouse.CreateDate = DateTime.Now;
warehouse.Create();
}
else
{
warehouse.ID = Convert.ToInt32(id);
warehouse.ChangeDate = DateTime.Now;
warehouse.Update(userInSession.ID, OtherMethods.GetIPAddress(), "WarehouseEdit");
}
Page.Response.Redirect("~/ManagerUI/Menu/Souls/WarehousesView.aspx");
}
private void ResetTransaction()
{
NewEntryVM.ResetEntryFields();
NewEntryVM.NewEntryWarehouse = null;
IsTransactionNotPaid = true;
NotEditMode = true;
IsTransactionTaxCheckBoxSelected = false;
Model = new PurchaseTransaction();
TransactionSupplier = null;
TransactionDOID = null;
TransactionTax = 0;
TransactionDiscount = 0;
TransactionNote = null;
TransactionDate = UtilityMethods.GetCurrentDate().Date;
TransactionDueDate = UtilityMethods.GetCurrentDate().Date;
Warehouses.Clear();
SupplierItems.Clear();
DisplayedLines.Clear();
UpdateSuppliers();
OnPropertyChanged("TransactionGrossTotal");
OnPropertyChanged("TransactionNetTotal");
SetTransactionID();
}
public ActionResult Create([Bind(Include = "id,name")] Warehouses warehouses)
{
ViewBag.Exception = null;
string msg = "";
db.Warehouses.Add(warehouses);
try
{
db.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException == null)
{
msg = e.Message;
}
else
{
msg = e.InnerException.InnerException.Message;
}
ViewBag.Exception = msg;
return(View(warehouses));
}
return(RedirectToAction("Index"));
}
public tblWarehouse GetWarehouse(string warehouseName)
{
tblWarehouse warehouse;
Warehouses.TryGetValue(warehouseName, out warehouse);
return(warehouse);
}
public ActionResult AddWarehouse(Warehouses warehouse)
{
warehouse.currentCapacity = 0;
db.Warehouses.Add(warehouse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AjaxWaitingData(DataFilter filter, int page = 1, int rows = 100)
{
int warehouseID = 0, total = 0;
List <object> dataList = new List <object>();
if (int.TryParse(Session["warehouseId"].ToString(), out warehouseID))
{
Warehouses = new GenericRepository <Warehouses>(db);
Warehouses warehouse = Warehouses.Get(warehouseID);
if (warehouse != null && warehouse.WarehouseType.Equals((int)WarehouseTypeType.DropShip))
{
/** Order Filter **/
var OrderFilter = db.Orders.AsNoTracking().Where(o => !o.StatusCode.Value.Equals((int)OrderStatusCode.Completed) && o.PaymentStatus.Value.Equals((int)OrderPaymentStatus2.Charged));
/** Shipping Method Filter **/
var MethodFilter = db.ShippingMethod.AsNoTracking().Where(m => m.IsEnable && !m.IsDirectLine);
List <OrderJoinData> results = DataFilter(filter, OrderFilter, MethodFilter, EnumData.ProcessStatus.待出貨, warehouseID);
if (results.Any())
{
TimeZoneConvert timeZoneConvert = new TimeZoneConvert();
EnumData.TimeZone TimeZone = MyHelp.GetTimeZone((int)Session["TimeZone"]);
int length = rows;
int start = (page - 1) * length;
total = results.Count();
results = results.OrderByDescending(oData => oData.order.TimeOfOrder).Skip(start).Take(length).ToList();
string[] skus = results.SelectMany(oData => oData.items.Select(i => i.ProductID)).Distinct().ToArray();
Dictionary <string, string> skuNameList = db.Skus.AsNoTracking().Where(s => s.IsEnable.Value && skus.Contains(s.Sku)).ToDictionary(s => s.Sku, s => s.ProductName);
int[] itemIDs = results.SelectMany(oData => oData.items.Select(i => i.ID)).ToArray();
Dictionary <int, string[]> serialOfItem = db.SerialNumbers.AsNoTracking().Where(s => itemIDs.Contains(s.OrderItemID)).GroupBy(s => s.OrderItemID).ToDictionary(s => s.Key, s => s.Select(ss => ss.SerialNumber).ToArray());
dataList.AddRange(results.Select(oData => new
{
OrderID = oData.order.OrderID,
POId = oData.package.POId,
PackageID = oData.package.ID,
ItemID = oData.item.ID,
PaymentDate = oData.payment != null ? timeZoneConvert.InitDateTime(oData.payment.AuditDate.Value, EnumData.TimeZone.EST).ConvertDateTime(TimeZone).ToString("MM/dd/yyyy<br />hh:mm tt") : "",
Sku = oData.itemCount == 1 ? oData.item.ProductID : "Multi",
DisplayName = oData.itemCount == 1 ? skuNameList[oData.item.ProductID] : "Multi",
ItemCount = oData.itemCount,
OrderQtyTotal = oData.items.Sum(i => i.Qty),
ShippingCountry = oData.address.CountryName,
ShippingMethod = oData.package.ShippingMethod.Value,
StatusCode = Enum.GetName(typeof(OrderStatusCode), oData.order.StatusCode.Value),
Comment = oData.package.Comment,
SupplierComment = string.IsNullOrEmpty(oData.package.SupplierComment) ? "" : oData.package.SupplierComment,
Serials = oData.items.Where(i => serialOfItem.ContainsKey(i.ID)).ToDictionary(i => i.ID, i => serialOfItem[i.ID]),
SerialNumber = oData.itemCount + oData.item.Qty == 2 ? (serialOfItem.ContainsKey(oData.item.ID) ? serialOfItem[oData.item.ID].First() : "") : "Multi",
TrackingNumber = string.IsNullOrEmpty(oData.package.TrackingNumber) ? "" : oData.package.TrackingNumber,
POInvoice = string.IsNullOrEmpty(oData.package.POInvoice) ? "" : oData.package.POInvoice
}));
}
}
}
return(Content(JsonConvert.SerializeObject(new { total, rows = dataList }), "appllication/json"));
}
public ActionResult DeleteConfirmed(int id)
{
Warehouses warehouses = db.Warehouses.Find(id);
db.Warehouses.Remove(warehouses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private SvenTechCollection <Warehouse> LoadAllWarehouses()
{
SvenTechCollection <Warehouse> allWarehouses = new SvenTechCollection <Warehouse>();
allWarehouses = Warehouses.GetAll().ToSvenTechCollection();
return(allWarehouses);
}
public object Get(Warehouses request)
{
var resp = new Dto <List <Models.Dto.Warehouse> >();
resp.Result = Handler.List(request.Skip, request.Take).Map(Models.Dto.Warehouse.From);
return(resp);
}
private void FinalizeProduction()
{
ReduceResources();
ReduceCoins();
WarehouseDistance warehouseDistance = Warehouses.FindClosestWarehouse(GetComponent <Details>().dimensions);
print("Distance: " + warehouseDistance.distance);
}
private void OpenAddStorageDialog()
{
var dialog = dialogService.ShowDialog <AddStorageDialogWindow, AddStorageDialogViewModel>();
if (dialog.DialogResult == true)
{
Warehouses.Add(dialog.ResultInfo.CreatedWarehouse);
}
}
public static string IdToName(int id)
{
var warehouse = new Warehouses {
ID = id
};
warehouse.GetById();
return(warehouse.Name);
}
//
// Methods
//
public Warehouse(SAP sap, string whscode)
{
oWarehouse = (Warehouses)sap.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oWarehouses);
oWarehouse.GetByKey(whscode);
InitialStockAccount = oWarehouse.StockAccount;
InitialCostOfGoodsSoldAccount = oWarehouse.CostOfGoodsSold;
InitialAllocationAccount = oWarehouse.TransfersAcc;
}
public void lbDelete_Click(Object sender, EventArgs e)
{
DeleteAccess();
var userInSession = (Users)Session["userinsession"];
var lb = (LinkButton)sender;
var warehouse = new Warehouses();
warehouse.Delete(Convert.ToInt32(lb.CommandArgument), userInSession.ID, OtherMethods.GetIPAddress(), "WarehousesView");
Page.Response.Redirect("~/ManagerUI/Menu/Souls/WarehousesView.aspx");
}
public ActionResult Delete(int WarehousesID)
{
Warehouses delwarehouse = repository.DeleteWarehouses(WarehousesID);
if (delwarehouse != null)
{
TempData["message"] = string.Format("Usunięto {0}", delwarehouse.Name);
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(Warehouses warehouses)
{
if (ModelState.IsValid)
{
db.Entry(warehouses).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(warehouses));
}
//
// GET: /WarehousesAdmin/Details/5
public ActionResult Details(int id = 0)
{
Warehouses warehouses = db.Warehouses.Find(id);
if (warehouses == null)
{
return(HttpNotFound());
}
return(View(warehouses));
}
public ActionResult Create(Warehouses warehouses)
{
if (ModelState.IsValid)
{
db.Warehouses.Add(warehouses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(warehouses));
}
private void ChangeSelectedWarehouse(SelectedWarehouse SelectedWarehouse)
{
WarehouseList = Warehouses.GetAll().ToSvenTechCollection();
if (SelectedStockyard == null)
{
SelectedStockyard = new Stockyard();
}
SelectedStockyard.Warehouse = SelectedWarehouse.Warehouse;
SelectedStockyard.RefWarehouseId = SelectedWarehouse.Warehouse.WarehouseId;
RaisePropertyChanged("SelectedStockyard");
}
private void SaveWarehouse()
{
if (SelectedWarehouse.WarehouseId != 0)
{
Warehouses.Update(SelectedWarehouse);
}
else
{
SelectedWarehouse.WarehouseId = Warehouses.Insert(SelectedWarehouse);
}
}
public Warehouses DeleteWarehouses(int WarehousesID)
{
Warehouses dbEntry = context.Warehousess.Find(WarehousesID);
if (dbEntry != null)
{
context.Warehousess.Remove(dbEntry);
context.SaveChanges();
}
return(dbEntry);
}
