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