} // writeToExcel
public void writeItemToExcel(Item_Furnishings.ItemData itemData)
{
var xlFile = new FileInfo(filename);
//string i=readIDfromExcel().ToString();
using (var package = new ExcelPackage(xlFile))
{ //Add some items...
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
//worksheet.Cells["A" + i].Value = itemData.ID;
int i = worksheet.Dimension.End.Row;
worksheet.Cells["a" + i].Value = itemData.ID;
worksheet.Cells["B" + i].Value = itemData.info;
worksheet.Cells["C" + i].Value = itemData.name_family;
worksheet.Cells["D" + i].Value = itemData.adress;
worksheet.Cells["e" + i].Value = itemData.telephone;
worksheet.Cells["f" + i].Value = itemData.seller_name;
worksheet.Cells["g" + i].Value = itemData.cost;
worksheet.Cells["h" + i].Value = itemData.balance;
worksheet.Cells["i" + i].Value = itemData.time_delivery;
worksheet.Cells["j" + i].Style.Numberformat.Format = "dd.MM.yyyy";
worksheet.Cells["j" + i].Value = itemData.date_order;
// save our new workbook in the output directory and we are done!
try { package.SaveAs(xlFile); } catch (Exception e) { MessageBox.Show(e.Message.ToString() + "add item"); }
}
}
public void AddItemToDataSet(Item_Furnishings.ItemData itemData)
{
//string id=readIDfromExcel().ToString();
DataRow dtRow = MainWindow.dataSet.Tables[0].NewRow();
//int rowsCount = MainWindow.dataSet.Tables[0].Rows.Count; int columnsCount = MainWindow.dataSet.Tables[0].Columns.Count;
//for ( int i=0; i<rowsCount; i++ )
//{
// if( Convert.ToUInt32(MainWindow.dataSet.Tables[0].Rows[i].ItemArray[0])==itemData.ID)
// { MessageBox.Show("ID already existing"); goto end; }
//}
dtRow["Id"] = itemData.ID;
dtRow["info"] = itemData.info;
dtRow["name"] = itemData.name_family;
dtRow["adress"] = itemData.adress;
dtRow["telephone"] = itemData.telephone;
dtRow["seller_name"] = itemData.seller_name;
dtRow["cost"] = itemData.cost;
dtRow["balance"] = itemData.balance;
dtRow["time_delivery"] = itemData.time_delivery;
dtRow["date_order"] = itemData.date_order;
MainWindow.dataSet.Tables[0].Rows.Add(dtRow);
MainWindow.dataSet.AcceptChanges();
end :;
}
public void AcceptChangeItemDataSet(Item_Furnishings.ItemData itemData)
{
dr_Order["id"] = itemData.ID;
dr_Order["info"] = itemData.info;
dr_Order["name"] = itemData.name_family;
dr_Order["adress"] = itemData.adress;
dr_Order["telephone"] = itemData.telephone;
dr_Order["seller_name"] = itemData.seller_name;
dr_Order["cost"] = itemData.cost;
dr_Order["balance"] = itemData.balance;
dr_Order["time_delivery"] = itemData.time_delivery;
dr_Order["date_order"] = itemData.date_order;
MainWindow.dataSet.AcceptChanges();
}
