public static CommonObjects[] GetCity(string ProvinceId)
{
Vendors objVendors=new Vendors();
DataTable dtCity = objVendors.GetCityForProvince(ProvinceId);
DataRow newRowCity = dtCity.NewRow();
newRowCity["alias"] = "-1";
newRowCity["nama_kota"] = "-City-";
dtCity.Rows.InsertAt(newRowCity, 0);
dtCity.AcceptChanges();
CommonObjects[] objCity = new CommonObjects[dtCity.Rows.Count];
int intCount = 0;
foreach (DataRow drw in dtCity.Rows)
{
objCity[intCount] = new CommonObjects();
objCity[intCount].Value = drw["alias"].ToString();
objCity[intCount].Text = drw["nama_kota"].ToString();
objCity[intCount].DefaultValue = objCity[0].Value;
intCount++;
}
return objCity;
}
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;
}