private void gENERICMASTBindingNavigatorSaveItem_Click_1(object sender, EventArgs e) { Validate(); gENERICMASTBindingSource.EndEdit(); // NorthwindService.ServiceClient proxy = new NorthwindClient.NorthwindService.ServiceClient(); var proxy = new DataManager(); var changes = (DsMaster)dsMaster.GetChanges(); //NorthwindEntities.OrdersDataSet changes = (NorthwindEntities.OrdersDataSet)this.ordersDataSet.GetChanges(); if (changes != null) { if (proxy.SaveItemGenric(changes)) { var addedRows = from row in dsMaster.GENERICMAST where row.RowState == DataRowState.Added select row; foreach (var row in addedRows.ToArray()) { row.Delete(); } dsMaster.Merge(changes); dsMaster.AcceptChanges(); MessageBox.Show("Saved"); } else { MessageBox.Show("Not saved"); } } }
private void cATEGORYBindingNavigatorSaveItem_Click(object sender, EventArgs e) { Validate(); cATEGORYBindingSource.EndEdit(); var proxy = new DataManager(); var changes = (DsMaster)dsMaster1.GetChanges(); if (changes != null) { if(proxy.SaveCategory(changes)) { var addedRows = from row in dsMaster1.CATEGORY where row.RowState == DataRowState.Added select row; foreach (var row in addedRows.ToArray()) { row.Delete(); } dsMaster1.Merge(changes); dsMaster1.AcceptChanges(); MessageBox.Show("Saved"); } else { MessageBox.Show("Not saved"); } } }
void LoadGrid(DataRow dr1) { if(dsPurchase1.PURCHASEREQUEST.Rows.Count==0) { var dm = new DataManager(); int auto = dm.GetAutoId(16); dm.UpdateAutoNum(16); auto++; prno = dm.CreateFormatedAutoNo(auto); } var dr = dsPurchase1.PURCHASEREQUEST.NewRow(); dr["PRNO"] = prno; dr["COMPANY"] = Utils.Company; if (comboBoxEdit1.SelectedIndex == 0) { dr["SUPPLIERNO"] = LookupSupplier.EditValue == null ? ClsGetData.GetDefaultSupplier(dr1[0].ToString()) : LookupSupplier.EditValue; } else { dr["SUPPLIERNO"] = ClsGetData.GetDefaultSupplier(dr1[0].ToString()); } dr["ITEMNO"] = dr1[0]; dr["QTY"] = string.IsNullOrEmpty(dr1[3].ToString())? 1 : int.Parse(dr1[3].ToString()); //dr["REQDATE"] = null; dr["CDATE"] = DateTime.Now; dr["USERID"] = Utils.Userid; dr["INORDER"] = 0; dsPurchase1.PURCHASEREQUEST.Rows.Add(dr); }
void LoadGrid(DataRow dr1) { if (boolprno) { var dm = new DataManager(); int auto = dm.GetAutoId(16); dm.UpdateAutoNum(16); auto++; prno = dm.CreateFormatedAutoNo(auto); boolprno = false; } var dr = dsPurchase1.PURCHASEREQUEST.NewRow(); dr["PRNO"] = prno; dr["COMPANY"] = Utils.Company; dr["SUPPLIERNO"] = dr1["SUPPLIERNO"].ToString(); dr["ITEMNO"] = dr1["Itemno"]; if (!string.IsNullOrEmpty(dr1["PURQTY"].ToString())) { if (int.Parse(dr1["PURQTY"].ToString()) == 0) dr["QTY"] = 1; else dr["QTY"] = dr1["PURQTY"]; } else { dr["QTY"] = 1; } dr["USERID"] = Utils.Userid; dr["INORDER"] = 0; dsPurchase1.PURCHASEREQUEST.Rows.Add(dr); }
private void Genericmast_Load(object sender, EventArgs e) { var proxy = new DataManager(); proxy.GetGeneric(); dsMaster.Merge(proxy.GetGeneric()); }
private void ItemGroup_Load(object sender, EventArgs e) { var proxy = new DataManager(); proxy.GetItemGroup(); dsMaster.Merge(proxy.GetItemGroup()); }
private void ItemCategory_Load(object sender, EventArgs e) { var proxy = new DataManager(); proxy.GetCategory(); dsMaster1.Merge(proxy.GetCategory()); }
public static string GetFormatedAutoNo(int sourceid) { var taa = new DataManager(); return taa.GetFormatedAutoNo(5); }
void LoadDatas() { var proxy = new DataManager(); dsMaster1.Merge(proxy.GetUom()); uOMMASTBindingSource.DataSource = proxy.GetUom(); cATEGORYBindingSource.DataSource = proxy.GetCategory(); gENERICMASTBindingSource.DataSource = proxy.GetGeneric(); iTEMTYPEBindingSource.DataSource = proxy.GetItemType(); iTEMGROUPBindingSource.DataSource = proxy.GetItemGroup(); sUPPLIERBindingSource.DataSource = proxy.GetSupplier(); dsMaster1.Merge(new BlItemMaster().GetItemMastList()); SetNavigation(); }
private void UOMMAST_Load(object sender, EventArgs e) { var proxy = new DataManager(); proxy.GetUom(); dsMaster.Merge(proxy.GetUom()); }