private IImage GetImageFomDataRow(DataRow drImage) { IImage image = new MyDiary.Domain.Domains.Image(null); foreach (DataColumn dc in drImage.Table.Columns) { switch (dc.ColumnName) { case Constants.StoredProcedures.Image.Fields.IMAGE: image.UserImage = (byte[])(drImage[Constants.StoredProcedures.Image.Fields.IMAGE]); break; } } return(image); }
public IImage GetUploadImageById(int imageId) { IImage uploadImage = new MyDiary.Domain.Domains.Image(null); SqlConnection conn = SQLDbConnection.GetNewSqlConnectionObject(); conn.Open(); SqlCommand cmd = SQLDbConnection.GetNewSqlCommandObject(conn, Constants.StoredProcedures.Image.Image_SelectById); cmd.Parameters.AddWithValue(Constants.StoredProcedures.Image.Parameters.ImageId, imageId); DataTable dtUploadImage = SQLDbConnection.FillDataSetFromDataAdapter(SQLDbConnection.GetNewSqlDataAdapterObject(cmd)); if (dtUploadImage != null && dtUploadImage.Rows.Count > 0) { uploadImage = GetImageFromDataTable(dtUploadImage); } return(uploadImage); }