Exemple #1
0
        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");
                }
            }
    
        }
Exemple #2
0
        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);

        }
Exemple #5
0
 private void Genericmast_Load(object sender, EventArgs e)
 {
     var proxy = new DataManager();
     proxy.GetGeneric();
     dsMaster.Merge(proxy.GetGeneric());
 }
Exemple #6
0
 private void ItemGroup_Load(object sender, EventArgs e)
 {
     var proxy = new DataManager();
     proxy.GetItemGroup();
     dsMaster.Merge(proxy.GetItemGroup());
 }
Exemple #7
0
 private void ItemCategory_Load(object sender, EventArgs e)
 {
     var proxy = new DataManager();
     proxy.GetCategory();
     dsMaster1.Merge(proxy.GetCategory());
 }
Exemple #8
0
 public static string GetFormatedAutoNo(int sourceid)
 {
     var taa = new DataManager();
     return taa.GetFormatedAutoNo(5);
 }
Exemple #9
0
 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();
 }
Exemple #10
0
 private void UOMMAST_Load(object sender, EventArgs e)
 {
     var proxy = new DataManager();
     proxy.GetUom();
     dsMaster.Merge(proxy.GetUom());
 }