public int DALIsExistMainItemCategoryImage(ItemCategoryImageBLL ici)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[3];
par[0] = new SqlParameter("@itemId", ici.itemId);
par[1] = new SqlParameter("@categoryId", ici.categoryId);
par[2] = new SqlParameter("@Status", 11);
par[2].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spItemCategoryImageIfExistsMain", par);
status = (int)par[2].Value;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(status);
}
public int DALItemCategoryImageInsert(ItemCategoryImageBLL ici)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[9];
par[0] = new SqlParameter("@imageSetType", ici.imageSetType);
par[1] = new SqlParameter("@imageName", ici.imageName);
par[2] = new SqlParameter("@imageDescription", ici.imageDescription);
par[3] = new SqlParameter("@itemId", ici.itemId);
par[4] = new SqlParameter("@categoryId", ici.categoryId);
par[5] = new SqlParameter("@image1", ici.image1);
par[6] = new SqlParameter("@image2", ici.image2);
par[7] = new SqlParameter("@image3", ici.image3);
par[8] = new SqlParameter("@Status", 11);
par[8].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spItemCategoryImageInsert", par);
status = (int)par[8].Value;
}
catch (Exception ex)
{
throw ex;
}
}
return(status);
}
public int BLLIsExistsMainItemCategoryImage(ItemCategoryImageBLL ici)
{
status = iciDALObj.DALIsExistMainItemCategoryImage(ici);
return(status);
}
public int BLLItemCategoryImageSet(ItemCategoryImageBLL ici)
{
status = iciDALObj.DALItemCategoryImageSet(ici);
return(status);
}
public void BLLIsExistsItemCategoryImage(ItemCategoryImageBLL ici, out int status, out int imgId)
{
iciDALObj.DALIsExistItemCategoryImage(ici, out status, out imgId);
}
