Esempio n. 1
0
        protected override void DataPortal_Update()
        {
            SimpleAuditTrail();
            var dto = new OutgoingRegisterDto();

            dto.RegisterId        = RegisterId;
            dto.RegisterDate      = ReadProperty(RegisterDateProperty);
            dto.DocumentType      = DocumentType;
            dto.DocumentReference = DocumentReference;
            dto.DocumentEntity    = DocumentEntity;
            dto.DocumentDept      = DocumentDept;
            dto.DocumentClass     = DocumentClass;
            dto.DocumentDate      = ReadProperty(DocumentDateProperty);
            dto.Subject           = Subject;
            dto.SendDate          = ReadProperty(SendDateProperty);
            dto.RecipientName     = RecipientName;
            dto.RecipientTown     = RecipientTown;
            dto.Notes             = Notes;
            dto.ArchiveLocation   = ArchiveLocation;
            dto.ChangeDate        = ChangeDate;
            using (var dalManager = DalFactoryInterwayDocs.GetManager())
            {
                var args = new DataPortalHookArgs(dto);
                OnUpdatePre(args);
                var dal = dalManager.GetProvider <IOutgoingRegisterDal>();
                using (BypassPropertyChecks)
                {
                    var resultDto = dal.Update(dto);
                    args = new DataPortalHookArgs(resultDto);
                }
                OnUpdatePost(args);
            }
        }
Esempio n. 2
0
        private OutgoingRegisterDto Fetch(IDataReader data)
        {
            var outgoingRegister = new OutgoingRegisterDto();

            using (var dr = new SafeDataReader(data))
            {
                if (dr.Read())
                {
                    outgoingRegister.RegisterId        = dr.GetInt32("RegisterId");
                    outgoingRegister.RegisterDate      = dr.GetSmartDate("RegisterDate", true);
                    outgoingRegister.DocumentType      = dr.GetString("DocumentType");
                    outgoingRegister.DocumentReference = dr.GetString("DocumentReference");
                    outgoingRegister.DocumentEntity    = dr.GetString("DocumentEntity");
                    outgoingRegister.DocumentDept      = dr.GetString("DocumentDept");
                    outgoingRegister.DocumentClass     = dr.GetString("DocumentClass");
                    outgoingRegister.DocumentDate      = dr.GetSmartDate("DocumentDate", true);
                    outgoingRegister.Subject           = dr.GetString("Subject");
                    outgoingRegister.SendDate          = dr.GetSmartDate("SendDate", true);
                    outgoingRegister.RecipientName     = dr.GetString("RecipientName");
                    outgoingRegister.RecipientTown     = dr.GetString("RecipientTown");
                    outgoingRegister.Notes             = dr.GetString("Notes");
                    outgoingRegister.ArchiveLocation   = dr.GetString("ArchiveLocation");
                    outgoingRegister.CreateDate        = dr.GetSmartDate("CreateDate", true);
                    outgoingRegister.ChangeDate        = dr.GetSmartDate("ChangeDate", true);
                }
            }
            return(outgoingRegister);
        }
Esempio n. 3
0
 /// <summary>
 /// Inserts a new OutgoingRegister object in the database.
 /// </summary>
 /// <param name="outgoingRegister">The Outgoing Register DTO.</param>
 /// <returns>The new <see cref="OutgoingRegisterDto"/>.</returns>
 public OutgoingRegisterDto Insert(OutgoingRegisterDto outgoingRegister)
 {
     using (var ctx = ConnectionManager <SqlConnection> .GetManager("InterwayDocs"))
     {
         using (var cmd = new SqlCommand("dbo.AddOutgoingRegister", ctx.Connection))
         {
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@RegisterId", outgoingRegister.RegisterId).Direction            = ParameterDirection.Output;
             cmd.Parameters.AddWithValue("@RegisterDate", outgoingRegister.RegisterDate.DBValue).DbType   = DbType.Date;
             cmd.Parameters.AddWithValue("@DocumentType", outgoingRegister.DocumentType).DbType           = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentReference", outgoingRegister.DocumentReference).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentEntity", outgoingRegister.DocumentEntity).DbType       = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentDept", outgoingRegister.DocumentDept).DbType           = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentClass", outgoingRegister.DocumentClass).DbType         = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentDate", outgoingRegister.DocumentDate.DBValue).DbType   = DbType.Date;
             cmd.Parameters.AddWithValue("@Subject", outgoingRegister.Subject).DbType             = DbType.String;
             cmd.Parameters.AddWithValue("@SendDate", outgoingRegister.SendDate.DBValue).DbType   = DbType.Date;
             cmd.Parameters.AddWithValue("@RecipientName", outgoingRegister.RecipientName).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@RecipientTown", outgoingRegister.RecipientTown).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@Notes", outgoingRegister.Notes).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@ArchiveLocation", outgoingRegister.ArchiveLocation).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@CreateDate", outgoingRegister.CreateDate.DBValue).DbType   = DbType.DateTime2;
             cmd.Parameters.AddWithValue("@ChangeDate", outgoingRegister.ChangeDate.DBValue).DbType   = DbType.DateTime2;
             cmd.ExecuteNonQuery();
             outgoingRegister.RegisterId = (int)cmd.Parameters["@RegisterId"].Value;
         }
     }
     return(outgoingRegister);
 }
Esempio n. 4
0
 /// <summary>
 /// Updates in the database all changes made to the OutgoingRegister object.
 /// </summary>
 /// <param name="outgoingRegister">The Outgoing Register DTO.</param>
 /// <returns>The updated <see cref="OutgoingRegisterDto"/>.</returns>
 public OutgoingRegisterDto Update(OutgoingRegisterDto outgoingRegister)
 {
     using (var ctx = ConnectionManager <SqlConnection> .GetManager("InterwayDocs"))
     {
         using (var cmd = new SqlCommand("dbo.UpdateOutgoingRegister", ctx.Connection))
         {
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@RegisterId", outgoingRegister.RegisterId).DbType               = DbType.Int32;
             cmd.Parameters.AddWithValue("@RegisterDate", outgoingRegister.RegisterDate.DBValue).DbType   = DbType.Date;
             cmd.Parameters.AddWithValue("@DocumentType", outgoingRegister.DocumentType).DbType           = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentReference", outgoingRegister.DocumentReference).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentEntity", outgoingRegister.DocumentEntity).DbType       = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentDept", outgoingRegister.DocumentDept).DbType           = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentClass", outgoingRegister.DocumentClass).DbType         = DbType.String;
             cmd.Parameters.AddWithValue("@DocumentDate", outgoingRegister.DocumentDate.DBValue).DbType   = DbType.Date;
             cmd.Parameters.AddWithValue("@Subject", outgoingRegister.Subject).DbType             = DbType.String;
             cmd.Parameters.AddWithValue("@SendDate", outgoingRegister.SendDate.DBValue).DbType   = DbType.Date;
             cmd.Parameters.AddWithValue("@RecipientName", outgoingRegister.RecipientName).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@RecipientTown", outgoingRegister.RecipientTown).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@Notes", outgoingRegister.Notes).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@ArchiveLocation", outgoingRegister.ArchiveLocation).DbType = DbType.String;
             cmd.Parameters.AddWithValue("@ChangeDate", outgoingRegister.ChangeDate.DBValue).DbType   = DbType.DateTime2;
             var rowsAffected = cmd.ExecuteNonQuery();
             if (rowsAffected == 0)
             {
                 throw new DataNotFoundException("OutgoingRegister");
             }
         }
     }
     return(outgoingRegister);
 }
Esempio n. 5
0
        /// <summary>
        /// Loads a <see cref="OutgoingRegister"/> object from the given <see cref="OutgoingRegisterDto"/>.
        /// </summary>
        /// <param name="data">The OutgoingRegisterDto to use.</param>
        private void Fetch(OutgoingRegisterDto data)
        {
            // Value properties
            LoadProperty(RegisterIdProperty, data.RegisterId);
            LoadProperty(RegisterDateProperty, data.RegisterDate);
            LoadProperty(DocumentTypeProperty, data.DocumentType);
            LoadProperty(DocumentReferenceProperty, data.DocumentReference);
            LoadProperty(DocumentEntityProperty, data.DocumentEntity);
            LoadProperty(DocumentDeptProperty, data.DocumentDept);
            LoadProperty(DocumentClassProperty, data.DocumentClass);
            LoadProperty(DocumentDateProperty, data.DocumentDate);
            LoadProperty(SubjectProperty, data.Subject);
            LoadProperty(SendDateProperty, data.SendDate);
            LoadProperty(RecipientNameProperty, data.RecipientName);
            LoadProperty(RecipientTownProperty, data.RecipientTown);
            LoadProperty(NotesProperty, data.Notes);
            LoadProperty(ArchiveLocationProperty, data.ArchiveLocation);
            LoadProperty(CreateDateProperty, data.CreateDate);
            LoadProperty(ChangeDateProperty, data.ChangeDate);
            var args = new DataPortalHookArgs(data);

            OnFetchRead(args);
        }