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;
}
