public void DbUpdate()
{
UserIdentity user = UserIdentity.Current;
Validate();
System.Data.OleDb.OleDbConnection con = Db.Connection;
OleDbTransaction trans = con.BeginTransaction();
OleDbCommand cmd = con.CreateCommand();
cmd.Transaction = trans;
try
{
CmdParams cp = new CmdParams(cmd, false);
m_CreationTime = DateTime.Now;
cmd.CommandText = @"
update documents
set FileType = " + cp.Add(m_FileTypeId) +
", [FileName] = " + cp.Add(m_FileName) +
", DateReceived = " + cp.Add(m_DateReceived) +
", DocumentDate = " + cp.Add(m_DocumentDate) +
", IncomingNumber = " +cp.Add(m_IncomingNumber) +
", OutgoingNumber = " +cp.Add(m_OutgoingNumber) +
", Subject = " +cp.Add(m_Subject) +
", Header = " + cp.Add(m_Header) +
", ArchiveFileNames = " + cp.Add(m_ArchiveFileNames) +
", DocTypeId = " + cp.Add(m_DocTypeId) +
", DocSourceId = " + cp.Add(m_DocSourceId) +
", DocCategoryId = " + cp.Add(m_DocCategoryId) +
", ParentId = " + cp.Add(m_ParentId) +
", PreviousVersionId = " + cp.Add(m_PreviousVersionId) +
", IsPublic = " + cp.Add(m_IsPublic) +
", StorageFileName = '" + StorageFileName + "' " +
" where id = " + m_Id.ToString();
cmd.ExecuteNonQuery();
StoreDocRefs(trans, "DocGroups", "GroupId", Groups);
StoreDocRefs(trans, "DocRefRelated", "RelatedDocId", RefDocuments);
cmd.Parameters.Clear();
cmd.CommandText = "delete from UserReadDocs where DocId=" + m_Id.ToString() + " and UserId=" + user.UserId.ToString();
cmd.ExecuteNonQuery();
cmd.CommandText = "delete from UserFavoriteDocs where DocId=" + m_Id.ToString() + " and UserId=" + user.UserId.ToString();
cmd.ExecuteNonQuery();
if(IsRead)
{
cmd.CommandText = "insert into UserReadDocs (DocId, UserId) values (" + m_Id.ToString() + ", " + user.UserId.ToString() + " ) ";
cmd.ExecuteNonQuery();
}
if(IsFavorite)
{
cmd.CommandText = "insert into UserFavoriteDocs (DocId, UserId) values (" + m_Id.ToString() + ", " + user.UserId.ToString() +" ) ";
cmd.ExecuteNonQuery();
}
trans.Commit();
}
catch(Exception ex)
{
trans.Rollback();
throw ex;
}
}
public void DbUpdate()
{
UserIdentity user = UserIdentity.Current;
Validate();
System.Data.OleDb.OleDbConnection con = Db.Connection;
OleDbTransaction trans = con.BeginTransaction();
OleDbCommand cmd = con.CreateCommand();
cmd.Transaction = trans;
try
{
CmdParams cp = new CmdParams(cmd, false);
m_CreationTime = DateTime.Now;
cmd.CommandText = @"
update documents
set FileType = " + cp.Add(m_FileTypeId) +
", [FileName] = " + cp.Add(m_FileName) +
", DateReceived = " + cp.Add(m_DateReceived) +
", DocumentDate = " + cp.Add(m_DocumentDate) +
", IncomingNumber = " + cp.Add(m_IncomingNumber) +
", OutgoingNumber = " + cp.Add(m_OutgoingNumber) +
", Subject = " + cp.Add(m_Subject) +
", Header = " + cp.Add(m_Header) +
", ArchiveFileNames = " + cp.Add(m_ArchiveFileNames) +
", DocTypeId = " + cp.Add(m_DocTypeId) +
", DocSourceId = " + cp.Add(m_DocSourceId) +
", DocCategoryId = " + cp.Add(m_DocCategoryId) +
", ParentId = " + cp.Add(m_ParentId) +
", PreviousVersionId = " + cp.Add(m_PreviousVersionId) +
", IsPublic = " + cp.Add(m_IsPublic) +
", StorageFileName = '" + StorageFileName + "' " +
" where id = " + m_Id.ToString();
cmd.ExecuteNonQuery();
StoreDocRefs(trans, "DocGroups", "GroupId", Groups);
StoreDocRefs(trans, "DocRefRelated", "RelatedDocId", RefDocuments);
cmd.Parameters.Clear();
cmd.CommandText = "delete from UserReadDocs where DocId=" + m_Id.ToString() + " and UserId=" + user.UserId.ToString();
cmd.ExecuteNonQuery();
cmd.CommandText = "delete from UserFavoriteDocs where DocId=" + m_Id.ToString() + " and UserId=" + user.UserId.ToString();
cmd.ExecuteNonQuery();
if (IsRead)
{
cmd.CommandText = "insert into UserReadDocs (DocId, UserId) values (" + m_Id.ToString() + ", " + user.UserId.ToString() + " ) ";
cmd.ExecuteNonQuery();
}
if (IsFavorite)
{
cmd.CommandText = "insert into UserFavoriteDocs (DocId, UserId) values (" + m_Id.ToString() + ", " + user.UserId.ToString() + " ) ";
cmd.ExecuteNonQuery();
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
public int DbCreate(out OleDbTransaction trans)
{
Validate();
System.Data.OleDb.OleDbConnection con = Db.Connection;
trans = con.BeginTransaction();
OleDbCommand cmd = con.CreateCommand();
cmd.Transaction = trans;
try
{
CmdParams cp = new CmdParams(cmd);
m_CreationTime = DateTime.Now;
cmd.CommandText = @"
insert into documents
(
CreationTime,
FileType,
[FileName],
DateReceived,
DocumentDate,
IncomingNumber,
OutgoingNumber,
Subject,
Header,
ArchiveFileNames,
DocTypeId,
DocSourceId,
DocCategoryId,
ParentId,
PreviousVersionId,
OwnerUserId,
IsPublic
)values ( " +
cp.Add(m_CreationTime) +
cp.Add(m_FileTypeId) +
cp.Add(m_FileName) +
cp.Add(m_DateReceived) +
cp.Add(m_DocumentDate) +
cp.Add(m_IncomingNumber) +
cp.Add(m_OutgoingNumber) +
cp.Add(m_Subject) +
cp.Add(m_Header) +
cp.Add(m_ArchiveFileNames) +
cp.Add(m_DocTypeId) +
cp.Add(m_DocSourceId) +
cp.Add(m_DocCategoryId) +
cp.Add(m_ParentId) +
cp.Add(m_PreviousVersionId) +
cp.Add(m_OwnerUserId) +
cp.Add(m_IsPublic) + " ) ";
cmd.ExecuteNonQuery();
cmd.CommandText="select @@identity";
Decimal oid = (Decimal) cmd.ExecuteScalar();
m_Id = Convert.ToInt32(oid);
StoreDocRefs(trans, "DocGroups", "GroupId", Groups);
StoreDocRefs(trans, "DocRefRelated", "RelatedDocId", RefDocuments);
cmd.Parameters.Clear();
cmd.CommandText = "update Documents set StorageFileName = '" + StorageFileName + "' where Id = " + m_Id.ToString();
cmd.ExecuteNonQuery();
//trans.Commit();
//.DEV. isRead
}
catch(Exception ex)
{
trans.Rollback();
trans = null;
throw ex;
}
MarkAsRead();
return m_Id;
}
public int DbCreate(out OleDbTransaction trans)
{
Validate();
System.Data.OleDb.OleDbConnection con = Db.Connection;
trans = con.BeginTransaction();
OleDbCommand cmd = con.CreateCommand();
cmd.Transaction = trans;
try
{
CmdParams cp = new CmdParams(cmd);
m_CreationTime = DateTime.Now;
cmd.CommandText = @"
insert into documents
(
CreationTime,
FileType,
[FileName],
DateReceived,
DocumentDate,
IncomingNumber,
OutgoingNumber,
Subject,
Header,
ArchiveFileNames,
DocTypeId,
DocSourceId,
DocCategoryId,
ParentId,
PreviousVersionId,
OwnerUserId,
IsPublic
)values ( " +
cp.Add(m_CreationTime) +
cp.Add(m_FileTypeId) +
cp.Add(m_FileName) +
cp.Add(m_DateReceived) +
cp.Add(m_DocumentDate) +
cp.Add(m_IncomingNumber) +
cp.Add(m_OutgoingNumber) +
cp.Add(m_Subject) +
cp.Add(m_Header) +
cp.Add(m_ArchiveFileNames) +
cp.Add(m_DocTypeId) +
cp.Add(m_DocSourceId) +
cp.Add(m_DocCategoryId) +
cp.Add(m_ParentId) +
cp.Add(m_PreviousVersionId) +
cp.Add(m_OwnerUserId) +
cp.Add(m_IsPublic) + " ) ";
cmd.ExecuteNonQuery();
cmd.CommandText = "select @@identity";
Decimal oid = (Decimal)cmd.ExecuteScalar();
m_Id = Convert.ToInt32(oid);
StoreDocRefs(trans, "DocGroups", "GroupId", Groups);
StoreDocRefs(trans, "DocRefRelated", "RelatedDocId", RefDocuments);
cmd.Parameters.Clear();
cmd.CommandText = "update Documents set StorageFileName = '" + StorageFileName + "' where Id = " + m_Id.ToString();
cmd.ExecuteNonQuery();
//trans.Commit();
//.DEV. isRead
}
catch (Exception ex)
{
trans.Rollback();
trans = null;
throw ex;
}
MarkAsRead();
return(m_Id);
}