public ResultDto Add(WareDto dto)
{
try
{
Ware ware = new Ware()
{
Name = dto.Name,
Image = dto.Image,
Price = dto.Price,
Description = dto.Description
};
_context.Wares.Add(ware);
_context.SaveChangesAsync();
return(new ResultDto
{
IsSuccessful = true,
Message = "Succesfully created"
});
}
catch (Exception ex)
{
return(new ResultDto
{
IsSuccessful = false,
Message = "Error"
});
}
}
private void Btn_add_ware_Click(object sender, EventArgs e)
{
Ware ware = new Ware();
ware.warecode = txtwarecode.Text;
ware.warename = txtwarename.Text;
ware.enable = checkBox1.Checked;
ware.rowcount = Convert.ToInt32(txtrowcount.Text);
ware.columncount = Convert.ToInt32(txtcolumncount.Text);
ware.layercount = Convert.ToInt32(txtlayercount.Text);
WareManage.AddWare(ware);
for (int i = 1; i <= ware.rowcount; i++)
{
for (int j = 1; j <= ware.columncount; j++)
{
for (int k = 1; k <= ware.layercount; k++)
{
Point point = new Point();
point.pointcode = ware.warecode + "_" + i.ToString("00") + j.ToString("00") + k.ToString("00");
point.areacode = "";
point.pointstate = "";
point.warecode = ware.warecode;
PointManage.AddPoint(point);
}
}
}
MessageBox.Show("添加成功!");
Close();
}
public ResultDto Edit([FromBody] WareDto dto)
{
try
{
Ware w = _context.Wares.First(x => x.Id == dto.Id);
w.Name = dto.Name;
w.Image = dto.Image;
w.Price = dto.Price;
w.Description = dto.Description;
_context.SaveChanges();
return(new ResultDto
{
IsSuccessful = true,
Message = "Successfully created"
});
}
catch (Exception)
{
return(new ResultDto
{
IsSuccessful = false,
Message = "Something goes wrong!"
});
throw;
}
}
public void ShouldCreateWareBooking()
{
var now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.AddDays(1).Day, 10, 0, 0, 0);
var input = new CreateWareBookingInput(0, 0, now, now.Date.AddHours(1));
var domain = new WareBooking(0, 0, now, now.AddHours(1));
var mockWareBookingRepo = new Mock <IWareBookingRepository>();
mockWareBookingRepo.Setup(m => m.GetStartingAt(now.Date)).Returns(new List <WareBooking>());
mockWareBookingRepo.Setup(m => m.Create(domain)).Returns(0);
var ware = new Ware("test", "test", "e1234fjdgq84324", 0, false);
var mockWareRepo = new Mock <IWareRepository>();
mockWareRepo.Setup(m => m.GetById(0)).Returns(ware);
var mockTimeSlotRepo = new Mock <ITimeSlotRepository>();
mockTimeSlotRepo.Setup(m => m.GetAllOfPlace(0)).Returns(new List <TimeSlot> {
new TimeSlot(now.DayOfWeek, 8, 0, 20, 0, 0)
});
var res = new CreateWareBooking(mockWareBookingRepo.Object, mockTimeSlotRepo.Object, mockWareRepo.Object,
input).Execute();
Assert.AreEqual(0, res);
}
public int Create(Ware ware, Decimal TimeLimit, bool Active)
{
int result = 1;
IEnumerable <WareTimeLimit> timeLimitsExists = ware.WareTimeLimits.Where(a => a.Active == true & a.TimeLimit != TimeLimit);
if (timeLimitsExists != null)
{
if (timeLimitsExists.Count() > 0)
{
foreach (WareTimeLimit limit in timeLimitsExists)
{
if (limit.TimeLimit != TimeLimit)
{
limit.Active = false;
}
}
}
}
IEnumerable <WareTimeLimit> currentTimeLimitsExists = ware.WareTimeLimits.Where(a => a.Active == true & a.TimeLimit == TimeLimit);
if (currentTimeLimitsExists.Count() == 0)
{
WareTimeLimit sr = new WareTimeLimit();
sr.TimeLimit = TimeLimit;
sr.Active = Active;
ware.WareTimeLimits.Add(sr);
context.AddToWareTimeLimits(sr);
}
return(result);
}
public async Task <IActionResult> Bearbeiten(BearbeitenViewModel model)
{
if (ModelState.IsValid)
{
var userID = usernManager.GetUserId(HttpContext.User);
Ware ware = new Ware
{
Ware_Id = model.Ware_Id,
Ware_Beschreibung = model.Ware_Beschreibung_NEU,
Ware_Einlagerungsdatum = model.Ware_Einlagerungsdatum,
Lagerplatz_Id = model.Lagerplatz_NEU,
Menge = model.Menge_NEU,
Seriennr = model.Seriennummer_NEU,
Modellnummer = model.Modellnummer_NEU,
Kategorie_Name = model.Kategorie_NEU,
Anschaff_Kosten = model.Anschaffungskosten_NEU,
Lieferant_Id = model.Lieferant_NEU,
Kostenstelle_Nr = model.Kostenstelle_NEU,
Hersteller_Id = model.Hersteller_NEU,
Auftragsnummer = model.Auftragsnummer_NEU,
};
_context.Ware.Update(ware);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", new { id = model.Ware_Id }));
}
return(View(model));
}
public ActionResult Sell(SellPlayerPartModel bindModel)
{
var username = this.User.Identity.Name;
var playerPart = this.partsService.GetPlayerPartByPartId(username, bindModel.PartId);
if (playerPart == null)
{
this.TempData["Error"] = "Part not found!";
return(RedirectToAction(nameof(Inventory)));
}
mapper.Map <Part, SellPlayerPartModel>(playerPart.Part, bindModel);
if (!ModelState.IsValid)
{
return(View(bindModel));
}
var ware = new Ware()
{
PlayerPartId = playerPart.Id,
ListedOn = DateTime.UtcNow,
Price = (decimal)bindModel.Price,
};
this.waresService.AddWare(ware);
this.playersService.SetPartForSale(playerPart.Id);
return(RedirectToAction(nameof(Inventory)));
}
public WareDocumentDetail CreateWithNoSave(int WareID, decimal UnitQuantity, decimal?SecondaryUnitQuantity,
decimal PriceForUnit, decimal?DiscountForUnit,
decimal?EndPriceForUnit, decimal EndPrice, int CurrencyID, int PriceGroupID)
{
int userId = Compas.Logic.Security.CurrentSecurityContext.Identity.ID;
WareDocumentDetail sr = new WareDocumentDetail();
//sr.WareID = WareID;
Wares.WaresLogic wares = new Wares.WaresLogic(manager);
Ware ware = wares.Get(WareID);
ware.WareDocumentDetails.Add(sr);
//sr.WareID = WareID;
sr.UnitQuantity = UnitQuantity;
if (SecondaryUnitQuantity != null)
{
sr.SecondaryUnitQuantity = Convert.ToDecimal(SecondaryUnitQuantity);
}
sr.DiscountForUnit = DiscountForUnit;
sr.CurrencyID = CurrencyID;
sr.EndPrice = EndPrice;
sr.EndPriceForUnit = EndPriceForUnit;
sr.PriceForUnit = PriceForUnit;
return(sr);
}
public override void Setup(Ware ware, BasicChar buyer)
{
if (ware is BuyMeal meal)
{
this.meal = meal;
this.buyer = buyer;
Cost = meal.Cost;
SetTexts(meal.Title, meal.Desc, meal.Cost.ToString());
BuyBtn.onClick.AddListener(Buy);
FrameCanAfford();
buyer.Currency.GoldChanged += FrameCanAfford;
if (meal.Img != null)
{
icon.sprite = meal.Img;
}
else
{
icon.gameObject.SetActive(false);
}
}
else
{
Destroy(gameObject);
}
}
public ActionResult Sell(int partId)
{
var player = this.playersService.GetPlayerByUsername("OfficialStore");
var part = this.partsService.GetPartById(partId);
if (part == null)
{
this.TempData["Error"] = "Part not found!";
return(RedirectToAction(nameof(Menu)));
}
var playerPart = player.Inventory.FirstOrDefault(x => x.PartId == partId);
if (!playerPart.IsForSale)
{
this.playersService.SetPartForSale(playerPart.Id);
var ware = new Ware()
{
PlayerPart = playerPart,
ListedOn = DateTime.UtcNow,
Price = part.BasePrice,
};
this.waresService.AddWare(ware);
}
return(RedirectToAction("Index", "Store"));
}
private void FillFields()
{
_unitQuantity = detail.UnitQuantity;
_secondaryUnitQuantity = detail.SecondaryUnitQuantity;
_priceForUnit = detail.PriceForUnit;
_endPriceForUnit = detail.EndPriceForUnit;
_endPrice = detail.EndPrice;
_currencyName = (detail.WareDocument == null ? "" : detail.WareDocument.Currency.Name);
if (detail.Ware != null)
{
_wareName = detail.Ware.Name;
_unitName = detail.Ware.WareUnit == null ? "" : detail.Ware.WareUnit.Name;
_secondaryUnitName = detail.Ware.WareUnit1 == null ? "" : detail.Ware.WareUnit1.Name;
_unit = _unitQuantity + " " + (detail.Ware.WareUnit == null ? "" : detail.Ware.WareUnit.Name);
_secondaryUnit = detail.SecondaryUnitQuantity.ToString() + " " + (detail.Ware.WareUnit1 == null ? "" : detail.Ware.WareUnit1.Name);
}
else
{
WaresLogic waresLogic = new WaresLogic(manager);
Ware ware = waresLogic.Get(detail.WareID);
if (ware != null)
{
_wareName = ware.Name;
}
}
}
public void RemoveWareById_ShouldRemoveCorrectWare()
{
var options = GetDbOptions("RemoveWareById_Database");
var dummyWare1 = new Ware() { Id = 12 };
var dummyWare2 = new Ware() { Id = 23 };
using (var context = new RiderDBContext(options))
{
context.Wares.Add(dummyWare1);
context.Wares.Add(dummyWare2);
context.SaveChanges();
}
List<Ware> actual;
using (var context = new RiderDBContext(options))
{
var waresService = new WaresService(context);
waresService.RemoveWareById(23);
actual = context.Wares.ToList();
}
Assert.Single(actual);
Assert.Contains(actual, x => x.Id == 12);
Assert.DoesNotContain(actual, x => x.Id == 23);
}
/// <summary>
/// Додавання позицій в документ по коду одиниці
/// </summary>
/// <param name="WareCode"></param>
/// <returns></returns>
private WareDocumentDetail AddDocumenDetailByWareCode(string WareCode)
{
DocumentDetailsLogic details = new DocumentDetailsLogic(manager);
WareCodesLogic wareCodesLogic = new WareCodesLogic(manager);
WareDocumentDetail result = null;
Ware ware = wareCodesLogic.GetWareByCode(WareCode);
if (ware != null)
{
int wareId = ware.ID;
decimal unitQuantity = 1;
decimal secondaryUnitQuantity = 0;
decimal priceForUnit = 0;
decimal discountForUnit = 0;
decimal endSalePriceForUnit = 0;
decimal endPrice = 0;
int currencyId = Convert.ToInt32(CurrencyLUE.EditValue);
int priceGroupID = 1;
WareDocumentDetail DocumentDetail = new WareDocumentDetail();
//створюємо новий запис в деталізації документа і повертаємо його
DocumentDetail = details.CreateWithNoSave(wareId, unitQuantity, secondaryUnitQuantity,
priceForUnit, discountForUnit, endSalePriceForUnit, endPrice, currencyId, priceGroupID);
documentDetailsView.Add(DocumentDetail);
result = DocumentDetail;
FillDetails();
}
else
{
MessageBox.Show("Товар з даним кодом не знайдено");
}
return(result);
}
//public ActionResult List(string category, int page = 1)
//{
// WaresListViewModel model = new WaresListViewModel
// {
// Wares = repos.Wares
// .Where(p => category == null || p.Category == category)
// .OrderBy(game => game.ID)
// .Skip((page - 1) * pageSize)
// .Take(pageSize),
// PagingInfo = new PagingInfo
// {
// CurrentPage = page,
// ItemsPerPage = pageSize,
// TotalItems = category == null ?
//repos.Wares.Count() :
//repos.Wares.Where(game => game.Category == category).Count()
// },
// CurrentCategory = category
// };
// return View(model);
//}
public ViewResult EditWare(int Id)
{
Ware ware = repos.Wares
.FirstOrDefault(g => g.ID == Id);
return(View(ware));
}
public Ware AddWare(Ware ware)
{
this.context.Wares.Add(ware);
this.context.SaveChanges();
return(ware);
}
public async Task <ActionResult <Ware> > PostWare(Ware ware)
{
_context.Wares.Add(ware);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetWare", new { id = ware.Id }, ware));
}
public void GetWareById_ShouldReturnCorrectWare()
{
var options = GetDbOptions("GetWareById_Database");
var dummyPlayer = new Player();
var dummyPart = new Part();
var dummyPlayerPart = new PlayerParts() { Player = dummyPlayer, Part = dummyPart };
var dummyWare1 = new Ware() { PlayerPart = dummyPlayerPart };
var dummyWare2 = new Ware() { PlayerPart = dummyPlayerPart };
using (var context = new RiderDBContext(options))
{
context.Wares.Add(dummyWare1);
context.Wares.Add(dummyWare2);
context.SaveChanges();
}
Ware actual;
using (var context = new RiderDBContext(options))
{
var waresService = new WaresService(context);
actual = waresService.GetWareById(dummyWare1.Id);
}
Assert.Equal(dummyWare1.Id, actual.Id);
}
// POST: Waren/Delete/5
public ActionResult Delete(Guid id)
{
Ware ware = _db.Waren.Find(id);
if (ware == null)
{
return(HttpNotFound());
}
var lagerWarenIdList = ware.LagerWaren.Select(x => x.LagerWarenID).ToList();
foreach (var guid in lagerWarenIdList)
{
var lagerWare = _db.LagerWaren.Find(guid);
if (lagerWare != null)
{
_db.LagerWaren.Remove(lagerWare);
}
}
_db.Waren.Remove(ware);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> PutWare(int id, Ware ware)
{
if (id != ware.Id)
{
return(BadRequest());
}
_context.Entry(ware).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!WareExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void GetLatestWare_ShouldReturnLastWareByListedOn()
{
var options = GetDbOptions("GetLatestWare_Database");
var dummyPlayer = new Player();
var dummyPart = new Part();
var dummyPlayerPart = new PlayerParts() { Player = dummyPlayer, Part = dummyPart };
var dummyWare1 = new Ware() { PlayerPart = dummyPlayerPart, ListedOn = DateTime.UtcNow };
var dummyWare2 = new Ware() { PlayerPart = dummyPlayerPart, ListedOn = DateTime.UtcNow };
using (var context = new RiderDBContext(options))
{
context.Wares.Add(dummyWare2);
context.Wares.Add(dummyWare1);
context.SaveChanges();
}
Ware actual;
using (var context = new RiderDBContext(options))
{
var waresService = new WaresService(context);
actual = waresService.GetLatestWare();
}
Assert.Equal(dummyWare2.Id, actual.Id);
}
/// <inheritdoc />
public Ware Add(Ware ware)
{
var id = _db.Wares.Last().Id + 1;
var wareTest = new WareTest(id, ware);
_db.Wares.Add(wareTest);
return(wareTest);
}
/// <summary>
/// Take specific ware from store
/// </summary>
/// <param name="ware">Specific ware in store</param>
/// <returns>Founded and removed ware or null</returns>
public Ware Take(Ware ware)
{
CheckExpires();
var entity = _repo.Remove(ware);
WareTaked(ware);
return(entity);
}
public long Create(Ware ware)
{
var id = Wares.Count;
ware.Id = id;
Wares.Add(ware);
return(id);
}
public WareDetailVm(Page view, Ware openWare)
{
this.view = view;
Ware = openWare;
Items = new ObservableCollection <Ware>
{
openWare
};
}
public async Task <IActionResult> Buchen(BuchenViewModel model)
{
if (string.IsNullOrEmpty(model.Seriennr))
{
model.Seriennr = "0";
}
else
{
model.Menge = 1;
}
if (string.IsNullOrEmpty(model.Modellnummer))
{
model.Modellnummer = "0";
}
if (ModelState.IsValid)
{
var userID = usernManager.GetUserId(HttpContext.User);
Ware ware = new Ware
{
Ware_Beschreibung = model.Ware_Beschreibung,
Ware_Einlagerungsdatum = DateTime.Today,
Lagerplatz_Id = model.Lagerplatz_Id,
Menge = model.Menge,
User_id = userID,
Seriennr = model.Seriennr,
Modellnummer = model.Modellnummer,
Kategorie_Name = model.Kategorie_Name,
Lieferant_Id = model.Lieferant_Id,
Hersteller_Id = model.Hersteller_Id,
Kostenstelle_Nr = model.Kostenstelle_Id,
Anschaff_Kosten = model.Anschaff_Kosten,
Auftragsnummer = model.Auftragsnummer
};
_context.Ware.Add(ware);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
model.Lagerplatz = _context.Lagerplatz.OrderBy(i => i.Lagerplatz_Beschreibung).ToList();
var ware1 = _context.Ware;
foreach (var i in ware1)
{
model.Lagerplatz.RemoveAll(s => s.Lagerplatz_Id == i.Lagerplatz_Id);
}
model.Kategorie = _context.Kategorie.ToList();
model.Kategorie = _context.Kategorie.ToList();
model.Hersteller = _context.Hersteller.ToList();
model.Kostenstelle = _context.Kostenstelle.ToList();
model.Lieferant = _context.Lieferant.ToList();
return(View(model));
}
/// <inheritdoc />
public Ware Remove(Ware ware)
{
if (ware != null && Exists(ware.Id))
{
_db.Wares.Remove(ware);
_db.SaveChanges();
}
return(ware);
}
/// <summary>
/// Add new ware in store
/// </summary>
/// <param name="ware">Ware</param>
/// <returns>Added ware</returns>
public Ware Store(WareValue ware)
{
var entity = new Ware(ware);
entity = _repo.Add(entity);
WareStored(entity);
CheckExpires();
return(entity);
}
public IActionResult Update([FromBody] Ware ware)
{
var res = new UpdateWare(repository, ware).Execute();
if (res == -1)
{
return(Conflict());
}
return(Ok(res));
}
public RedirectToRouteResult AddToCart(Cart cart, int Id, string returnUrl)
{
Ware ware = repos.Wares
.FirstOrDefault(g => g.ID == Id);
if (ware != null)
{
cart.AddItem(ware, 1);
}
return(RedirectToAction("Index", new { returnUrl }));
}
public ActionResult DeleteWare(int Id)
{
Ware deletedWare = repos.DeleteWare(Id);
if (deletedWare != null)
{
TempData["message"] = string.Format("Товар \"{0}\" був видалений",
deletedWare.Name);
}
return(RedirectToAction("Index"));
}
bool erstelleWarenBewegung(Ware ware, Warenbewegung bewegung)
{
}
private int insertWareIntoDb(Ware ware)
{
SqlCommand cmd = new SqlCommand("INSERT INTO wares(description,weightPerPallet,nrOfPallets) VALUES (@description,@weightPerPallet,@nrOfPallets)", Database.sqlCon);
try
{
cmd.Parameters.Add("@description", SqlDbType.Text).Value = ware.Description;
cmd.Parameters.Add("weightPerPallet", SqlDbType.Int).Value = ware.WeightPerPallet;
cmd.Parameters.Add("@nrOfPallets", SqlDbType.Int).Value = ware.NrOfPallets;
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
//now it needs to get back the wareId
SqlCommand command = new SqlCommand("SELECT IDENT_CURRENT('wares')", Database.sqlCon);
ware.WareId=Convert.ToInt32(command.ExecuteScalar());
return ware.WareId;
}
bool loescheWare(Ware ware)
{
}
public Ware makeNewWare(string description, int weightPerPallet, int nrOfPallets)
{
Ware ware = new Ware();
ware.Description = description;
ware.WeightPerPallet = weightPerPallet;
ware.NrOfPallets = nrOfPallets;
return ware;
}
bool aktualisiereWare(Ware ware)
{
}
public int getPrice(Ware ware)
{
Database.sqlCon.Open();
int price = 0;
//selecting the right price
SqlCommand command = new SqlCommand("SELECT price FROM prices WHERE kgPerPalletFrom<=" + ware.WeightPerPallet + " AND kgPerPalletTo> " + ware.WeightPerPallet, Database.sqlCon);
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
price = dataReader.GetInt32(0);
}
}
Database.sqlCon.Close();
return price;
}
bool erstelleWare(Ware ware)
{
}
