protected override void DataPortal_Update() { SimpleAuditTrail(); var dto = new IncomingRegisterDto(); 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.SenderName = SenderName; dto.ReceptionDate = ReadProperty(ReceptionDateProperty); dto.RoutedTo = RoutedTo; 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 <IIncomingRegisterDal>(); using (BypassPropertyChecks) { var resultDto = dal.Update(dto); args = new DataPortalHookArgs(resultDto); } OnUpdatePost(args); } }
private IncomingRegisterDto Fetch(IDataReader data) { var incomingRegister = new IncomingRegisterDto(); using (var dr = new SafeDataReader(data)) { if (dr.Read()) { incomingRegister.RegisterId = dr.GetInt32("RegisterId"); incomingRegister.RegisterDate = dr.GetSmartDate("RegisterDate", true); incomingRegister.DocumentType = dr.GetString("DocumentType"); incomingRegister.DocumentReference = dr.GetString("DocumentReference"); incomingRegister.DocumentEntity = dr.GetString("DocumentEntity"); incomingRegister.DocumentDept = dr.GetString("DocumentDept"); incomingRegister.DocumentClass = dr.GetString("DocumentClass"); incomingRegister.DocumentDate = dr.GetSmartDate("DocumentDate", true); incomingRegister.Subject = dr.GetString("Subject"); incomingRegister.SenderName = dr.GetString("SenderName"); incomingRegister.ReceptionDate = dr.GetSmartDate("ReceptionDate", true); incomingRegister.RoutedTo = dr.GetString("RoutedTo"); incomingRegister.Notes = dr.GetString("Notes"); incomingRegister.ArchiveLocation = dr.GetString("ArchiveLocation"); incomingRegister.CreateDate = dr.GetSmartDate("CreateDate", true); incomingRegister.ChangeDate = dr.GetSmartDate("ChangeDate", true); } } return(incomingRegister); }
/// <summary> /// Inserts a new IncomingRegister object in the database. /// </summary> /// <param name="incomingRegister">The Incoming Register DTO.</param> /// <returns>The new <see cref="IncomingRegisterDto"/>.</returns> public IncomingRegisterDto Insert(IncomingRegisterDto incomingRegister) { using (var ctx = ConnectionManager <SqlConnection> .GetManager("InterwayDocs")) { using (var cmd = new SqlCommand("dbo.AddIncomingRegister", ctx.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RegisterId", incomingRegister.RegisterId).Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@RegisterDate", incomingRegister.RegisterDate.DBValue).DbType = DbType.Date; cmd.Parameters.AddWithValue("@DocumentType", incomingRegister.DocumentType).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentReference", incomingRegister.DocumentReference).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentEntity", incomingRegister.DocumentEntity).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentDept", incomingRegister.DocumentDept).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentClass", incomingRegister.DocumentClass).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentDate", incomingRegister.DocumentDate.DBValue).DbType = DbType.Date; cmd.Parameters.AddWithValue("@Subject", incomingRegister.Subject).DbType = DbType.String; cmd.Parameters.AddWithValue("@SenderName", incomingRegister.SenderName).DbType = DbType.String; cmd.Parameters.AddWithValue("@ReceptionDate", incomingRegister.ReceptionDate.DBValue).DbType = DbType.Date; cmd.Parameters.AddWithValue("@RoutedTo", incomingRegister.RoutedTo).DbType = DbType.String; cmd.Parameters.AddWithValue("@Notes", incomingRegister.Notes).DbType = DbType.String; cmd.Parameters.AddWithValue("@ArchiveLocation", incomingRegister.ArchiveLocation).DbType = DbType.String; cmd.Parameters.AddWithValue("@CreateDate", incomingRegister.CreateDate.DBValue).DbType = DbType.DateTime2; cmd.Parameters.AddWithValue("@ChangeDate", incomingRegister.ChangeDate.DBValue).DbType = DbType.DateTime2; cmd.ExecuteNonQuery(); incomingRegister.RegisterId = (int)cmd.Parameters["@RegisterId"].Value; } } return(incomingRegister); }
/// <summary> /// Updates in the database all changes made to the IncomingRegister object. /// </summary> /// <param name="incomingRegister">The Incoming Register DTO.</param> /// <returns>The updated <see cref="IncomingRegisterDto"/>.</returns> public IncomingRegisterDto Update(IncomingRegisterDto incomingRegister) { using (var ctx = ConnectionManager <SqlConnection> .GetManager("InterwayDocs")) { using (var cmd = new SqlCommand("dbo.UpdateIncomingRegister", ctx.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RegisterId", incomingRegister.RegisterId).DbType = DbType.Int32; cmd.Parameters.AddWithValue("@RegisterDate", incomingRegister.RegisterDate.DBValue).DbType = DbType.Date; cmd.Parameters.AddWithValue("@DocumentType", incomingRegister.DocumentType).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentReference", incomingRegister.DocumentReference).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentEntity", incomingRegister.DocumentEntity).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentDept", incomingRegister.DocumentDept).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentClass", incomingRegister.DocumentClass).DbType = DbType.String; cmd.Parameters.AddWithValue("@DocumentDate", incomingRegister.DocumentDate.DBValue).DbType = DbType.Date; cmd.Parameters.AddWithValue("@Subject", incomingRegister.Subject).DbType = DbType.String; cmd.Parameters.AddWithValue("@SenderName", incomingRegister.SenderName).DbType = DbType.String; cmd.Parameters.AddWithValue("@ReceptionDate", incomingRegister.ReceptionDate.DBValue).DbType = DbType.Date; cmd.Parameters.AddWithValue("@RoutedTo", incomingRegister.RoutedTo).DbType = DbType.String; cmd.Parameters.AddWithValue("@Notes", incomingRegister.Notes).DbType = DbType.String; cmd.Parameters.AddWithValue("@ArchiveLocation", incomingRegister.ArchiveLocation).DbType = DbType.String; cmd.Parameters.AddWithValue("@ChangeDate", incomingRegister.ChangeDate.DBValue).DbType = DbType.DateTime2; var rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected == 0) { throw new DataNotFoundException("IncomingRegister"); } } } return(incomingRegister); }
/// <summary> /// Loads a <see cref="IncomingRegister"/> object from the given <see cref="IncomingRegisterDto"/>. /// </summary> /// <param name="data">The IncomingRegisterDto to use.</param> private void Fetch(IncomingRegisterDto 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(SenderNameProperty, data.SenderName); LoadProperty(ReceptionDateProperty, data.ReceptionDate); LoadProperty(RoutedToProperty, data.RoutedTo); LoadProperty(NotesProperty, data.Notes); LoadProperty(ArchiveLocationProperty, data.ArchiveLocation); LoadProperty(CreateDateProperty, data.CreateDate); LoadProperty(ChangeDateProperty, data.ChangeDate); var args = new DataPortalHookArgs(data); OnFetchRead(args); }