コード例 #1
0
        public string GetNote()
        {
            var note = new NotesNHibernate();



            return("Hello World");
        }
コード例 #2
0
ファイル: ERPService.asmx.cs プロジェクト: davebhub/FacCred
        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);
        }
コード例 #3
0
        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();
            //    }
        }