public atriumDB.ActivityBFDataTable Load()
{
this.sqlDa.SelectCommand = sqlSelectAll;
atriumDB.ActivityBFDataTable dt = new atriumDB.ActivityBFDataTable();
//Fill(dt);
return(dt);
}
internal ActivityBFBE(FileManager pBEMng)
: base(pBEMng, pBEMng.DB.ActivityBF)
{
myA = pBEMng;
myActivityBFDT = (atriumDB.ActivityBFDataTable)myDT;
if (!myA.AtMng.AppMan.UseService && myODAL == null)
{
myODAL = myA.AtMng.DALMngr.GetActivityBF();
}
}
public atriumDB.ActivityBFDataTable LoadByActivityId(int ActivityId)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[ActivityBFSelectByActivityId]";
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("@ActivityId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@ActivityId"].Value = ActivityId;
atriumDB.ActivityBFDataTable dt = new atriumDB.ActivityBFDataTable();
Fill(dt);
return(dt);
}
public atriumDB.ActivityBFDataTable LoadByRoleGlobal(int officerId, DateTime date)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[ActivityBFSelectByRoleGlobal]";
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 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));
}
}
