public ActionResult Edit(int id)
{
WarehouseModel model = db.WarehouseModel.Find(id);
CreateViewBag(model.ProvinceId, model.DistrictId, model.StoreId);
return(View(model));
}
/// <summary>
/// 修改库房信息SQL
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public string UpdateWarehouseInfoSQL(WarehouseModel input, LogedInUser CurrentUser)
{
StringBuilder sb = new StringBuilder();
sb.Append("update HC_BUYER_STORE");
sb.AppendFormat(" set ORG_ID='{0}'", CurrentUser.UserOrg.Id);
sb.AppendFormat(",STORE_NAME='{0}'", input.StoneName);
sb.AppendFormat(",STORE_ADDRESS='{0}'", input.Stone_address);
sb.AppendFormat(",LINKMAN='{0}'", input.Linman);
sb.AppendFormat(",TEL='{0}'", input.Linktel);
sb.AppendFormat(",type={0}", input.Type);
sb.AppendFormat(",ENABLE_FLAG='{0}'", input.Enalbe_flag);
sb.AppendFormat(",CREATE_USER_ID='{0}'", CurrentUser.HighId);
sb.AppendFormat(",CREATE_USER_NAME='{0}'", CurrentUser.UserInfo.Name);
sb.AppendFormat(",CREATE_DATE='{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.AppendFormat(",MODIFY_USER_ID='{0}'", CurrentUser.HighId);
sb.AppendFormat(",MODIFY_USER_NAME='{0}'", CurrentUser.UserInfo.Name);
sb.AppendFormat(",MODIFY_DATE='{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append(",SYNC_STATE='0'");
sb.AppendFormat(" where id='{0}'", input.Id);
return(sb.ToString());
}
/// <summary>
/// Wysłanie formularza
/// </summary>
/// <param name="sender">Obiekt wywołujący zdarzenie</param>
/// <param name="e">Obiekt zawierający parametry zdarzenia</param>
private void Submit_Click(object sender, RoutedEventArgs e)
{
// Pobranie modelu z formularza
OrderModel model = DataContext as OrderModel;
// Sprawdzenie czy produkt jest w magazynie
WarehouseModel product = WarehouseDao.LoadById(model.ProductId);
if (product.Amount < model.Amount)
{
MessageBox.Show("Niewystarczająca ilość produktu na magazynie", "Błąd");
return;
}
if (model.Mode == OrderModel.INSERT)
{
OrderDao.Insert(model);
MessageBox.Show("Zamówienie zostało dodane", "Dodawanie zamówienia");
}
else if (model.Mode == OrderModel.UPDATE)
{
// Przywrócenie poprzedniej ilości do magazynu
product.Amount += OrderDao.LoadById(model.Id).Amount;
OrderDao.Update(model);
MessageBox.Show("Zmiany zostały zapisane", "Edycja zamówienia");
}
// Usunięcie produktu z magazynu
product.Amount -= model.Amount;
WarehouseDao.Update(product);
Back();
}
/// <summary>
/// 增加库房信息SQL
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public string InsertWarehouseSQL(WarehouseModel input, LogedInUser CurrentUser)
{
StringBuilder sb = new StringBuilder();
Int64 id = base.GetClientId(CurrentUser.HighId);//IdUtil.GetClientId(CurrentUser.HighId);
sb.Append("insert HC_BUYER_STORE( \r\n\t\t\t\t\t");
sb.Append("ID,ORG_ID,STORE_NAME,STORE_ADDRESS,LINKMAN,CREATE_USER_ID,CREATE_USER_NAME,CREATE_DATE,MODIFY_USER_ID,MODIFY_USER_NAME,MODIFY_DATE,TEL,type,sync_state,ENABLE_FLAG\r\n");
sb.Append(" ) values \r\n");
sb.Append("(").Append(id).Append(",");
sb.Append("").Append(CurrentUser.UserOrg.Id).Append(",");
sb.Append("'").Append(input.StoneName).Append("',");
sb.Append("'").Append(input.Stone_address).Append("',");
sb.Append("'").Append(input.Linman).Append("',");
sb.Append("").Append(CurrentUser.HighId).Append(",");
sb.Append("'").Append(CurrentUser.UserInfo.Name).Append("',");
sb.Append("'").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("',");
sb.Append("").Append(CurrentUser.HighId).Append(",");
sb.Append("'").Append(CurrentUser.UserInfo.Name).Append("',");
sb.Append("'").Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("',");
sb.Append("'").Append(input.Linktel).Append("',");
sb.Append("'").Append(input.Type).Append("',");
sb.Append("'0','1')");
return(sb.ToString());
}
/// <summary>
/// 修改库房信息
/// </summary>
/// <returns></returns>
public void UpdateWarehouseInfo(WarehouseModel input, LogedInUser CurrentUser)
{
int result;
using (DbTransaction transaction = base.DbFacade.BeginTransaction(base.DbFacade.OpenConnection()))
{
try
{
result = base.DbFacade.SQLExecuteNonQuery(UpdateWarehouseInfoSQL(input, CurrentUser), transaction);
if (result > 0)
{
base.DbFacade.CommitTransaction(transaction);
}
else
{
base.DbFacade.RollbackTransaction(transaction);
}
}
catch (Exception e)
{
base.DbFacade.RollbackTransaction(transaction);
throw e;
}
}
}
public async Task <bool> AddProducer(Producer producer)
{
try
{
using (var context = new WarehouseModel())
{
var producerExists = context.Producers.Any(x => x.Name == producer.Name);
if (!producerExists)
{
context.Producers.Add(producer);
await context.SaveChangesAsync();
}
else
{
throw new Exception("Producer already exists in database.");
}
}
}
catch (Exception)
{
return(false);
}
return(true);
}
private static Warehouse getEntityByModel(WarehouseModel model)
{
if (model == null)
{
return(null);
}
Warehouse entity = new Warehouse();
if (model.Id == 0)
{
entity.CreateBy = AuthenticationHelper.UserId;
entity.CreateDate = DateTime.Now;
entity.CompanyId = AuthenticationHelper.CompanyId.Value;
}
else
{
entity.CreateBy = model.CreateBy;
entity.CreateDate = model.CreateDate;
entity.CompanyId = model.CompanyId;
}
entity.WarehouseName = model.WarehouseName;
entity.Id = model.Id;
entity.SOBId = model.SOBId;
entity.Status = model.Status;
entity.UpdateBy = AuthenticationHelper.UserId;
entity.UpdateDate = DateTime.Now;
return(entity);
}
public async Task <bool> AddDevice(Device device)
{
try
{
using (var context = new WarehouseModel())
{
var deviceExists = context.Devices.FirstOrDefault(x => x.ArticleNumber == device.ArticleNumber);
if (deviceExists != null)
{
deviceExists.Quantity += device.Quantity;
}
else
{
context.Devices.Add(device);
}
await context.SaveChangesAsync();
}
}
catch (Exception)
{
return(false);
}
return(true);
}
public async Task <bool> DeleteDevice(int Id)
{
try
{
using (var context = new WarehouseModel())
{
var existingDevice = context.Devices.FirstOrDefault(x => x.Id == Id);
if (existingDevice != null)
{
context.Devices.Remove(existingDevice);
await context.SaveChangesAsync();
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
return(true);
}
/// <summary>
/// Aktalizacja produktu w magazynie
/// </summary>
/// <param name="table">
/// Model produktu w magazynie
/// </param>
public static void Update(WarehouseModel table)
{
using (IDbConnection conn = new SQLiteConnection(LoadConnectionString()))
{
conn.Execute("UPDATE Warehouse SET Name = @Name, Amount = @Amount WHERE Id = @Id", table);
};
}
public async Task <bool> UpdateProject(Project project)
{
try
{
using (var context = new WarehouseModel())
{
var existingProject = context.Projects.FirstOrDefault(x => x.Id == project.Id);
if (existingProject != null)
{
existingProject.Name = project.Name;
existingProject.Status = project.Status;
existingProject.CustomerID = project.CustomerID;
existingProject.Comment = project.Comment;
await context.SaveChangesAsync();
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
return(true);
}
/// <summary>
/// Dodanie nowego produktu do magazynu
/// </summary>
/// <param name="table">
/// Model produktu w magazynie
/// </param>
public static void Insert(WarehouseModel table)
{
using (IDbConnection conn = new SQLiteConnection(LoadConnectionString()))
{
conn.Execute("INSERT INTO Warehouse (Name, Amount) VALUES(@Name, @Amount)", table);
};
}
public WarehousePopup(WarehouseView form, string type, int wid, object obj)
{
parentForm = form;
this.type = type;
this.wid = wid;
InitializeComponent();
if (type == "cw")
{
this.Text = "仓位";
}
if (obj != null)
{
if (type == "cw")
{
oldpm = (PositionModel)obj;
textBox1.Text = oldpm.Num;
textBox2.Text = oldpm.Name;
}
else
{
oldwm = (WarehouseModel)obj;
textBox1.Text = oldwm.Num;
textBox2.Text = oldwm.Name;
}
}
}
protected virtual async Task PrepareAddressWarehouseModel(WarehouseModel model)
{
model.Address.AvailableCountries.Add(new SelectListItem {
Text = _translationService.GetResource("Admin.Address.SelectCountry"), Value = ""
});
foreach (var c in await _countryService.GetAllCountries(showHidden: true))
{
model.Address.AvailableCountries.Add(new SelectListItem {
Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.Address.CountryId)
});
}
//states
var states = !String.IsNullOrEmpty(model.Address.CountryId) ? (await _countryService.GetCountryById(model.Address.CountryId))?.StateProvinces : new List <StateProvince>();
if (states.Count > 0)
{
foreach (var s in states)
{
model.Address.AvailableStates.Add(new SelectListItem {
Text = s.Name, Value = s.Id.ToString(), Selected = (s.Id == model.Address.StateProvinceId)
});
}
}
model.Address.CountryEnabled = true;
model.Address.StateProvinceEnabled = true;
model.Address.CityEnabled = true;
model.Address.StreetAddressEnabled = true;
model.Address.ZipPostalCodeEnabled = true;
model.Address.ZipPostalCodeRequired = true;
model.Address.PhoneEnabled = true;
model.Address.FaxEnabled = true;
model.Address.CompanyEnabled = true;
}
/// <summary>
/// Prepare warehouse model
/// </summary>
/// <param name="model">Warehouse model</param>
/// <param name="warehouse">Warehouse</param>
/// <param name="excludeProperties">Whether to exclude populating of some properties of model</param>
/// <returns>
/// A task that represents the asynchronous operation
/// The task result contains the warehouse model
/// </returns>
public virtual async Task <WarehouseModel> PrepareWarehouseModelAsync(WarehouseModel model, Warehouse warehouse, bool excludeProperties = false)
{
if (warehouse != null)
{
//fill in model values from the entity
if (model == null)
{
model = warehouse.ToModel <WarehouseModel>();
}
}
//prepare address model
var address = await _addressService.GetAddressByIdAsync(warehouse?.AddressId ?? 0);
if (!excludeProperties && address != null)
{
model.Address = address.ToModel(model.Address);
}
await _addressModelFactory.PrepareAddressModelAsync(model.Address, address);
model.Address.CountryRequired = true;
model.Address.ZipPostalCodeRequired = true;
return(model);
}
public IActionResult CreateWarehouse()
{
var model = new WarehouseModel();
PrepareAddressWarehouseModel(model);
return(View(model));
}
private void confirmOrderButton_Click(object sender, RoutedEventArgs e)
{
OrdersModel order = new OrdersModel();
var selectedOrder = (dynamic)listOrdersListView.SelectedItems[0];
order.idOrder = selectedOrder.idOrder;
order.idParts = selectedOrder.idParts;
order.amount = selectedOrder.amount;
order.orderDate = selectedOrder.orderDate;
order.status = selectedOrder.status;
order.realizationDate = selectedOrder.realizationDate;
order.bookedAmount = selectedOrder.bookedAmount;
var warehouse = DatabaseAccess.loadWarehouse();
WarehouseModel part = new WarehouseModel();
for (int i = 0; i < warehouse.Count; i++)
{
if (warehouse[i].idParts == order.idParts)
{
part = warehouse[i];
break;
}
}
DatabaseAccess.updateOrders(order, part); //change status - finished
loadOrdersList();
}
public virtual IActionResult CreateWarehouse()
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
{
return(AccessDeniedView());
}
var model = new WarehouseModel();
model.Address.AvailableCountries.Add(new SelectListItem {
Text = _localizationService.GetResource("Admin.Address.SelectCountry"), Value = "0"
});
foreach (var c in _countryService.GetAllCountries(showHidden: true))
{
model.Address.AvailableCountries.Add(new SelectListItem {
Text = c.Name, Value = c.Id.ToString()
});
}
model.Address.AvailableStates.Add(new SelectListItem {
Text = _localizationService.GetResource("Admin.Address.OtherNonUS"), Value = "0"
});
model.Address.CountryEnabled = true;
model.Address.CountryRequired = true;
model.Address.StateProvinceEnabled = true;
model.Address.CityEnabled = true;
model.Address.StreetAddressEnabled = true;
model.Address.ZipPostalCodeEnabled = true;
model.Address.ZipPostalCodeRequired = true;
model.Address.PhoneEnabled = true;
return(View(model));
}
public ActionResult Warehouses(GridCommand command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
{
return(AccessDeniedView());
}
var warehousesModel = _shippingService.GetAllWarehouses()
.Select(x =>
{
var warehouseModel = new WarehouseModel()
{
Id = x.Id,
Name = x.Name
//ignore address for list view (performance optimization)
};
return(warehouseModel);
})
.ForCommand(command)
.ToList();
var model = new GridModel <WarehouseModel>
{
Data = warehousesModel,
Total = warehousesModel.Count
};
return(new JsonResult
{
Data = model
});
}
public virtual IActionResult CreateWarehouse(WarehouseModel model, bool continueEditing)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
{
return(AccessDeniedView());
}
if (ModelState.IsValid)
{
var address = model.Address.ToEntity();
address.CreatedOnUtc = DateTime.UtcNow;
_addressService.InsertAddress(address);
var warehouse = new Warehouse
{
Name = model.Name,
AdminComment = model.AdminComment,
AddressId = address.Id
};
_shippingService.InsertWarehouse(warehouse);
//activity log
_customerActivityService.InsertActivity("AddNewWarehouse", _localizationService.GetResource("ActivityLog.AddNewWarehouse"), warehouse.Id);
SuccessNotification(_localizationService.GetResource("Admin.Configuration.Shipping.Warehouses.Added"));
return(continueEditing ? RedirectToAction("EditWarehouse", new { id = warehouse.Id }) : RedirectToAction("Warehouses"));
}
//If we got this far, something failed, redisplay form
//countries
model.Address.AvailableCountries.Add(new SelectListItem {
Text = _localizationService.GetResource("Admin.Address.SelectCountry"), Value = "0"
});
foreach (var c in _countryService.GetAllCountries(showHidden: true))
{
model.Address.AvailableCountries.Add(new SelectListItem {
Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.Address.CountryId)
});
}
//states
var states = model.Address.CountryId.HasValue ? _stateProvinceService.GetStateProvincesByCountryId(model.Address.CountryId.Value, showHidden: true).ToList() : new List <StateProvince>();
if (states.Any())
{
foreach (var s in states)
{
model.Address.AvailableStates.Add(new SelectListItem {
Text = s.Name, Value = s.Id.ToString(), Selected = (s.Id == model.Address.StateProvinceId)
});
}
}
else
{
model.Address.AvailableStates.Add(new SelectListItem {
Text = _localizationService.GetResource("Admin.Address.OtherNonUS"), Value = "0"
});
}
return(View(model));
}
protected virtual void UpdateLocales(Warehouse warehouse, WarehouseModel model)
{
foreach (var localized in model.Locales)
{
_localizedEntityService.SaveLocalizedValue(warehouse,
x => x.Name,
localized.Name,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(warehouse,
x => x.WorkTime,
localized.WorkTime,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(warehouse,
x => x.WarehouseDescription,
localized.WarehouseDescription,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(warehouse,
x => x.City,
localized.City,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(warehouse,
x => x.StreetAddress,
localized.StreetAddress,
localized.LanguageId);
_localizedEntityService.SaveLocalizedValue(warehouse,
x => x.Phone,
localized.Phone,
localized.LanguageId);
}
}
public virtual IActionResult Warehouses(DataSourceRequest command)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
{
return(AccessDeniedKendoGridJson());
}
var warehousesModel = _shippingService.GetAllWarehouses()
.Select(x =>
{
var warehouseModel = new WarehouseModel
{
Id = x.Id,
Name = x.Name
//ignore address for list view (performance optimization)
};
return(warehouseModel);
})
.ToList();
var gridModel = new DataSourceResult
{
Data = warehousesModel,
Total = warehousesModel.Count
};
return(Json(gridModel));
}
public async Task <ActionResult> Add([FromBody] WarehouseModel _model)
{
string link = URI_API.WAREHOUSE_ADD;
ResponseConsult <int> response = await PostAsJsonAsync <int>(link, _model);
return(Ok(response));
}
public async Task <ActionResult> Modify(int _warehouseId, [FromBody] WarehouseModel _model)
{
string link = URI_API.WAREHOUSE_MODIFY.Replace("{id}", $"{_warehouseId}");
ResponseConsult <bool> response = await PutAsJsonAsync <bool>(link, _model);
return(Ok(response));
}
public async Task <bool> UpdateCustomer(Customer customer)
{
try
{
using (var context = new WarehouseModel())
{
var existingCustomer = context.Customers.FirstOrDefault(x => x.Id == customer.Id);
if (existingCustomer != null)
{
existingCustomer.Name = customer.Name;
existingCustomer.Address = customer.Address;
existingCustomer.City = customer.City;
await context.SaveChangesAsync();
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
return(true);
}
public async Task <bool> AddCustomer(Customer customer)
{
try
{
using (var context = new WarehouseModel())
{
var existingCustomer = context.Customers.FirstOrDefault(x => x.Name == customer.Name);
if (existingCustomer == null)
{
context.Customers.Add(customer);
await context.SaveChangesAsync();
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
return(true);
}
public virtual async Task <IActionResult> CreateWarehouse(WarehouseModel model, bool continueEditing)
{
if (!await _permissionService.AuthorizeAsync(StandardPermissionProvider.ManageShippingSettings))
{
return(AccessDeniedView());
}
if (ModelState.IsValid)
{
var address = model.Address.ToEntity <Address>();
address.CreatedOnUtc = DateTime.UtcNow;
await _addressService.InsertAddressAsync(address);
//fill entity from model
var warehouse = model.ToEntity <Warehouse>();
warehouse.AddressId = address.Id;
await _shippingService.InsertWarehouseAsync(warehouse);
//activity log
await _customerActivityService.InsertActivityAsync("AddNewWarehouse",
string.Format(await _localizationService.GetResourceAsync("ActivityLog.AddNewWarehouse"), warehouse.Id), warehouse);
_notificationService.SuccessNotification(await _localizationService.GetResourceAsync("Admin.Configuration.Shipping.Warehouses.Added"));
return(continueEditing ? RedirectToAction("EditWarehouse", new { id = warehouse.Id }) : RedirectToAction("Warehouses"));
}
//prepare model
model = await _shippingModelFactory.PrepareWarehouseModelAsync(model, null, true);
//if we got this far, something failed, redisplay form
return(View(model));
}
public bool AddWarehouseRoot(WarehouseModel warehouse)
{
try
{
// bool isOK = true;
if (ValidateWarehouseModel(warehouse))
{
var mapped = Mapper.Map <WarehouseModel, WarehouseDTO>(warehouse);
_warehouseRepository.Create(mapped);
return(true);
/* foreach (WarehouseModel wh in warehouse.NextHops)
* {
* wh.Parent = warehouse;
* isOK = isOK && AddWarehouseRecursive(wh);
* }
*
* var warehouseDAO = Mapper.Map<WarehouseModel, WarehouseDAO>(warehouse);
* _warehouseRepository.Create(warehouseDAO);
* _logger.Info("WarehouseRoot added: " + warehouseDAO.Code);
* return isOK;*/
}
return(false);
}
catch (Exception ex)
{
throw new BLException("Error setting up warehouses", ex);
}
}
private void partNameText_TextChanged(object sender, TextChangedEventArgs e)
{
selectedPart = warehouse.Find(x => x.partName == partNameText.Text);
if (selectedPart != null)
{
idPartsText.Text = selectedPart.idParts.ToString();
}
}
public async Task <IActionResult> CreateWarehouse()
{
var model = new WarehouseModel();
await PrepareAddressWarehouseModel(model);
return(View(model));
}
