public string CreateNewBorrow(BorrowModel borrow)
{
var query = $"insert into {tableBorrorws} (Verleiher, Ausleiher, Ausleihdatum, Verfügbarkeitsdatum, Item) " +
$"values ('{ borrow.Distributor}', '{borrow.Borrower}', '{borrow.BorrowDate}', '{borrow.Availability}', '{borrow.ItemId}')";
return(DoManipulateQuery(query));
}
public async Task <IActionResult> Edit(int id, [Bind("BorrowOrderID,TranName,AccountName,StartTime,TranTime,FinishTime,IsCanceled,IsCompleted,IsTraned,OrderMoney,BorrowNote,ItemNum1,ItemNum2,ItemNum3,ItemNum4,ItemNum5,ItemNum6,ItemNum7,ItemNum8,ItemNum9,ItemNum10,ItemNum11,ItemNum12,ItemNum13,ItemNum14,ItemNum15,ItemNum16,ItemNum17,ItemNum18,ItemNum19,ItemNum20,ItemNum21,ItemNum22,ItemNum23,ItemNum24,ItemNum25,ItemNum26,ItemNum27,ItemNum28,ItemNum29,ItemNum30,ItemNum31,ItemNum32,ItemNum33,ItemNum34,ItemNum35,ItemNum36,ItemNum37,ItemNum38,ItemNum39,ItemNum40")] BorrowModel borrowModel)
{
if (id != borrowModel.BorrowOrderID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(borrowModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BorrowModelExists(borrowModel.BorrowOrderID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("OrderPool", "Home"));
}
ViewData["AccountName"] = new SelectList(_context.AccountModels.Where(x => x.Type == Models.EnumClass.EnumAccountType.配送专员), "AccountName", "AccountName", borrowModel.AccountName);
return(View(borrowModel));
}
public string ChangeBorrowInDb(BorrowModel newBorrow)
{
var query = $"update {tableBorrorws} set Verleiher='{newBorrow.Distributor}', Ausleiher='{newBorrow.Borrower}', Ausleihdatum='{newBorrow.BorrowDate}'," +
$" Verfügbarkeitsdatum='{newBorrow.Availability}', Item={newBorrow.ItemId} where AusleihId={newBorrow.Id}";
return(DoManipulateQuery(query));
}
public void OnPost()
{
var id = Convert.ToUInt32(Request.Query["id"][0]);
Borrow = MainMethods.GetBorrow(id);
Item = MainMethods.GetItem(Borrow.ItemId);
var newDistributor = Distributor != Borrow.Distributor && Distributor.Length > 0 ? Distributor : Borrow.Distributor;
var newBorrower = Borrower != Borrow.Borrower && Borrower.Length > 0 ? Borrower : Borrow.Borrower;
var newBorrowDate = BorrowDate != Borrow.BorrowDate && BorrowDate.Length > 0 ? BorrowDate : Borrow.BorrowDate;
var newAvailability = Availability != Borrow.Availability && Availability.Length > 0 ? Availability : Borrow.Availability;
var newItemId = Borrow.ItemId;
var newBorrow = new BorrowModel(Borrow.Id, newDistributor, newBorrower, newBorrowDate, newAvailability, newItemId);
if (MainMethods.ItemCanBeBorrowInThisPeriod(Borrow.ItemId, newBorrowDate, newAvailability))
{
var res = DbConn.ChangeBorrowInDb(newBorrow);
if (res == "Success")
{
Response.Redirect("/Borrow/Index?status=1");
}
else
{
Response.Redirect("/Borrow/Index?status=3");
}
}
else
{
Response.Redirect("/Borrow/Index?status=7");
}
}
private void Button_Borrow_Del_Click(object sender, RoutedEventArgs e)
{
if (dg_borrows.SelectedIndex > -1)
{
BorrowModel b = (dg_borrows.SelectedItem as BorrowModel);
if (b.BringBackDate < DateTime.Now)
{
double betrag = Convert.ToInt32((DateTime.Now - b.BringBackDate).TotalDays) * Config.GetMovieById(b.Movie).Price;
int cst = Config.Cinema.Customers.IndexOf(Config.GetCustomerById(b.Customer));
Config.Cinema.Customers[cst].Credit -= betrag;
Config.Cinema.Customers[cst].Update();
dg_customers.Items.Refresh();
MessageBox.Show("Der Film wurde zu spät abgegeben! Der Betrag von " + betrag + " € wurde zusätzlich vom Konto des Kunden abgezogen!", "Info", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
if (b.Remove())
{
Config.Cinema.Borrows.Remove(b);
}
else
{
MessageBox.Show("Fehler auf Seiten der Dantenbank!");
}
}
else
{
MessageBox.Show("Wählen Sie etwas aus!");
}
LoadBorrows();
}
public ActionResult DeleteConfirmed(int id)
{
BorrowModel borrowModel = db.BorrowModels.Find(id);
db.BorrowModels.Remove(borrowModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Description,Quantity,DateRequire,DateReturn,DateComplete,IdUserRequest,IdUserLending")] BorrowModel borrowModel)
{
if (ModelState.IsValid)
{
db.Entry(borrowModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(borrowModel));
}
private void SelectBorrowItem(object sender, DataGridViewCellEventArgs e)
{
int row = e.RowIndex; //which row did i click on in the list
if (row > -1) //-1 for clicking column names
{
List <BorrowModel> borrow = (List <BorrowModel>)borrowDataGridView.DataSource;
selectedBorrowItem = borrow.ElementAt <BorrowModel>(row);
}
}
public BorrowModel GetBorrow(uint id)
{
var resList = DbConn.GetBorrow(id);
var paraList = (List <object>)resList[1];
var borrow = new BorrowModel();
if (paraList.Count > 0)
{
borrow = new BorrowModel(Convert.ToUInt32(paraList[0]), paraList[1].ToString(), paraList[2].ToString(), ConvertDateTime(paraList[3].ToString()), ConvertDateTime(paraList[4].ToString()), Convert.ToUInt32(paraList[5]));
}
return(borrow);
}
private bool BorrowCheckZero(BorrowModel borrowModel)
{
return(borrowModel.ItemNum1 == 0 && borrowModel.ItemNum2 == 0 && borrowModel.ItemNum3 == 0 && borrowModel.ItemNum4 == 0 &&
borrowModel.ItemNum5 == 0 && borrowModel.ItemNum6 == 0 && borrowModel.ItemNum7 == 0 && borrowModel.ItemNum8 == 0 &&
borrowModel.ItemNum9 == 0 && borrowModel.ItemNum10 == 0 && borrowModel.ItemNum11 == 0 && borrowModel.ItemNum12 == 0 &&
borrowModel.ItemNum13 == 0 && borrowModel.ItemNum14 == 0 && borrowModel.ItemNum15 == 0 && borrowModel.ItemNum16 == 0 &&
borrowModel.ItemNum17 == 0 && borrowModel.ItemNum18 == 0 && borrowModel.ItemNum19 == 0 && borrowModel.ItemNum20 == 0 &&
borrowModel.ItemNum21 == 0 && borrowModel.ItemNum22 == 0 && borrowModel.ItemNum23 == 0 && borrowModel.ItemNum24 == 0 &&
borrowModel.ItemNum25 == 0 && borrowModel.ItemNum26 == 0 && borrowModel.ItemNum27 == 0 && borrowModel.ItemNum28 == 0 &&
borrowModel.ItemNum29 == 0 && borrowModel.ItemNum30 == 0 && borrowModel.ItemNum31 == 0 && borrowModel.ItemNum32 == 0 &&
borrowModel.ItemNum33 == 0 && borrowModel.ItemNum34 == 0 && borrowModel.ItemNum35 == 0 && borrowModel.ItemNum36 == 0 &&
borrowModel.ItemNum37 == 0 && borrowModel.ItemNum38 == 0 && borrowModel.ItemNum39 == 0 && borrowModel.ItemNum40 == 0);
}
public ActionResult Create([Bind(Include = "ID,Description,Quantity,DateRequire,DateReturn,DateComplete,IdUserRequest,IdUserLending")] BorrowModel borrowModel)
{
if (ModelState.IsValid)
{
borrowModel.DateRequire = DateTime.Now;
borrowModel.UserRequest = db.Users.Find(User.Identity.GetUserId());
db.BorrowModels.Add(borrowModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(borrowModel));
}
//BORROW GRID VIEW
private void borrowGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
int row = e.RowIndex; //get which row was selected
//if user clicks column headers, row = -1, so ignore
if (row >= 0)
{
//cast dataSource from object back into what we put it in as
List <BorrowModel> medias = (List <BorrowModel>)borrowGridView.DataSource;
//get the individual media selected
media3 = medias[row];
}
}
// GET: Borrow/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BorrowModel borrowModel = db.BorrowModels.Find(id);
if (borrowModel == null)
{
return(HttpNotFound());
}
return(View(borrowModel));
}
public BorrowModel GetBorrowsByUserId(string id)
{
BorrowModel borrows = new BorrowModel();
List <Borrow> raw_borrows = repositoryWrapper.BorrowRepository.FindByCondition(b => b.UserId == id).ToList();
foreach (Borrow raw_borrow in raw_borrows)
{
BorrowModel.pair borrow = new BorrowModel.pair();
borrow.Title = _bookService.GetBooksByCondition(b => b.BookId == raw_borrow.BookId).First().Title;
borrow.Location = _branchService.GetBranchByCondition(b => b.BranchId == raw_borrow.BranchId).First().Location;
borrow.Library_Name = _branchService.GetBranchByCondition(b => b.BranchId == raw_borrow.BranchId).First().Name;
borrows.borrows.Add(borrow);
}
return(borrows);
}
//按照物品名字计算
private async Task <double> ComputeTempBalance(BorrowModel borrowModel)
{
var item = _context.ItemModels;
return(borrowModel.ItemNum1 * (await item.FindAsync("床单 1.2M")).ItemValue
+ borrowModel.ItemNum2 * (await item.FindAsync("床单 1.5M")).ItemValue
+ borrowModel.ItemNum3 * (await item.FindAsync("床单 1.8M")).ItemValue
+ borrowModel.ItemNum4 * (await item.FindAsync("被套 1.2M")).ItemValue
+ borrowModel.ItemNum5 * (await item.FindAsync("被套 1.5M")).ItemValue
+ borrowModel.ItemNum6 * (await item.FindAsync("被套 1.8M")).ItemValue
+ borrowModel.ItemNum7 * (await item.FindAsync("枕套")).ItemValue
+ borrowModel.ItemNum8 * (await item.FindAsync("浴巾")).ItemValue
+ borrowModel.ItemNum9 * (await item.FindAsync("地巾")).ItemValue
+ borrowModel.ItemNum10 * (await item.FindAsync("毛巾")).ItemValue
+ borrowModel.ItemNum11 * (await item.FindAsync("方巾")).ItemValue
+ borrowModel.ItemNum12 * (await item.FindAsync("大台布")).ItemValue
+ borrowModel.ItemNum13 * (await item.FindAsync("香巾")).ItemValue
+ borrowModel.ItemNum14 * (await item.FindAsync("小台布")).ItemValue
+ borrowModel.ItemNum15 * (await item.FindAsync("口布")).ItemValue
+ borrowModel.ItemNum16 * (await item.FindAsync("毛毯")).ItemValue
+ borrowModel.ItemNum17 * (await item.FindAsync("桌围裙")).ItemValue
+ borrowModel.ItemNum18 * (await item.FindAsync("厨衣")).ItemValue
+ borrowModel.ItemNum19 * (await item.FindAsync("窗帘")).ItemValue
+ borrowModel.ItemNum20 * (await item.FindAsync("窗帘内胆")).ItemValue
+ borrowModel.ItemNum21 * (await item.FindAsync("浴帘")).ItemValue
+ borrowModel.ItemNum22 * (await item.FindAsync("浴服")).ItemValue
+ borrowModel.ItemNum23 * (await item.FindAsync("椅套")).ItemValue
+ borrowModel.ItemNum24 * (await item.FindAsync("帽子")).ItemValue
+ borrowModel.ItemNum25 * (await item.FindAsync("床裙")).ItemValue
+ borrowModel.ItemNum26 * (await item.FindAsync("缎料工服")).ItemValue
+ borrowModel.ItemNum27 * (await item.FindAsync("唐装")).ItemValue
+ borrowModel.ItemNum28 * (await item.FindAsync("免烫工服")).ItemValue
+ borrowModel.ItemNum29 * (await item.FindAsync("旗袍")).ItemValue
+ borrowModel.ItemNum30 * (await item.FindAsync("西服")).ItemValue
+ borrowModel.ItemNum31 * (await item.FindAsync("领带")).ItemValue
+ borrowModel.ItemNum32 * (await item.FindAsync("已烫工服")).ItemValue
+ borrowModel.ItemNum33 * (await item.FindAsync("沙发套")).ItemValue
+ borrowModel.ItemNum34 * (await item.FindAsync("床罩")).ItemValue
+ borrowModel.ItemNum35 * (await item.FindAsync("抹布")).ItemValue
+ borrowModel.ItemNum36 * (await item.FindAsync("保护垫")).ItemValue
+ borrowModel.ItemNum37 * (await item.FindAsync("地毯清洗")).ItemValue
+ borrowModel.ItemNum38 * (await item.FindAsync("足浴窄床单")).ItemValue
+ borrowModel.ItemNum39 * (await item.FindAsync("预留1")).ItemValue
+ borrowModel.ItemNum40 * (await item.FindAsync("预留2")).ItemValue);
}
public BorrowModel MakeBorrowResult(SqlDataReader reader)
{
var model = new BorrowModel();
if (reader.ColumnExists(BorrowParameters.MemberId))
{
model.MemberID = reader[BorrowParameters.MemberId] is DBNull
? 0
: Convert.ToInt32(reader[BorrowParameters.MemberId], CultureInfo.CurrentCulture);
}
if (reader.ColumnExists(BorrowParameters.Member))
{
model.Member = reader[BorrowParameters.Member] is DBNull
? string.Empty
: reader[BorrowParameters.Member].ToString();
}
if (reader.ColumnExists(BorrowParameters.BookId))
{
model.BookID = reader[BorrowParameters.BookId] is DBNull
? 0
: Convert.ToInt32(reader[BorrowParameters.BookId], CultureInfo.CurrentCulture);
}
if (reader.ColumnExists(BorrowParameters.Title))
{
model.Title = reader[BorrowParameters.Title] is DBNull
? string.Empty
: reader[BorrowParameters.Title].ToString();
}
if (reader.ColumnExists(BorrowParameters.LendDate))
{
model.LendDate = reader[BorrowParameters.LendDate] is DBNull
? string.Empty
: reader[BorrowParameters.LendDate].ToString().Substring(0, 10);
}
if (reader.ColumnExists(BorrowParameters.LendedBy))
{
model.LendedBy = reader[BorrowParameters.LendedBy] is DBNull
? string.Empty
: reader[BorrowParameters.LendedBy].ToString();
}
return(model);
}
private void WareTopup(WarehouseModel ware, BorrowModel borrowModel)
{
//库存减少
ware.ItemNum1 += borrowModel.ItemNum1;
ware.ItemNum2 += borrowModel.ItemNum2;
ware.ItemNum3 += borrowModel.ItemNum3;
ware.ItemNum4 += borrowModel.ItemNum4;
ware.ItemNum5 += borrowModel.ItemNum5;
ware.ItemNum6 += borrowModel.ItemNum6;
ware.ItemNum7 += borrowModel.ItemNum7;
ware.ItemNum8 += borrowModel.ItemNum8;
ware.ItemNum9 += borrowModel.ItemNum9;
ware.ItemNum10 += borrowModel.ItemNum10;
ware.ItemNum11 += borrowModel.ItemNum11;
ware.ItemNum12 += borrowModel.ItemNum12;
ware.ItemNum13 += borrowModel.ItemNum13;
ware.ItemNum14 += borrowModel.ItemNum14;
ware.ItemNum15 += borrowModel.ItemNum15;
ware.ItemNum16 += borrowModel.ItemNum16;
ware.ItemNum17 += borrowModel.ItemNum17;
ware.ItemNum18 += borrowModel.ItemNum18;
ware.ItemNum19 += borrowModel.ItemNum19;
ware.ItemNum20 += borrowModel.ItemNum20;
//------------------------------------//
ware.ItemNum21 += borrowModel.ItemNum21;
ware.ItemNum22 += borrowModel.ItemNum22;
ware.ItemNum23 += borrowModel.ItemNum23;
ware.ItemNum24 += borrowModel.ItemNum24;
ware.ItemNum25 += borrowModel.ItemNum25;
ware.ItemNum26 += borrowModel.ItemNum26;
ware.ItemNum27 += borrowModel.ItemNum27;
ware.ItemNum28 += borrowModel.ItemNum28;
ware.ItemNum29 += borrowModel.ItemNum29;
ware.ItemNum30 += borrowModel.ItemNum30;
ware.ItemNum31 += borrowModel.ItemNum31;
ware.ItemNum32 += borrowModel.ItemNum32;
ware.ItemNum33 += borrowModel.ItemNum33;
ware.ItemNum34 += borrowModel.ItemNum34;
ware.ItemNum35 += borrowModel.ItemNum35;
ware.ItemNum36 += borrowModel.ItemNum36;
ware.ItemNum37 += borrowModel.ItemNum37;
ware.ItemNum38 += borrowModel.ItemNum38;
ware.ItemNum39 += borrowModel.ItemNum39;
ware.ItemNum40 += borrowModel.ItemNum40;
_context.Update(ware);
}
private void WareReduce(WarehouseModel ware, BorrowModel borrowModel)
{
//库存减少
ware.ItemNum1 -= borrowModel.ItemNum1;
ware.ItemNum2 -= borrowModel.ItemNum2;
ware.ItemNum3 -= borrowModel.ItemNum3;
ware.ItemNum4 -= borrowModel.ItemNum4;
ware.ItemNum5 -= borrowModel.ItemNum5;
ware.ItemNum6 -= borrowModel.ItemNum6;
ware.ItemNum7 -= borrowModel.ItemNum7;
ware.ItemNum8 -= borrowModel.ItemNum8;
ware.ItemNum9 -= borrowModel.ItemNum9;
ware.ItemNum10 -= borrowModel.ItemNum10;
ware.ItemNum11 -= borrowModel.ItemNum11;
ware.ItemNum12 -= borrowModel.ItemNum12;
ware.ItemNum13 -= borrowModel.ItemNum13;
ware.ItemNum14 -= borrowModel.ItemNum14;
ware.ItemNum15 -= borrowModel.ItemNum15;
ware.ItemNum16 -= borrowModel.ItemNum16;
ware.ItemNum17 -= borrowModel.ItemNum17;
ware.ItemNum18 -= borrowModel.ItemNum18;
ware.ItemNum19 -= borrowModel.ItemNum19;
ware.ItemNum20 -= borrowModel.ItemNum20;
//------------------------------------//
ware.ItemNum21 -= borrowModel.ItemNum21;
ware.ItemNum22 -= borrowModel.ItemNum22;
ware.ItemNum23 -= borrowModel.ItemNum23;
ware.ItemNum24 -= borrowModel.ItemNum24;
ware.ItemNum25 -= borrowModel.ItemNum25;
ware.ItemNum26 -= borrowModel.ItemNum26;
ware.ItemNum27 -= borrowModel.ItemNum27;
ware.ItemNum28 -= borrowModel.ItemNum28;
ware.ItemNum29 -= borrowModel.ItemNum29;
ware.ItemNum30 -= borrowModel.ItemNum30;
ware.ItemNum31 -= borrowModel.ItemNum31;
ware.ItemNum32 -= borrowModel.ItemNum32;
ware.ItemNum33 -= borrowModel.ItemNum33;
ware.ItemNum34 -= borrowModel.ItemNum34;
ware.ItemNum35 -= borrowModel.ItemNum35;
ware.ItemNum36 -= borrowModel.ItemNum36;
ware.ItemNum37 -= borrowModel.ItemNum37;
ware.ItemNum38 -= borrowModel.ItemNum38;
ware.ItemNum39 -= borrowModel.ItemNum39;
ware.ItemNum40 -= borrowModel.ItemNum40;
_context.Update(ware);
}
private void mediaGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
int row = e.RowIndex;//get which row was selected
//if user clicks column headers, row = -1, so ignore
if (row >= 0)
{
//cast dataSource from object back into what we put it in
List <MediaModel> medias = (List <MediaModel>)mediaGridView.DataSource;
//get the individual media selected
MediaModel media = medias[row];
selectMediaLable.Text = "Selected Media: " + media.MediaName;
selectedMedia = media;
selectedReserve = mediaLogic.GetReserved(selectedMedia.MediaId);
selectedBorrowed = mediaLogic.GetBorrowed(selectedMedia.MediaId);
//Media availability
if (mediaLogic.GetReservedByMedia(selectedMedia.MediaId) != null)
{
availabilityLabel.Text = "Media Availability: Reserved";
reserveButton.Text = "Unreserve";//Changes button text to unreserve
}
else if (mediaLogic.GetBorrowedByMediaId(selectedMedia.MediaId) != null)
{
var item = mediaLogic.GetBorrowedByMediaId(selectedMedia.MediaId);
if (item.Last().ActualReturnDate < item.Last().BorrowDate)
{
availabilityLabel.Text = "Media Availability: Borrowed";
}
else
{
availabilityLabel.Text = "Media Availability: Available";
}
reserveButton.Text = "Reserve";
}
else
{
availabilityLabel.Text = "Media Availability: Available";
reserveButton.Text = "Reserve"; //Returns button text to reserve
}
}
}
// GET: Borrow/Return
public ActionResult Return(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BorrowModel borrowModel = db.BorrowModels.Find(id);
if (borrowModel == null)
{
return(HttpNotFound());
}
borrowModel.DateComplete = DateTime.Now;
db.Entry(borrowModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Lended"));
}
private void borrowDataGridView_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
int row = e.RowIndex;
try
{
if (row >= 0)
{
List <BorrowModel> models = (List <BorrowModel>)borrowDataGridView.DataSource;
//get selected row
BorrowModel borrow = models.ElementAt(row);
//change label to show Borrow id
//figure out why only works on a few cells not all ( ids and actual return date dont pass value)
selectedBorrowItemLbl.Text = "Update BID = " + borrow.BID.ToString();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void OnPost()
{
ItemId = Convert.ToUInt32(Item);
var borrow = new BorrowModel(Distributor, Borrower, BorrowDate, Availability, ItemId);
if (MainMethods.ItemCanBeBorrowInThisPeriod(ItemId, BorrowDate, Availability))
{
var res = DbConn.CreateNewBorrow(borrow);
if (res == "Success")
{
Response.Redirect("/Borrow/Index?status=1");
}
else
{
Response.Redirect("/Borrow/Index?status=3");
}
}
else
{
Response.Redirect($"/Borrow/Create?status=7&id={ItemId}");
}
}
// GET: Borrow/Create
public ActionResult Lend(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BorrowModel borrowModel = db.BorrowModels.Include(i => i.UserRequest).FirstOrDefault(x => x.ID == id);
if (borrowModel == null)
{
return(HttpNotFound());
}
Mail.MailHandler.SendMail(borrowModel.Description, borrowModel.UserRequest.Email, "Solicitação de empréstimo atendida.");
borrowModel.UserLending = db.Users.Find(User.Identity.GetUserId());
db.Entry(borrowModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Lended"));
}
private async Task <List <ItemViewModel> > MyGetRealItemsAsync(double discount, BorrowModel borrowModel)
{
var realItems = new List <ItemViewModel>();
var item = _context.ItemModels;
if (borrowModel.ItemNum1 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "床单 1.2M",
ItemQuantity = borrowModel.ItemNum1,
ItemTrueUnitValue = (await item.FindAsync("床单 1.2M")).ItemValue * discount
});
}
if (borrowModel.ItemNum2 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "床单 1.5M",
ItemQuantity = borrowModel.ItemNum2,
ItemTrueUnitValue = (await item.FindAsync("床单 1.5M")).ItemValue * discount
});
}
if (borrowModel.ItemNum3 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "床单 1.8M",
ItemQuantity = borrowModel.ItemNum3,
ItemTrueUnitValue = (await item.FindAsync("床单 1.8M")).ItemValue * discount
});
}
if (borrowModel.ItemNum4 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "被套 1.2M",
ItemQuantity = borrowModel.ItemNum4,
ItemTrueUnitValue = (await item.FindAsync("被套 1.2M")).ItemValue * discount
});
}
if (borrowModel.ItemNum5 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "被套 1.5M",
ItemQuantity = borrowModel.ItemNum5,
ItemTrueUnitValue = (await item.FindAsync("被套 1.5M")).ItemValue * discount
});
}
if (borrowModel.ItemNum6 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "被套 1.8M",
ItemQuantity = borrowModel.ItemNum6,
ItemTrueUnitValue = (await item.FindAsync("被套 1.8M")).ItemValue * discount
});
}
if (borrowModel.ItemNum7 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "枕套",
ItemQuantity = borrowModel.ItemNum7,
ItemTrueUnitValue = (await item.FindAsync("枕套")).ItemValue * discount
});
}
if (borrowModel.ItemNum8 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "浴巾",
ItemQuantity = borrowModel.ItemNum8,
ItemTrueUnitValue = (await item.FindAsync("浴巾")).ItemValue * discount
});
}
if (borrowModel.ItemNum9 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "地巾",
ItemQuantity = borrowModel.ItemNum9,
ItemTrueUnitValue = (await item.FindAsync("地巾")).ItemValue * discount
});
}
if (borrowModel.ItemNum10 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "毛巾",
ItemQuantity = borrowModel.ItemNum10,
ItemTrueUnitValue = (await item.FindAsync("毛巾")).ItemValue * discount
});
}
if (borrowModel.ItemNum11 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "方巾",
ItemQuantity = borrowModel.ItemNum11,
ItemTrueUnitValue = (await item.FindAsync("方巾")).ItemValue * discount
});
}
if (borrowModel.ItemNum12 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "大台布",
ItemQuantity = borrowModel.ItemNum12,
ItemTrueUnitValue = (await item.FindAsync("大台布")).ItemValue * discount
});
}
if (borrowModel.ItemNum13 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "香巾",
ItemQuantity = borrowModel.ItemNum13,
ItemTrueUnitValue = (await item.FindAsync("香巾")).ItemValue * discount
});
}
if (borrowModel.ItemNum14 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "小台布",
ItemQuantity = borrowModel.ItemNum14,
ItemTrueUnitValue = (await item.FindAsync("小台布")).ItemValue * discount
});
}
if (borrowModel.ItemNum15 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "口布",
ItemQuantity = borrowModel.ItemNum15,
ItemTrueUnitValue = (await item.FindAsync("口布")).ItemValue * discount
});
}
if (borrowModel.ItemNum16 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "毛毯",
ItemQuantity = borrowModel.ItemNum16,
ItemTrueUnitValue = (await item.FindAsync("毛毯")).ItemValue * discount
});
}
if (borrowModel.ItemNum17 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "桌围裙",
ItemQuantity = borrowModel.ItemNum17,
ItemTrueUnitValue = (await item.FindAsync("桌围裙")).ItemValue * discount
});
}
if (borrowModel.ItemNum18 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "厨衣",
ItemQuantity = borrowModel.ItemNum18,
ItemTrueUnitValue = (await item.FindAsync("厨衣")).ItemValue * discount
});
}
if (borrowModel.ItemNum19 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "窗帘",
ItemQuantity = borrowModel.ItemNum19,
ItemTrueUnitValue = (await item.FindAsync("窗帘")).ItemValue * discount
});
}
if (borrowModel.ItemNum20 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "窗帘内胆",
ItemQuantity = borrowModel.ItemNum20,
ItemTrueUnitValue = (await item.FindAsync("窗帘内胆")).ItemValue * discount
});
}
if (borrowModel.ItemNum21 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "浴帘",
ItemQuantity = borrowModel.ItemNum21,
ItemTrueUnitValue = (await item.FindAsync("浴帘")).ItemValue * discount
});
}
if (borrowModel.ItemNum22 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "浴服",
ItemQuantity = borrowModel.ItemNum22,
ItemTrueUnitValue = (await item.FindAsync("浴服")).ItemValue * discount
});
}
if (borrowModel.ItemNum23 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "椅套",
ItemQuantity = borrowModel.ItemNum23,
ItemTrueUnitValue = (await item.FindAsync("椅套")).ItemValue * discount
});
}
if (borrowModel.ItemNum24 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "帽子",
ItemQuantity = borrowModel.ItemNum24,
ItemTrueUnitValue = (await item.FindAsync("帽子")).ItemValue * discount
});
}
if (borrowModel.ItemNum25 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "床裙",
ItemQuantity = borrowModel.ItemNum25,
ItemTrueUnitValue = (await item.FindAsync("床裙")).ItemValue * discount
});
}
if (borrowModel.ItemNum26 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "缎料工服",
ItemQuantity = borrowModel.ItemNum26,
ItemTrueUnitValue = (await item.FindAsync("缎料工服")).ItemValue * discount
});
}
if (borrowModel.ItemNum27 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "唐装",
ItemQuantity = borrowModel.ItemNum27,
ItemTrueUnitValue = (await item.FindAsync("唐装")).ItemValue * discount
});
}
if (borrowModel.ItemNum28 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "免烫工服",
ItemQuantity = borrowModel.ItemNum28,
ItemTrueUnitValue = (await item.FindAsync("免烫工服")).ItemValue * discount
});
}
if (borrowModel.ItemNum29 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "旗袍",
ItemQuantity = borrowModel.ItemNum29,
ItemTrueUnitValue = (await item.FindAsync("旗袍")).ItemValue * discount
});
}
if (borrowModel.ItemNum30 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "西服",
ItemQuantity = borrowModel.ItemNum30,
ItemTrueUnitValue = (await item.FindAsync("西服")).ItemValue * discount
});
}
if (borrowModel.ItemNum31 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "领带",
ItemQuantity = borrowModel.ItemNum31,
ItemTrueUnitValue = (await item.FindAsync("领带")).ItemValue * discount
});
}
if (borrowModel.ItemNum32 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "已烫工服",
ItemQuantity = borrowModel.ItemNum32,
ItemTrueUnitValue = (await item.FindAsync("已烫工服")).ItemValue * discount
});
}
if (borrowModel.ItemNum33 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "沙发套",
ItemQuantity = borrowModel.ItemNum33,
ItemTrueUnitValue = (await item.FindAsync("沙发套")).ItemValue * discount
});
}
if (borrowModel.ItemNum34 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "床罩",
ItemQuantity = borrowModel.ItemNum34,
ItemTrueUnitValue = (await item.FindAsync("床罩")).ItemValue * discount
});
}
if (borrowModel.ItemNum35 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "抹布",
ItemQuantity = borrowModel.ItemNum35,
ItemTrueUnitValue = (await item.FindAsync("抹布")).ItemValue * discount
});
}
if (borrowModel.ItemNum36 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "保护垫",
ItemQuantity = borrowModel.ItemNum36,
ItemTrueUnitValue = (await item.FindAsync("保护垫")).ItemValue * discount
});
}
if (borrowModel.ItemNum37 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "地毯清洗",
ItemQuantity = borrowModel.ItemNum37,
ItemTrueUnitValue = (await item.FindAsync("地毯清洗")).ItemValue * discount
});
}
if (borrowModel.ItemNum38 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "足浴窄床单",
ItemQuantity = borrowModel.ItemNum38,
ItemTrueUnitValue = (await item.FindAsync("足浴窄床单")).ItemValue * discount
});
}
if (borrowModel.ItemNum39 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "预留1",
ItemQuantity = borrowModel.ItemNum39,
ItemTrueUnitValue = (await item.FindAsync("预留1")).ItemValue * discount
});
}
if (borrowModel.ItemNum40 != 0)
{
realItems.Add(new ItemViewModel
{
ItemName = "预留2",
ItemQuantity = borrowModel.ItemNum40,
ItemTrueUnitValue = (await item.FindAsync("预留2")).ItemValue * discount
});
}
return(realItems);
}
public async Task <IActionResult> Create([Bind("BorrowOrderID,AccountName,StartTime,IsCanceled,IsCompleted,IsTraned,BorrowNote,ItemNum1,ItemNum2,ItemNum3,ItemNum4,ItemNum5,ItemNum6,ItemNum7,ItemNum8,ItemNum9,ItemNum10,ItemNum11,ItemNum12,ItemNum13,ItemNum14,ItemNum15,ItemNum16,ItemNum17,ItemNum18,ItemNum19,ItemNum20,ItemNum21,ItemNum22,ItemNum23,ItemNum24,ItemNum25,ItemNum26,ItemNum27,ItemNum28,ItemNum29,ItemNum30,ItemNum31,ItemNum32,ItemNum33,ItemNum34,ItemNum35,ItemNum36,ItemNum37,ItemNum38,ItemNum39,ItemNum40")] BorrowModel borrowModel)
{
if (BorrowCheckZero(borrowModel))
{
ModelState.AddModelError("BorrowNote", "订单不能全部为0");
}
if (ModelState.IsValid)
{
var ware = await _context.WarehouseModels.FirstOrDefaultAsync(x => x.Account.Type == Models.EnumClass.EnumAccountType.仓库保管员);
var account = await _context.AccountModels.SingleOrDefaultAsync(x => x.AccountName == User.FindFirst(ClaimTypes.Sid).Value);
var discount = await _context.DiscountModels.SingleOrDefaultAsync(x => x.AccountName == User.FindFirst(ClaimTypes.Sid).Value);
if (ware == null)
{
ModelState.AddModelError("BorrowNote", "系统库存未初始化 请联系管理员");
}
else if (discount == null)
{
//021错误是用户的折扣信息没有初始化 或者当前用户存在多个折扣信息
ModelState.AddModelError("BorrowNote", "用户信息初始化错误，请联系管理员，code：021");
}
else if (borrowModel.ItemNum1 > ware.ItemNum1)
{
ModelState.AddModelError("ItemNum1", "库存不足");
}
else if (borrowModel.ItemNum2 > ware.ItemNum2)
{
ModelState.AddModelError("ItemNum2", "库存不足");
}
else if (borrowModel.ItemNum3 > ware.ItemNum3)
{
ModelState.AddModelError("ItemNum3", "库存不足");
}
else if (borrowModel.ItemNum4 > ware.ItemNum4)
{
ModelState.AddModelError("ItemNum4", "库存不足");
}
else if (borrowModel.ItemNum5 > ware.ItemNum5)
{
ModelState.AddModelError("ItemNum5", "库存不足");
}
else if (borrowModel.ItemNum6 > ware.ItemNum6)
{
ModelState.AddModelError("ItemNum6", "库存不足");
}
else if (borrowModel.ItemNum7 > ware.ItemNum7)
{
ModelState.AddModelError("ItemNum7", "库存不足");
}
else if (borrowModel.ItemNum8 > ware.ItemNum8)
{
ModelState.AddModelError("ItemNum8", "库存不足");
}
else if (borrowModel.ItemNum9 > ware.ItemNum9)
{
ModelState.AddModelError("ItemNum9", "库存不足");
}
else if (borrowModel.ItemNum10 > ware.ItemNum10)
{
ModelState.AddModelError("ItemNum10", "库存不足");
}
//----------------------10----------------------------
else if (borrowModel.ItemNum11 > ware.ItemNum11)
{
ModelState.AddModelError("ItemNum11", "库存不足");
}
else if (borrowModel.ItemNum12 > ware.ItemNum12)
{
ModelState.AddModelError("ItemNum12", "库存不足");
}
else if (borrowModel.ItemNum13 > ware.ItemNum13)
{
ModelState.AddModelError("ItemNum13", "库存不足");
}
else if (borrowModel.ItemNum14 > ware.ItemNum14)
{
ModelState.AddModelError("ItemNum14", "库存不足");
}
else if (borrowModel.ItemNum15 > ware.ItemNum15)
{
ModelState.AddModelError("ItemNum15", "库存不足");
}
else if (borrowModel.ItemNum16 > ware.ItemNum16)
{
ModelState.AddModelError("ItemNum16", "库存不足");
}
else if (borrowModel.ItemNum17 > ware.ItemNum17)
{
ModelState.AddModelError("ItemNum17", "库存不足");
}
else if (borrowModel.ItemNum18 > ware.ItemNum18)
{
ModelState.AddModelError("ItemNum18", "库存不足");
}
else if (borrowModel.ItemNum19 > ware.ItemNum19)
{
ModelState.AddModelError("ItemNum19", "库存不足");
}
else if (borrowModel.ItemNum20 > ware.ItemNum20)
{
ModelState.AddModelError("ItemNum20", "库存不足");
}
//---------------------------20------------------------
else if (borrowModel.ItemNum21 > ware.ItemNum21)
{
ModelState.AddModelError("ItemNum21", "库存不足");
}
else if (borrowModel.ItemNum22 > ware.ItemNum22)
{
ModelState.AddModelError("ItemNum22", "库存不足");
}
else if (borrowModel.ItemNum23 > ware.ItemNum23)
{
ModelState.AddModelError("ItemNum23", "库存不足");
}
else if (borrowModel.ItemNum24 > ware.ItemNum24)
{
ModelState.AddModelError("ItemNum24", "库存不足");
}
else if (borrowModel.ItemNum25 > ware.ItemNum25)
{
ModelState.AddModelError("ItemNum25", "库存不足");
}
else if (borrowModel.ItemNum26 > ware.ItemNum26)
{
ModelState.AddModelError("ItemNum26", "库存不足");
}
else if (borrowModel.ItemNum27 > ware.ItemNum27)
{
ModelState.AddModelError("ItemNum27", "库存不足");
}
else if (borrowModel.ItemNum28 > ware.ItemNum28)
{
ModelState.AddModelError("ItemNum28", "库存不足");
}
else if (borrowModel.ItemNum29 > ware.ItemNum29)
{
ModelState.AddModelError("ItemNum29", "库存不足");
}
else if (borrowModel.ItemNum30 > ware.ItemNum30)
{
ModelState.AddModelError("ItemNum30", "库存不足");
}
//---------------------------30------------------------
else if (borrowModel.ItemNum31 > ware.ItemNum31)
{
ModelState.AddModelError("ItemNum31", "库存不足");
}
else if (borrowModel.ItemNum32 > ware.ItemNum32)
{
ModelState.AddModelError("ItemNum32", "库存不足");
}
else if (borrowModel.ItemNum33 > ware.ItemNum33)
{
ModelState.AddModelError("ItemNum33", "库存不足");
}
else if (borrowModel.ItemNum34 > ware.ItemNum34)
{
ModelState.AddModelError("ItemNum34", "库存不足");
}
else if (borrowModel.ItemNum35 > ware.ItemNum35)
{
ModelState.AddModelError("ItemNum35", "库存不足");
}
else if (borrowModel.ItemNum36 > ware.ItemNum36)
{
ModelState.AddModelError("ItemNum36", "库存不足");
}
else if (borrowModel.ItemNum37 > ware.ItemNum37)
{
ModelState.AddModelError("ItemNum37", "库存不足");
}
else if (borrowModel.ItemNum38 > ware.ItemNum38)
{
ModelState.AddModelError("ItemNum38", "库存不足");
}
else if (borrowModel.ItemNum39 > ware.ItemNum39)
{
ModelState.AddModelError("ItemNum39", "库存不足");
}
else if (borrowModel.ItemNum40 > ware.ItemNum40)
{
ModelState.AddModelError("ItemNum40", "库存不足");
}
else if (_context.ItemModels.Count() < 40)
{
ModelState.AddModelError("BorrowNote", "物品信息数量不足 请联系管理员");
}
else
{
borrowModel.OrderMoney = await ComputeTempBalance(borrowModel) * discount.DiscountValue;
//余额非负判断
if (account.Balance >= borrowModel.OrderMoney)
{
account.Balance -= borrowModel.OrderMoney; //余额减少
WareReduce(ware, borrowModel); //库存减少
_context.Update(account);
_context.Add(borrowModel);
await _context.SaveChangesAsync();
return(RedirectToAction("OrderCurrent", "Home", new { id = borrowModel.AccountName }));
}
ModelState.AddModelError("BorrowNote", "您的余额不足 无法提交订单");
}
}
ViewData["Discount"] = await _context.DiscountModels.FirstOrDefaultAsync(x => x.AccountName == User.FindFirst(ClaimTypes.Sid).Value);
ViewData["ItemModels"] = await _context.ItemModels.ToListAsync();
return(View(borrowModel));
}
