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);
}
