public int SaveCategoryBanner(CategoryBanner categoryBanner)
{
if (categoryBanner.CategoryBannerID <= 0)
return new CategoryBannerDL().SaveCategoryBanner(categoryBanner);
else
return new CategoryBannerDL().UpdateCategoryBanner(categoryBanner);
}
public CategoryBanner GetCategoryBanner(int categoryBannerID)
{
CategoryBanner categoryBanner = null;
using (SqlConnection objConn = new SqlConnection(WebConfigurationManager.ConnectionStrings["eshopConnectionString"].ConnectionString))
{
using (SqlCommand objComm = new SqlCommand("categoryBanner_select", objConn))
{
objConn.Open();
objComm.CommandType = CommandType.StoredProcedure;
objComm.Parameters.Add("@categoryBannerID", SqlDbType.Int).Value = categoryBannerID;
using (SqlDataReader reader = objComm.ExecuteReader())
{
while (reader.Read())
{
categoryBanner = new CategoryBanner();
categoryBanner.CategoryBannerID = categoryBannerID;
categoryBanner.Name = reader.GetString(0);
categoryBanner.ImageUrl = reader.GetString(1);
categoryBanner.Url = reader.GetString(2);
}
}
}
}
return categoryBanner;
}
public int SaveCategoryBanner(CategoryBanner categoryBanner)
{
int status = 0;
using (SqlConnection objConn = new SqlConnection(WebConfigurationManager.ConnectionStrings["eshopConnectionString"].ConnectionString))
{
using (SqlCommand objComm = new SqlCommand("categoryBanner_insert", objConn))
{
objConn.Open();
objComm.CommandType = CommandType.StoredProcedure;
objComm.Parameters.Add("@name", SqlDbType.NVarChar, 50).Value = categoryBanner.Name;
objComm.Parameters.Add("@imageUrl", SqlDbType.NVarChar, 50).Value = categoryBanner.ImageUrl;
objComm.Parameters.Add("@url", SqlDbType.NVarChar, 100).Value = categoryBanner.Url;
status = int.Parse(objComm.ExecuteScalar().ToString());
}
}
return status;
}
public int UpdateCategoryBanner(CategoryBanner categoryBanner)
{
int status = 0;
using (SqlConnection objConn = new SqlConnection(WebConfigurationManager.ConnectionStrings["eshopConnectionString"].ConnectionString))
{
using (SqlCommand objComm = new SqlCommand("categoryBanner_update", objConn))
{
objConn.Open();
objComm.CommandType = CommandType.StoredProcedure;
objComm.Parameters.Add("@name", SqlDbType.NVarChar, 50).Value = categoryBanner.Name;
objComm.Parameters.Add("@imageUrl", SqlDbType.NVarChar, 50).Value = categoryBanner.ImageUrl;
objComm.Parameters.Add("@url", SqlDbType.NVarChar).Value = categoryBanner.Url;
objComm.Parameters.Add("@categoryBannerID", SqlDbType.Int).Value = categoryBanner.CategoryBannerID;
status = objComm.ExecuteNonQuery();
}
}
return status;
}
private void saveCategoryBanner()
{
try
{
CategoryBanner categoryBanner = new CategoryBanner();
categoryBanner.Name = txtCategoryBannerName.Text;
categoryBanner.ImageUrl = imgCategoryBanner.ImageUrl.Substring(imgCategoryBanner.ImageUrl.LastIndexOf("/") + 1);
categoryBanner.Url = txtUrl.Text;
if (lblCategoryBannerID.Value != string.Empty)
categoryBanner.CategoryBannerID = int.Parse(lblCategoryBannerID.Value);
categoryBanner.CategoryBannerID = new CategoryBannerBL().SaveCategoryBanner(categoryBanner);
lblCategoryBannerID.Value = categoryBanner.CategoryBannerID.ToString();
}
catch (Exception ex)
{
setStatus(ex.Message, System.Drawing.Color.Red, true);
}
}