public byte[] GetImageFromDB()
{
MainDatabaseSourceDataContext dbContext = new MainDatabaseSourceDataContext();
MyConstantInfo myConstantInfo = new MyConstantInfo();
myConstantInfo = dbContext.MyConstantInfos.Single(p => p.ID == 1);
return(myConstantInfo.MyImage.ToArray());
}
public void UpdateMyImage()
{
MainDatabaseSourceDataContext dbContext = new MainDatabaseSourceDataContext();
MyConstantInfo myConstantInfo = new MyConstantInfo();
string ImageStringName = SelectImageToBeSaved();
if (!string.IsNullOrEmpty(ImageStringName))
{
this.constInfoModel.MyImage = File.ReadAllBytes(ImageStringName);
//using UploadImage stored procedure
dbContext.UploadImage(this.constInfoModel.MyImage);
UpdateImageSource();
}
}
public void SaveMethod()
{
MainDatabaseSourceDataContext dbContext = new MainDatabaseSourceDataContext();
MyConstantInfo myConstantInfo = new MyConstantInfo();
/*string ImageStringName = SelectImageToBeSaved();
* if (!string.IsNullOrEmpty(ImageStringName))
* {
* this.constInfoModel.MyImage = File.ReadAllBytes(ImageStringName);
* //using UploadImage stored procedure
* dbContext.UploadImage(this.constInfoModel.MyImage);
* }
*/
// --- to be able to update
myConstantInfo = dbContext.MyConstantInfos.Single(p => p.ID == 1);
myConstantInfo.MYINFO = this.constInfoModel.InfoString;
myConstantInfo.more = this.constInfoModel.MoreInfoe;
myConstantInfo.myDate = this.constInfoModel.InfoDate;
dbContext.SubmitChanges();
MessageBox.Show("Informations has been saved.");
}
