public byte[] LoadAllFile(int fileId)
{
atriumDALManager aDAL = (atriumDALManager)this.DAL;
DataSet ds = new DataSet();
// ds.SchemaSerializationMode = SchemaSerializationMode.ExcludeSchema;
ds.RemotingFormat = SerializationFormat.Binary;
ds.Merge(this.LoadByFileId(fileId));
ds.Merge(aDAL.GetRecipient().LoadByFileId(fileId));
ds.Merge(aDAL.GetAttachment().LoadByFileId(fileId));
ds.Merge(LoadAttsNotOnFile(fileId));
//foreach (docDB.DocumentRow dr in ds.Document)
//{
// ds.Merge(aDAL.GetAttachment().LoadByMsgId(dr.DocId));
//}
//foreach (docDB.AttachmentRow att in ds.Attachment)
//{
// if(ds.Document.FindByDocId(att.AttachmentId)==null)
// ds.Merge(this.Load(att.AttachmentId));
//}
FixTZDSIssue(ds);
return(atriumDALManager.CompressData(ds));
}
public byte[] CLASLoadByFileId(int fileId)
{
atriumDALManager aDAL=(atriumDALManager)this.DAL;
DataSet ds = new DataSet();
ds.RemotingFormat = SerializationFormat.Binary;
ds.Merge(aDAL.GetFileHistory().LoadByFileId(fileId));
ds.Merge(aDAL.GetDebt().LoadByFileId(fileId));
ds.Merge(aDAL.GetAccountHistory().LoadByFileId(fileId));
ds.Merge(aDAL.GetTaxing().LoadByFileID(fileId));
ds.Merge(aDAL.GetJudgment().LoadByFileID(fileId));
ds.Merge(aDAL.GetJudgmentAccount().LoadByFileID(fileId));
ds.Merge(aDAL.GetWrit().LoadByFileID(fileId));
ds.Merge(aDAL.GetWritHistory().LoadByFileID(fileId));
ds.Merge(aDAL.GetProperty().LoadByFileID(fileId));
ds.Merge(aDAL.GetCashBlotter().LoadByFileId(fileId));
ds.Merge(aDAL.GetCBDetail().LoadByFileID(fileId));
ds.Merge(aDAL.GetBankruptcy().LoadByFileID(fileId));
ds.Merge(aDAL.GetBankruptcyAccount().LoadByFileId(fileId));
ds.Merge(aDAL.GetInsolvency().LoadByFileID(fileId));
ds.Merge(aDAL.GetInsolvencyAccount().LoadByFileId(fileId));
ds.Merge(aDAL.GetHardship().LoadByFileId(fileId));
ds.Merge(aDAL.GetCost().LoadByFileID(fileId));
ds.Merge(aDAL.GetCompOffer().LoadByFileID(fileId));
ds.Merge(aDAL.GetCompOfferDetail().LoadByFileId(fileId));
ds.Merge(aDAL.GetTaxing().LoadByFileID(fileId));
ds.Merge(aDAL.GetOfficeAccount().LoadByFileID(fileId));
ds.Merge(aDAL.GetDebtor().LoadByFileId(fileId));
FixTZDSIssue(ds);
return atriumDALManager.CompressData( ds);
}
public DataSet DeepLoadByFileId(int fileId)
{
atriumDALManager aDAL = (atriumDALManager)this.DAL;
DataSet ds = new DataSet();
// ds.SchemaSerializationMode = SchemaSerializationMode.ExcludeSchema;
ds.RemotingFormat = SerializationFormat.Binary;
myLastEdit = new DateTime(1900, 1, 1);
ds.Merge(this.LoadByFileId(fileId));
ds.Merge(aDAL.GetProcess().LoadByFileId(fileId));
ds.Merge(aDAL.GetProcessContext().LoadByFileId(fileId));
ds.Merge(aDAL.GetDisbursement().LoadByFileID(fileId));
ds.Merge(aDAL.GetActivityTime().LoadByFileId(fileId));
ds.Merge(aDAL.GetActivityBF().LoadByFileId(fileId));
ds.Merge(aDAL.GetActivityAttribution().LoadByFileID(fileId));
FixTZDSIssue(ds);
return(ds);
}
public byte[] MainLoadByFileId(int fileId)
{
atriumDALManager aDAL = (atriumDALManager)this.DAL;
DataSet ds = new DataSet();
//ds.SchemaSerializationMode = SchemaSerializationMode.ExcludeSchema;
ds.RemotingFormat = SerializationFormat.Binary;
ds.Merge(this.Load(fileId));
// could conditionally load based on file type,etc...
ds.Merge(aDAL.GetFileContact().LoadByFileId(fileId));
ds.Merge(aDAL.GetContact().LoadByFileId(fileId));
ds.Merge(aDAL.GetFileOffice().LoadByFileId(fileId));
ds.Merge(aDAL.GetFileXRef().LoadByFileId(fileId));
ds.Merge(aDAL.GetFileXRef().LoadByOtherFileId(fileId));
ds.Merge(aDAL.GetFileAKA().LoadByFileId(fileId));
ds.Merge(aDAL.GetAppointment().LoadByFileId(fileId));
ds.Merge(aDAL.GetApptRecurrence().LoadByFileId(fileId));
ds.Merge(aDAL.GetAttendee().LoadByFileId(fileId));
ds.Merge(aDAL.GetAddress().LoadByFileIdP(fileId));
ds.Merge(aDAL.GetsecFileRule().LoadByFileId(fileId));
ds.Merge(aDAL.GetFileFlag().LoadByFileId(fileId)); // WI 75956
//ds.Merge(aDAL.GetFileMetaType().Load());
ds.Merge(aDAL.GetRiskAssessment().LoadByFileId(fileId));
ds.Merge(aDAL.GetIRP().LoadByFileID(fileId));
ds.Merge(aDAL.GetAKA().LoadByFileId(fileId));
ds.Merge(aDAL.GetArchiveBatch().Load(fileId));
ds.Merge(aDAL.GetddEntity().LoadByFileId(fileId));
FixTZDSIssue(ds);
return atriumDALManager.CompressData(ds);
}
public byte[] LoadAll(int docId)
{
atriumDALManager aDAL = (atriumDALManager)this.DAL;
DataSet ds = new DataSet();
// ds.SchemaSerializationMode = SchemaSerializationMode.ExcludeSchema;
ds.RemotingFormat = SerializationFormat.Binary;
ds.Merge(this.Load(docId));
ds.Merge(aDAL.GetRecipient().LoadByDocId(docId));
docDB.AttachmentDataTable atts = aDAL.GetAttachment().LoadByMsgId(docId);
ds.Merge(atts);
foreach (docDB.AttachmentRow att in atts)
{
ds.Merge(this.Load(att.AttachmentId));
ds.Merge(aDAL.GetRecipient().LoadByDocId(att.AttachmentId));
}
FixTZDSIssue(ds);
return(atriumDALManager.CompressData(ds));
}
internal FileAccessDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal InsolvencyPeriodDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal ContactTypeDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal DisbursementDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal AttachmentDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal ActivityTimeDAL(atriumDALManager pDALManager)
: base(pDALManager)
{
Init();
}
internal ACFileTypeDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal HearingMethodDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal ADMSEIssuesDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal ACDocumentationDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal ADMSEDecisionDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal AppealLevelDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal DocContentDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal AttendeeDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal CBPaymentSourceDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal FileFormatDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal FileHistoryDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal HistoryTypeDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal JudgmentCourtLevelDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal ApptRecurrenceTypeDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
//public atriumDB.ActivityBFDataTable LoadByLawyer(int officerId, DateTime date)
//{
// this.sqlDa.SelectCommand = sqlSelect;
// this.sqlSelect.Parameters.Clear();
// this.sqlSelect.CommandText = "[ActivityBFSelectByLawyer]";
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OfficerId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@date", System.Data.SqlDbType.SmallDateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters["@officerId"].Value = officerId;
// this.sqlSelect.Parameters["@date"].Value = date;
// atriumDB.ActivityBFDataTable dt = new atriumDB.ActivityBFDataTable();
// Fill(dt);
// return dt;
//}
//public atriumDB.ActivityBFDataTable LoadByPL(int officerId, DateTime date)
//{
// this.sqlDa.SelectCommand = sqlSelect;
// this.sqlSelect.Parameters.Clear();
// this.sqlSelect.CommandText = "[ActivityBFSelectByPL]";
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OfficerId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@date", System.Data.SqlDbType.SmallDateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters["@officerId"].Value = officerId;
// this.sqlSelect.Parameters["@date"].Value = date;
// atriumDB.ActivityBFDataTable dt = new atriumDB.ActivityBFDataTable();
// Fill(dt);
// return dt;
//}
//public System.Data.DataTable LoadByMail(int officerId, DateTime date)
//{
// this.sqlDa.SelectCommand = sqlSelect;
// this.sqlSelect.Parameters.Clear();
// this.sqlSelect.CommandText = "[ActivityBFSelectByMail]";
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OfficerId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@date", System.Data.SqlDbType.SmallDateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters["@officerId"].Value = officerId;
// this.sqlSelect.Parameters["@date"].Value = date;
// System.Data.DataTable dt = new System.Data.DataTable();
// Fill(dt);
// return dt;
//}
//public atriumDB.ActivityBFDataTable LoadByOffice(int officeId, DateTime date)
//{
// this.sqlDa.SelectCommand = sqlSelect;
// this.sqlSelect.Parameters.Clear();
// this.sqlSelect.CommandText = "[ActivityBFSelectByOffice]";
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OfficeId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@date", System.Data.SqlDbType.SmallDateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters["@officeId"].Value = officeId;
// this.sqlSelect.Parameters["@date"].Value = date;
// atriumDB.ActivityBFDataTable dt = new atriumDB.ActivityBFDataTable();
// Fill(dt);
// return dt;
//}
public byte[] LoadBF(int officeId, int officerId, DateTime date, bool officerBF, Int64 tmpLastEdit)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
//System.DateTime tmpLastEdit = myLastEdit;
System.Data.DataSet ds = new System.Data.DataSet();
atriumDB.ActivityBFDataTable dt = new atriumDB.ActivityBFDataTable();
ds.RemotingFormat = System.Data.SerializationFormat.Binary;
if (!officerBF)
{
//select office bfs
dt.Merge(LoadByDirectForOffice(officeId, date));
dt.Merge(LoadByRoleForOffice(officeId, date));
}
else
{
atriumDALManager Dal = (atriumDALManager)myDALManager;
//select direct bfs
dt.Merge(LoadByDirect(officerId, date));
//select role bfs
dt.Merge(LoadByRoleFile(officerId, date));
lmDatasets.officeDB.OfficerRoleDataTable dtor = Dal.GetOfficerRole().LoadByOfficerID(officerId);
if (dtor.Rows.Count > 0)
{
dt.Merge(LoadByRoleGlobal(officerId, date));
}
//load access level 1 delegate bfs
lmDatasets.officeDB.OfficerDelegateDataTable dto = Dal.GetOfficerDelegate().LoadByDelegateToId(officerId);
foreach (officeDB.OfficerDelegateRow odr in dto.Rows)
{
if (odr.AccessLevel == 1)
{
dt.Merge(LoadByDirect(odr.OfficerId, date));
dt.Merge(LoadByRoleFile(odr.OfficerId, date));
lmDatasets.officeDB.OfficerRoleDataTable dtor1 = Dal.GetOfficerRole().LoadByOfficerID(odr.OfficerId);
if (dtor1.Rows.Count > 0)
{
dt.Merge(LoadByRoleGlobal(odr.OfficerId, date));
}
}
}
}
if (tmpLastEdit != null)
{
System.Data.DataView dv = new System.Data.DataView(dt, "ver>" + tmpLastEdit.ToString(), "", System.Data.DataViewRowState.CurrentRows);
//if (dt.Rows.Count > 0 & dt.Columns.Contains("UpdateDate"))
//{
// myLastEdit = (DateTime)dt.Select("", "UpdateDate desc")[0]["UpdateDate"];
//}
atriumDB.ActivityBFDataTable dt1 = new atriumDB.ActivityBFDataTable();
dt1.Merge(dv.ToTable());
//dt =(atriumDB.ActivityBFDataTable) dv.ToTable();
dt1.AcceptChanges();
ds.Tables.Add(dt1);
FixTZDSIssue(ds);
return(atriumDALManager.CompressData(ds));
}
else
{
ds.Tables.Add(dt);
FixTZDSIssue(ds);
return(atriumDALManager.CompressData(ds));
}
}
internal CommModeDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal CompOfferDetailDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal AppointmentNotificationDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}
internal ActivityCompletedDAL(atriumDALManager pDALManager) : base(pDALManager)
{
Init();
}