public DataTable DALItemSelectedByCategory(UISearchBLL usb)
{
List <UISearchBLL> usbList = new List <UISearchBLL>();
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@actegoryId", usb.categoryId);
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spSearchItemSelectByCategoryId", par);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(ds.Tables[0]);
}
public void LoadItemDescription(UISearchBLL usb)
{
DataTable dt = itBLLObj.BLLGetSelectedItem(itBLLObj);
lblItemName.Text = Convert.ToString(dt.Rows[0]["ItemName"]); // itBLLObj.itemName;
lblItemDescription.Text = Convert.ToString(dt.Rows[0]["ItemDescription"]); //itBLLObj.itemDescription;
DataTable dtItemDescription = usBLLObj.BLLItemDescription(usb);
gvItemDisplay.DataSource = dtItemDescription;
gvItemDisplay.DataBind();
Session["itemDiscription"] = dtItemDescription;
DataTable dtItemDescriptionImage = usBLLObj.BLLItemDescriptionImageDisplay(usb);
if (dtItemDescriptionImage.Rows.Count > 0)
{
DataRow dtRowImage = dtItemDescriptionImage.Rows[0];
imageSet = Convert.ToInt32(Convert.ToString(dtRowImage["imageSet"]));
if (imageSet == 0)
{
gvImageSet1.DataSource = dtItemDescriptionImage;
gvImageSet1.DataBind();
}
else if (imageSet == 1)
{
gvImageSet2.DataSource = dtItemDescriptionImage;
gvImageSet2.DataBind();
}
else if (imageSet == 2)
{
gvImageSet3.DataSource = dtItemDescriptionImage;
gvImageSet3.DataBind();
}
}
else
{
imageSet = 9;
}
}
public DataTable DALItemDescriptionDisplay(UISearchBLL ct)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[2];
par[0] = new SqlParameter("@itemId", ct.itemId);
par[1] = new SqlParameter("@categoryId", ct.categoryId);
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spItemDescriptionSelect", par);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(ds.Tables[0]);
}
public DataTable BLLItemDescriptionImageDisplay(UISearchBLL usb)
{
DataTable dtItemImageDisplay = usDALObj.DALItemDescriptionImageDisplay(usb);
return(dtItemImageDisplay);
}
public DataTable BLLTotalRecordNo(UISearchBLL usb)
{
DataTable dtTotalRecordNo = usDALObj.DALCitySelectedById(usb);
return(dtTotalRecordNo);
}
public DataTable BLLCategoryByCity(UISearchBLL usb)
{
DataTable dtCategoryByCity = usDALObj.DALCategorySelectedByCity(usb);
return(dtCategoryByCity);
}
public DataTable BLLSearchItem(UISearchBLL usb)
{
DataTable dtSearchItem = usDALObj.DALCitySelectedById(usb);
return(dtSearchItem);
}
