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);
}
}
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);
}
/// <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);
}
/// <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);
}
/// <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);
}
