public int SaveSliderItem(SliderItem item)
{
SliderDL sliderDL = new SliderDL();
return sliderDL.SaveSliderItem(item);
}
public int SaveSliderItem(SliderItem item)
{
int status = 0;
using (SqlConnection objConn = new SqlConnection(WebConfigurationManager.ConnectionStrings["eshopConnectionString"].ConnectionString))
{
using (SqlCommand objComm = new SqlCommand("saveSliderItem", objConn))
{
objConn.Open();
objComm.CommandType = CommandType.StoredProcedure;
objComm.Parameters.Add("@sliderID", SqlDbType.Int).Value = item.SliderID;
objComm.Parameters.Add("@imageUrl", SqlDbType.NVarChar, 50).Value = item.ImageUrl;
objComm.Parameters.Add("@sortIndex", SqlDbType.Int).Value = item.SortIndex;
objComm.Parameters.Add("@url", SqlDbType.NVarChar, 50).Value = item.Url;
status = objComm.ExecuteNonQuery();
}
}
return status;
}
