internal DataSet CheckItemInvoiced(dhDBnames objDBNames, dhInvoice objInvoice) { DataSet ds; ds = objDALGeneral.CheckItemInvoiced(objDBNames, objInvoice); return(ds); }
private void UserControl_Loaded_1(object sender, RoutedEventArgs e) { dhInvoice objInvoice = new dhInvoice(); // loadData(objInvoice); }
internal DataSet RemoveSaleInovice(dhDBnames dhDBnames, dhInvoice objInvoice) { DataSet ds; ds = objDALGeneral.RemoveSaleInovice(dhDBnames, objInvoice); return(ds); }
public DataSet InsertUpdateSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice) { DataSet ds; ds = objDALGeneral.InsertUpdateSaleInovice(objDBNames, objInvoice); return(ds); }
public DataSet GetSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice) { DataSet ds; ds = objDALGeneral.GetSaleInovice(objDBNames, objInvoice); return(ds); }
//= new ObservableCollection<dhParty>(); public InvoicesViewModel() { DisplayName = "Invoices"; dhInvoice objLoad = new dhInvoice(); this.loadData(objLoad); }
public static DataSet CheckItemInvoiced(dhDBnames objDBNames, dhInvoice objInvoice) { DataSet var_ret; if (objblInvoice == null) { objblInvoice = new blInvoice(); } { var_ret = objblInvoice.CheckItemInvoiced(objDBNames, objInvoice); } return(var_ret); }
//public static DataSet InsertUpdateSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice, Boolean InsertItems = false) //{ // try // { // DataSet var_ret; // if (objblInvoice == null) { objblInvoice = new blInvoice(); } // var_ret = objblInvoice.InsertUpdateSaleInovice(objDBNames, objInvoice); // if (InsertItems) // { // // get the SaleID // long ID = Convert.ToInt64(var_ret.Tables[0].Rows[0]["iSaleid"].ToString()); ; // // get the observerable collection // ItemsList ItemCollection = objInvoice.ItemsOfInvoice; // int ItemID = 1; // // check is it draft // if (objInvoice.BIsDraft == true) // { // // check if the item are there already // if ((var_ret.Tables.Count == 1) && (var_ret.Tables["dtPosSaleItem"].Rows.Count > 0)) // { // ObservableCollection<dhSaleItem> objlist = ReflectionUtility.DataTableToObservableCollection<dhSaleItem>(var_ret.Tables["dtPosSaleItem"]); // //ItemsList ToDelete = objlist.ToObservableCollectio(); // //List<dhSaleItem> abc = (List<dhSaleItem>)ItemCollection; // foreach (dhSaleItem item in ItemCollection) // { // item.ISaleid = ID; // //int.TryParse( // item.IUpdate = !string.IsNullOrEmpty(objInvoice.IUpdate.ToString()) ? objInvoice.IUpdate : 0; // // item.ISerialNumber = ItemID; // ItemID = ItemID + 1; // item.IUserId = Convert.ToInt32(objInvoice.IUserid); // if (objblInvoice == null) { objblInvoice = new blInvoice(); } // { // var_ret = objblInvoice.InsertUpdateSaleInoviceItem(objDBNames, item); // } // } // //foreach (dhSaleItem item in objlist) // //{ // //} // } // } // } // return var_ret; // } // catch (Exception ex) { throw ex; } //} public static DataSet GetSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice) { DataSet var_ret; if (objblInvoice == null) { objblInvoice = new blInvoice(); } { var_ret = objblInvoice.GetSaleInovice(objDBNames, objInvoice); } return(var_ret); }
public DataSet GetSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice) { DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objInvoice, "xmlGetSaleInovice"); if ((dsreturn.Tables.Count > 0) && (dsreturn.Tables.Count == 1)) { dsreturn.Tables[0].TableName = "dtPosSaleInovice"; } else if ((dsreturn.Tables.Count > 0) && (dsreturn.Tables.Count == 2)) { dsreturn.Tables[0].TableName = "dtPosSaleInovice"; dsreturn.Tables[1].TableName = "dtPosSaleItem"; } return(dsreturn); }
public static DataSet InsertUpdateSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice, Boolean InsertItems = false) { try { DataSet var_ret, ItemDs; if (objblInvoice == null) { objblInvoice = new blInvoice(); } var_ret = objblInvoice.InsertUpdateSaleInovice(objDBNames, objInvoice); if (InsertItems) { // get the SaleID long ID = Convert.ToInt64(var_ret.Tables[0].Rows[0]["iSaleid"].ToString());; // get the observerable collection ItemsList ItemCollection = objInvoice.ItemsOfInvoice; int ItemID = 1; foreach (dhSaleItem item in ItemCollection) { item.ISaleid = ID; if (item.ISaleItemid != 0) { item.IUpdate = !string.IsNullOrEmpty(objInvoice.IUpdate.ToString()) ? objInvoice.IUpdate : 0; } else { item.IUpdate = 0; } ItemID = ItemID + 1; item.IUserId = Convert.ToInt32(objInvoice.IUserid); if (objblInvoice == null) { objblInvoice = new blInvoice(); } { ItemDs = objblInvoice.InsertUpdateSaleInoviceItem(objDBNames, item); } } } return(var_ret); } catch (Exception ex) { throw ex; } }
private TabItem AddTabItem() { int count = _tabItems.Count; TabItem tab = new TabItem(); // tab.Header = "Add Invoice";//string.Format("Tab {0}", count); //tab.Name = "AddInvoice";//string.Format("tab{0}", count); tab.Header = string.Format("Lift {0}", TabCounter + 1);//string.Format("Tab {0}", count); tab.Name = string.Format("Lift{0}", TabCounter); tab.HeaderTemplate = tabDynamic.FindResource("TabHeader") as DataTemplate; dhInvoice NewItem = new dhInvoice(); // NewItem tab.Content = new EmptyInvoiceView(); _tabItems.Insert(count - 1, tab); TabCounter++; return(tab); }
public static DataSet RemoveSaleInovice(dhDBnames dhDBnames, dhInvoice objInvoice) { try { DataSet var_ret; if (objblInvoice == null) { objblInvoice = new blInvoice(); } var_ret = objblInvoice.RemoveSaleInovice(dhDBnames, objInvoice); return(var_ret); } catch (Exception) { throw; } }
private void Invoices_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (sender != null) { DataGridRow dgr = sender as DataGridRow; // get the obect and then Invoice ID opne the Id in readonly mode dhInvoice objTodisplay = new dhInvoice(); objTodisplay.ISaleid = ((dhInvoice)dgr.Item).ISaleid; DataSet dsr = iFacede.GetSaleInovice(Globalized.ObjDbName, objTodisplay); objTodisplay = (dhInvoice)dgr.Item; if ((dsr.Tables.Count > 0) && (dsr.Tables[0].Rows.Count > 0)) { ObservableCollection <dhInvoice> objlist = ReflectionUtility.DataTableToObservableCollection <dhInvoice>(dsr.Tables[0]); objTodisplay = (dhInvoice)objlist.SingleOrDefault(); } if ((dsr.Tables.Count > 0) && (dsr.Tables[1].Rows.Count > 0)) { ObservableCollection <dhSaleItem> listItem = ReflectionUtility.DataTableToObservableCollection <dhSaleItem>(dsr.Tables[1]); ItemsList itemlist = new ItemsList().AddRange(listItem); objTodisplay.ItemsOfInvoice = itemlist; } //DataSet dsr = iFacede.GetSaleInovice(Globalized.ObjDbName, objTodisplay); //ObservableCollection<dhSaleItem> ListAccounts = ReflectionUtility.DataTableToObservableCollection<dhSaleItem>(dsr.Tables[1]); //ItemsList itemlist = new ItemsList().AddRange(ListAccounts); //objTodisplay = (dhInvoice)dgr.Item; if (objTodisplay.BIsDraft != true) { objTodisplay.IsReadOnly = true; } else { objTodisplay.IsReadOnly = false; } // AddTabItem(objTodisplay); } }
public DataSet RemoveSaleInovice(dhDBnames dhDBnames, dhInvoice objInvoice) { DataSet dsreturn = objDatabase.GetDataSet(dhDBnames, objInvoice, "xmlRemoveSaleInovice"); return(dsreturn); }
public DataSet CheckItemInvoiced(dhDBnames objDBNames, dhInvoice objInvoice) { DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objInvoice, "xmlCheckItemInvoiced"); return(dsreturn); }
private void loadData(dhInvoice objInovice /* , Boolean ShowResultCount = false*/) { DataSet dtInovice = iFacede.GetSaleInovice(Globalized.ObjDbName, objInovice); Invoices = ReflectionUtility.DataTableToObservableCollection <dhInvoice>(dtInovice.Tables[0]); }