private void btSave_Click(object sender, RoutedEventArgs e) { // save in database //insert InventoryExport BUS_InventoryExport export = new BUS_InventoryExport(); String newExportID = export.Create(tbEmployeeName.Text, tbDate.Text, tbDescription.Text); //MessageBox.Show(newImportID); //insert InventoryImportdetails if (newExportID == null) { return; } List <String> sqlString = new List <string>(); if (list.Count.Equals(0)) { MessageBox.Show($"Danh sách nguyên vật liệu, thiết bị không được để trống!"); return; } foreach (InventoryExportDetailObject obj in list) { int amountInExport; int temp1 = -1, temp2 = -1; if (int.TryParse(obj.amount, out amountInExport)) { if (mapNameAmountInStock[obj.name] < amountInExport) { MessageBox.Show($"Số lượng của {obj.name} trong kho chỉ còn {mapNameAmountInStock[obj.name]}!"); export.Delete(newExportID); return; } } if (!int.TryParse(obj.amount, out temp2) || temp2 <= 0) { MessageBox.Show($"Số lượng của {obj.name} không hợp lệ!"); export.Delete(newExportID); return; } //if (tbDescription.Text.Length ==0) //{ // MessageBox.Show($"Vui lòng nhập lí do !"); // export.Delete(newExportID); // return; //} string temp = $"insert into InventoryExportDetail values ('{newExportID}','{obj.id}','{obj.amount}')"; sqlString.Add(temp); } BUS_InventoryExportDetail detail = new BUS_InventoryExportDetail(); detail.ImportList(sqlString); var screen = new InventoryExport(_context); if (screen != null) { this._context.StackPanelMain.Children.Clear(); this._context.StackPanelMain.Children.Add(screen); } }
public void LoadData() { mapNameAmountInStock = loadAmountofMaterial(); BUS_InventoryExport export = new BUS_InventoryExport(); DataTable temp = export.SelectDetail(selectionID); tbDescription.Text = export.SelectDescription(selectionID); Console.WriteLine(temp.Rows.Count); foreach (DataRow row in temp.Rows) { string name = row["Tên"].ToString(); string amount = row["Số lượng"].ToString(); string unit = row["Unit"].ToString(); string materID = row["MaterialID"].ToString(); list.Add(new InventoryObject() { amount = amount, name = name, unit = unit, id = materID }); if (mapNameAmountInStock.ContainsKey(name)) { mapNameAmountInStock[name] += int.Parse(amount); } } this.dataGridMaterialExport.ItemsSource = list; if (list.Count == 0) { return; } tbDescription.Text = list[0].description; }
private void btnEdit_Click(object sender, RoutedEventArgs e) { InventoryExportObject row = (InventoryExportObject)dataGridExport.SelectedItem; if (row == null) { return; } DateTime importDate = DateTime.ParseExact(row.InventoryDate, "dd/MM/yyyy", null); BUS_Parameter busParameter = new BUS_Parameter(); int limitDay = busParameter.GetValue("DayDeleteExport"); if ((DateTime.Now - importDate) > TimeSpan.FromDays(limitDay)) { MessageBox.Show($"Không thể chỉnh sửa do phiếu đã được tạo cách đây hơn {limitDay} ngày."); return; } BUS_InventoryExport export = new BUS_InventoryExport(); var screen = new InventoryExportEDIT(row.ID, row.EmployName, row.InventoryDate, export.SelectDescription(row.ID), _context); if (screen != null) { this._context.StackPanelMain.Children.Clear(); this._context.StackPanelMain.Children.Add(screen); } }
public void Delete(String id) { BUS_InventoryExportDetail detail = new BUS_InventoryExportDetail(); BUS_InventoryExport export = new BUS_InventoryExport(); detail.Delete(id); export.Delete(id); LoadData(); }
public void LoadData() { var list = new ObservableCollection <InventoryExportDetailObject>(); BUS_InventoryExport export = new BUS_InventoryExport(); DataTable temp = export.SelectDetail(selectionID); tbDescription.Text = export.SelectDescription(selectionID); Console.WriteLine(temp.Rows.Count); foreach (DataRow row in temp.Rows) { string name = row["Tên"].ToString(); string amount = row["Số lượng"].ToString(); string unit = row["Unit"].ToString(); list.Add(new InventoryExportDetailObject() { number = list.Count + 1, amount = amount, name = name, unit = unit }); } this.dataGridMaterialExport.ItemsSource = list; }
public void LoadData() { btBack.IsEnabled = false; username = _context.GetCurrentEmpName(); list.Clear(); BUS_InventoryExport export = new BUS_InventoryExport(); DataTable temp = export.SelectAll(); Console.WriteLine(temp.Rows.Count); foreach (DataRow row in temp.Rows) { string employid = row["EmployeeName"].ToString(); string id = row["exportID"].ToString(); string date = row["exportDate"].ToString(); list.Add(new InventoryExportObject() { ID = id, EmployName = employid, InventoryDate = date }); } BUS_Parameter busParameter = new BUS_Parameter(); int rowPerSheet = busParameter.GetValue("RowInList"); if (list.Count % rowPerSheet == 0) { lblMaxPage.Content = list.Count / rowPerSheet; } else { lblMaxPage.Content = list.Count / rowPerSheet + 1; } if (int.Parse(lblMaxPage.Content.ToString()) == 0) { this.tbNumPage.Text = "0"; } //MessageBox.Show(lblMaxPage.Content.ToString()); if (int.Parse(lblMaxPage.Content.ToString()) < 2) { btNext.IsEnabled = false; } splitDataGrid(1); }