public bool CategorysInfo_Update(CategorysInfo data)
{
using (SqlCommand dbCmd = new SqlCommand("Banner_Update", GetConnection()))
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@CategoryID", data.CategoryID));
dbCmd.Parameters.Add(new SqlParameter("@Tag", data.Tag));
dbCmd.Parameters.Add(new SqlParameter("@Name", data.Name));
dbCmd.Parameters.Add(new SqlParameter("@Content", data.Content));
dbCmd.Parameters.Add(new SqlParameter("@Level", data.Level));
dbCmd.Parameters.Add(new SqlParameter("@Priority", data.Priority));
dbCmd.Parameters.Add(new SqlParameter("@Index", data.Index));
dbCmd.Parameters.Add(new SqlParameter("@Title", data.Title));
dbCmd.Parameters.Add(new SqlParameter("@Description", data.Description));
dbCmd.Parameters.Add(new SqlParameter("@Keyword", data.Keyword));
dbCmd.Parameters.Add(new SqlParameter("@Active", data.Active));
dbCmd.Parameters.Add(new SqlParameter("@Ord", data.Ord));
dbCmd.Parameters.Add(new SqlParameter("@Lang", data.Lang));
dbCmd.Parameters.Add(new SqlParameter("@Image", data.Image));
dbCmd.Parameters.Add(new SqlParameter("@Image2", data.Image2));
dbCmd.ExecuteNonQuery();
}
//Clear cache
System.Web.HttpContext.Current.Cache.Remove("CategorysInfo");
return(true);
}
public CategorysInfo CategorysInfoIDataReader(IDataReader dr)
{
CategorysInfo obj = new CategorysInfo();
obj.CategoryID = (dr["CategoryID"] is DBNull) ? string.Empty : dr["CategoryID"].ToString();
obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString();
obj.Level = (dr["Level"] is DBNull) ? string.Empty : dr["Level"].ToString();
obj.Priority = (dr["Priority"] is DBNull) ? string.Empty : dr["Priority"].ToString();
obj.Index = (dr["Index"] is DBNull) ? string.Empty : dr["Index"].ToString();
obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.Keyword = (dr["Keyword"] is DBNull) ? string.Empty : dr["Keyword"].ToString();
obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString();
obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString();
obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString();
obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString();
obj.Image2 = (dr["Image2"] is DBNull) ? string.Empty : dr["Image2"].ToString();
return(obj);
}
