Exemple #1
0
        public SQLParams AddSupplier(BusinessEntity.Supplier sup)
        {
            SQLParams par = new SQLParams();

            par.ProcName = "dbo.COMMON_UTILITY";
            par.Segment  = "ADDSUPPLIER";
            par.var01    = sup.SupplierId;
            par.var02    = sup.Company_Name;
            par.var03    = sup.Contact_Name;
            par.var04    = sup.Address;
            par.var05    = sup.City.ToString();
            par.var06    = sup.Postal_Code.ToString();
            par.var07    = sup.Country;
            par.var08    = sup.Phone;
            par.var09    = sup.email;
            return(par);
        }
Exemple #2
0
        public ActionResult Edit(string id)
        {
            var      param = _parm.EditSupplier(id);
            DataSet  ds    = _Data.GetDataSetResult(param);
            Supplier sup   = new BusinessEntity.Supplier()
            {
                SupplierId   = ds.Tables[0].Rows[0]["SupplierId"].ToString(),
                Company_Name = ds.Tables[0].Rows[0]["Company_Name"].ToString(),
                Contact_Name = ds.Tables[0].Rows[0]["Contact_Name"].ToString(),
                Address      = ds.Tables[0].Rows[0]["Address"].ToString(),
                City         = ds.Tables[0].Rows[0]["City"].ToString(),
                Postal_Code  = ds.Tables[0].Rows[0]["Postal_Code"].ToString(),
                Country      = ds.Tables[0].Rows[0]["Country"].ToString(),
                Phone        = ds.Tables[0].Rows[0]["Phone"].ToString(),
                email        = ds.Tables[0].Rows[0]["email"].ToString()
            };

            return(View(sup));
        }