public List <ImagesDetail> ImagesDetail_GetByTop(string Top, string Where, string Order) { List <Data.ImagesDetail> list = new List <Data.ImagesDetail>(); using (SqlCommand dbCmd = new SqlCommand("sp_ImagesDetail_GetByTop", GetConnection())) { Data.ImagesDetail obj = new Data.ImagesDetail(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ImageInfoIDataReader(dr)); } //conn.Close(); } dr.Close(); obj = null; } return(list); }
public ImagesDetail ImageInfoIDataReader(IDataReader dr) { Data.ImagesDetail obj = new Data.ImagesDetail(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString(); obj.ImageId = (dr["ImagesId"] is DBNull) ? string.Empty : dr["ImagesId"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.Summary = (dr["Summary"] is DBNull) ? string.Empty : dr["Summary"].ToString(); return(obj); }
public bool ImagesDetail_Insert(Data.ImagesDetail obj) { using (SqlCommand dbCmd = new SqlCommand("sp_ImagesDetail_Insert", GetConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Name", obj.Name)); dbCmd.Parameters.Add(new SqlParameter("@Image", obj.Image)); dbCmd.Parameters.Add(new SqlParameter("@ImagesId", obj.ImageId)); dbCmd.Parameters.Add(new SqlParameter("@Active", obj.Active)); dbCmd.Parameters.Add(new SqlParameter("@Summary", obj.Summary)); dbCmd.ExecuteNonQuery(); } System.Web.HttpContext.Current.Cache.Remove("Images"); // clear server cache return(true); }
public List <Data.ImagesDetail> ImageDetail_GetByAll() { List <Data.ImagesDetail> list = new List <ImagesDetail>(); using (SqlCommand dbCmd = new SqlCommand("sp_ImagesDetail_GetByAll", GetConnection())) { Data.ImagesDetail obj = new Data.ImagesDetail(); dbCmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ImageInfoIDataReader(dr)); } } dr.Close(); obj = null; } return(list); }
public List <Data.ImagesDetail> ImageDetail_GetById(string id) { List <Data.ImagesDetail> listImageDetail = new List <Data.ImagesDetail>(); using (SqlCommand dbCmd = new SqlCommand("sp_ImagesDetail_GetById", GetConnection())) { Data.ImagesDetail obj = new Data.ImagesDetail(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Id", id)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { listImageDetail.Add(obj.ImageInfoIDataReader(dr)); } } dr.Close(); obj = null; } return(listImageDetail); }
public static bool ImagesDetail_Update(Data.ImagesDetail obj) { return(db.ImagesDetail_Update(obj)); }
public static bool ImagesDetail_Insert(Data.ImagesDetail obj) { return(db.ImagesDetail_Insert(obj)); }