public ExhibitViewModel(UserInformation userInformation)
{
UserInformation user = (UserInformation)App.Current.Properties["userinfo"];
userinformation = user;
exhit = new ExhitbitMaster(userinformation);
// this.ExhitbitDocs = exhit.getExhibitDocuments();
this.DtDataview = exhit.GetExhibitMaster();
LoadFormData();
this.clearExhibitCommand = new DelegateCommand(this.ClearExhibit);
this.updateExhibitCommand = new DelegateCommand(this.UpdateExhibit);
this.selectChangeComboCommand = new DelegateCommand(this.SelectDataRow);
ExhibitDetails = "";
ExhibitNumber = "";
}
private void UpdateExhibit()
{
if (String.IsNullOrEmpty(ExhibitDetails))
{
//Message = "Please select Exhibit Document.";
Message = PDMsg.NotEmpty("Exhibit Document");
}
else if (String.IsNullOrEmpty(ExhibitNumber.Trim()))
{
//Message = "Please enter Exhibit Number.";
Message = PDMsg.NotEmpty("Exhibit Number");
}
else
{
bool val = exhit.updateExhitbitMaster(ExhibitNumber, ExhibitDetails);
if (val)
{
Message = PDMsg.UpdatedSuccessfully;
ClearExhibit();
this.DtDataview = exhit.GetExhibitMaster();
LoadFormData();
}
}
//string query = "UPDATE [EXHIBIT_DOC] set [EX_NO]='" + ExhibitNumber + "' WHERE [DOC_NAME]='" + ExhibitDetails + "'";
//IEnumerable<int> result = userinformation.Dal.SFLPDDatabase.ExecuteQuery<int>(query);
//MessageBox.Show("Exhibit Updated");
//Message = "Exhibit Updated";
//using (SFLPD db = new SFLPD(userinformation.Dal.SFLPDDatabase.Connection))
//{
// IEnumerable<int> result = db.ExecuteQuery<int>(query);
// //var exhibit = (from e in db.EXHIBIT_DOC where e.DOC_NAME == ExhibitDetails select e).FirstOrDefault();
// //exhibit.EX_NO = ExhibitNumber;
// //db.SubmitChanges();
// ExhibitDetails = "";
// ExhibitNumber = "";
//}
}
