public static int AddUpdateVendor(VendorDetail objVendor) { string strConnectionStrings = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString; SqlParameter[] oParam = new SqlParameter[10]; oParam[0] = DBHelper.GetParam("@Id", SqlDbType.BigInt, 8, ParameterDirection.Input, objVendor.VendorID); oParam[1] = DBHelper.GetParam("@Name", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.VendorsName); oParam[2] = DBHelper.GetParam("@Alias", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.VendorsAlias); oParam[3] = DBHelper.GetParam("@AliasProvince", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.ProvinceAlias); oParam[4] = DBHelper.GetParam("@AliasCity", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.CityAlias); oParam[5] = DBHelper.GetParam("@Phone", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.Phone); oParam[6] = DBHelper.GetParam("@Email", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.Email); oParam[7] = DBHelper.GetParam("@Address", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.VendorsAddress); oParam[8] = DBHelper.GetParam("@ImageUrl", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.ImageUrl); oParam[9] = DBHelper.GetParam("@BannerUrl", SqlDbType.VarChar, 100, ParameterDirection.Input, objVendor.BannerUrl); SqlHelper.ExecuteNonQuery(strConnectionStrings, CommandType.StoredProcedure, "USP_AddUpdateVendor", oParam); return 1; }
public static int SaveUpdateVendorData(VendorDetail objVendordetail) { return AddUpdateVendor(objVendordetail); }
public static VendorDetail GetVendorData(int VendorId) { VendorDetail objVendorDetail = new VendorDetail(); Vendors objVendors = new Vendors(); DataTable objmainDT = new DataTable(); DataRow[] objMainRow = null; if (VendorId != 0) { objmainDT = (DataTable)HttpContext.Current.Session["VendorData"]; objMainRow = objmainDT.Select("id=" + VendorId); } DataTable dtProvince = new DataTable(); dtProvince = objVendors.GetProvince(); DataRow newRowProvince = dtProvince.NewRow(); newRowProvince["ID"] = "-1"; newRowProvince["Alias"] = "-1"; newRowProvince["nama_daerah"] = "-Province-"; dtProvince.Rows.InsertAt(newRowProvince, 0); dtProvince.AcceptChanges(); objVendorDetail.Province = new CommonObjects[dtProvince.Rows.Count]; int intCount=0; foreach (DataRow drw in dtProvince.Rows) { objVendorDetail.Province[intCount] = new CommonObjects(); objVendorDetail.Province[intCount].Value = drw["Alias"].ToString(); objVendorDetail.Province[intCount].Text = drw["nama_daerah"].ToString(); objVendorDetail.Province[intCount].DefaultValue = VendorId != 0 ? objMainRow[0]["alias_daerah"].ToString() : objVendorDetail.Province[0].Value; intCount++; } DataTable dtCity = new DataTable(); dtCity = objVendors.GetCityForProvince(objVendorDetail.Province[0].DefaultValue); DataRow newRowCity = dtCity.NewRow(); newRowCity["alias"] = "-1"; newRowCity["nama_kota"] = "-City-"; dtCity.Rows.InsertAt(newRowCity, 0); dtCity.AcceptChanges(); objVendorDetail.City = new CommonObjects[dtCity.Rows.Count]; intCount = 0; foreach (DataRow drw in dtCity.Rows) { objVendorDetail.City[intCount] = new CommonObjects(); objVendorDetail.City[intCount].Value = drw["alias"].ToString(); objVendorDetail.City[intCount].Text = drw["nama_kota"].ToString(); objVendorDetail.City[intCount].DefaultValue = VendorId != 0 ? objMainRow[0]["alias_kota"].ToString() : objVendorDetail.City[0].Value; intCount++; } objVendorDetail.VendorsName = VendorId != 0 ? objMainRow[0]["nama_vendors"].ToString() : ""; objVendorDetail.VendorsAlias = VendorId != 0 ? objMainRow[0]["alias_vendors"].ToString() : ""; objVendorDetail.VendorsAddress = VendorId != 0 ? objMainRow[0]["alias_vendors"].ToString() : ""; objVendorDetail.Phone = VendorId != 0 ? objMainRow[0]["tlp_vendors"].ToString() : ""; objVendorDetail.Email = VendorId != 0 ? objMainRow[0]["email_vendors"].ToString() : ""; objVendorDetail.ImageUrl = VendorId != 0 ? "../"+objMainRow[0]["logo_vendors"].ToString() : ""; objVendorDetail.BannerUrl = VendorId != 0 ? "../"+objMainRow[0]["banner_vendors"].ToString() : ""; return objVendorDetail; }