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