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 = ""; //} }