protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.Images obj = new Data.Images(); obj.Id = Id; obj.Image = txtImage.Text; obj.GroupId = ddlGroupImage.SelectedValue; obj.Priority = "0"; obj.Language = ddlLanguage.SelectedValue; obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Active = chkActive.Checked ? "1" : "0"; if (Insert == true) { ImagesService.Images_Insert(obj); } else { ImagesService.Images_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
public Images ImagesIDataReader(IDataReader dr) { Data.Images obj = new Data.Images(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.Thumbnail = (dr["Thumbnail"] is DBNull) ? string.Empty : dr["Thumbnail"].ToString(); obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString(); obj.GroupId = (dr["GroupId"] is DBNull) ? string.Empty : dr["GroupId"].ToString(); obj.Priority = (dr["Priority"] is DBNull) ? string.Empty : dr["Priority"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); return(obj); }
public List <Images> Images_GetByTop(string Top, string Where, string Order) { List <Data.Images> list = new List <Data.Images>(); Data.Images obj = new Data.Images(); SqlDataReader dr = null; try { using (SqlCommand dbCmd = new SqlCommand("sp_Images_GetByTop", GetConnection())) { 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)); dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ImagesIDataReader(dr)); } //conn.Close(); } } } catch (Exception) { } finally { if (dr != null) { dr.Close(); } obj = null; } return(list); }
public List <Images> Images_GetByAll() { List <Data.Images> list = new List <Data.Images>(); Data.Images obj = new Data.Images(); SqlDataReader dr = null; try { using (SqlCommand dbCmd = new SqlCommand("sp_Images_GetByAll", GetConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ImagesIDataReader(dr)); } //conn.Close(); } } } catch (Exception) { } finally { if (dr != null) { dr.Close(); } obj = null; } return(list); }