public ImgType ImagesTypeIDataReader(IDataReader dr) { Data.ImgType obj = new Data.ImgType(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Code = (dr["Code"] is DBNull) ? string.Empty : dr["Code"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); return(obj); }
public List <ImgType> ImgType_GetByAll() { List <Data.ImgType> list = new List <Data.ImgType>(); using (SqlCommand dbCmd = new SqlCommand("sp_ImgType_GetByAll", GetConnection())) { Data.ImgType obj = new Data.ImgType(); dbCmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ImagesTypeIDataReader(dr)); } } dr.Close(); obj = null; } return(list); }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.ImgType obj = new Data.ImgType(); obj.Id = Id; obj.Name = txtName.Text; obj.Code = txtCode.Text; obj.Active = chkActive.Checked ? "1" : "0"; if (Insert == true) { ImgTypeBUS.ImgType_Insert(obj); } else { ImgTypeBUS.ImgType_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
public List <ImgType> ImgType_GetByTop(string Top, string Where, string Order) { List <Data.ImgType> list = new List <Data.ImgType>(); using (SqlCommand dbCmd = new SqlCommand("sp_ImgType_GetByTop", GetConnection())) { Data.ImgType obj = new Data.ImgType(); 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.ImagesTypeIDataReader(dr)); } } dr.Close(); obj = null; } return(list); }
public static bool ImgType_Update(Data.ImgType data) { return(db.ImgType_Update(data)); }
public static bool ImgType_Insert(Data.ImgType data) { return(db.ImgType_Insert(data)); }