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);
}
