public string GetNote() { var note = new NotesNHibernate(); return("Hello World"); }
public Address SaveAddress(string addressType, string line1, string line2, string city, string st, string zip, string begDate) { var note = new NotesNHibernate(); Address result = new Address(); if (PortalUser.Current.IsGuest) { result.Success = false; result.Message = "You do not have permissions to this resource."; return(result); } OdbcConnectionClass3 odbcConn = new OdbcConnectionClass3("ERPDataConnection.config"); string insertAddressSql = @"S insert into CUS_Addresses5 (ID_Number, Addr_Code, Addr_Line1, Addr_Line2, City, State, Zip, BeginDate) values (?,?,?,?,?,?,?,?)" ; Exception ex = null; List <OdbcParameter> parameters = new List <OdbcParameter> { new OdbcParameter("id", PortalUser.Current.HostID), new OdbcParameter("Addr_code", addressType), new OdbcParameter("addrLine1", line1), new OdbcParameter("addrLine2", line2), new OdbcParameter("city", city), new OdbcParameter("state", st), new OdbcParameter("zip", zip), new OdbcParameter("begdate", begDate), }; odbcConn.ConnectToERP(insertAddressSql, ref ex, parameters); if (ex != null) { result.Message = ex.Message; result.Success = false; result.Value = "Failed to add address records"; } else { result.Success = true; result.UserId = PortalUser.Current.HostID; result.Line1 = line1; result.Line2 = line2; result.City = city; result.State = st; result.Zip = zip; result.BeginDate = begDate; result.AddressType = addressType; result.Message = "Successfully added address record!"; } return(result); }
protected void ArchiveNote(NotesNHibernate originalNote) { // var notesArchiveService = new NotesArchiveMapperService(); // var note = new NotesArchiveNHibernate(); // var nHibernateSession = new NHibernateFactory().GetSessionFactory().OpenSession(); // note = new NotesArchiveNHibernate // { // NOTE_ID = originalNote.NOTE_ID, // FAC_APPID = originalNote.FAC_APPID, // FAC_ID_NUM = originalNote.FAC_ID_NUM, // SM_APPID = originalNote.SM_APPID, // CRS_CDE = originalNote.CRS_CDE, // CRS_TITLE = originalNote.CRS_TITLE, // DIV_CDE = originalNote.DIV_CDE, // INSTIT_DIV_CDE = originalNote.INSTIT_DIV_CDE, // SCHOOL_CDE = originalNote.SCHOOL_CDE, // YEARCODE = originalNote.YEARCODE, // TERMCODE = originalNote.TERMCODE , // SUBJECT = originalNote.SUBJECT, // STATUS = originalNote.STATUS, // NOTE = originalNote.NOTE, // NOTE_TYPE = originalNote.NOTE_TYPE, // NOTE_LEVEL = originalNote.NOTE_LEVEL, // FAC_TYPE = originalNote.FAC_TYPE, // APPROVAL_DATE = originalNote.APPROVAL_DATE, // EXPIRATION_DATE = originalNote.EXPIRATION_DATE, // CREATE_BY = originalNote.CREATE_BY, // CREATE_DATE = originalNote.CREATE_DATE, // UPDATE_BY = originalNote.UPDATE_BY, // UPDATE_DATE = originalNote.UPDATE_DATE // }; // try // { // using (var transaction = nHibernateSession.BeginTransaction()) // { // nHibernateSession.SaveOrUpdate(note); // transaction.Commit(); // ParentPortlet.ShowFeedback(FeedbackType.Success, "Note Successfully Archived!"); // } // clear out the edit screen for the next record DateTime theDate = DateTime.Now; DateTime yearLater = theDate.AddYears(1); ParentPortlet.Session["EditId"] = null; ddl_Note_Types.SelectedValue = "0"; ddl_Note_levels.SelectedValue = "0"; txt_Subject.Text = ""; txtNote.InnerText = ""; ddl_Status_codes.SelectedValue = "A"; dp_Approval_Date.SelectedDate = DateTime.Now; dp_Expiration_Date.SelectedDate = yearLater; ParentPortlet.Session.Remove("EditId"); LoadNotes(); // } // catch (Exception exception) // { // var msg = PortalUser.Current.IsSiteAdmin // ? "This note was not Archived! Error: " + exception.Message // : "This note was not Archived! Sorry!"; // this.ParentPortlet.ShowFeedback(FeedbackType.Error, msg); // ExceptionManager.Publish(exception); // return; // } // finally // { // nHibernateSession.Close(); // } }