public DataSet trackDoc(string refNo, string timeStart, string timeEnd)
{
MBOLsTrack MBs = new MBOLsTrack(elt_account_number, ConnectStr);
HBOLsTrack HBOLs = new HBOLsTrack(elt_account_number, ConnectStr);
IVsTrack IVs = new IVsTrack(elt_account_number, ConnectStr);
RPsTrack RPs = new RPsTrack(elt_account_number, ConnectStr);
int mbol_count = 0;
int hbol_count = 0;
int iv_count = 0;
int rp_count = 0;
ds = new DataSet();
//---------------------------------------------------------------------------------------
DataTable dtMBOL = new DataTable();
dtMBOL.TableName = "MBOL";
dtMBOL.Columns.Add(new DataColumn("Primary"));
dtMBOL.Columns.Add(new DataColumn("IE"));
dtMBOL.Columns.Add(new DataColumn("MBOL#"));
dtMBOL.Columns.Add(new DataColumn("Date Issued"));
DataColumn[] keys = new DataColumn[1];
keys[0] = dtMBOL.Columns[0];
dtMBOL.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtHBOL = new DataTable();
dtHBOL.TableName = "HBOL";
dtHBOL.Columns.Add(new DataColumn("Primary"));
dtHBOL.Columns.Add(new DataColumn("Foreign"));
dtHBOL.Columns.Add(new DataColumn("IE"));
dtHBOL.Columns.Add(new DataColumn("MBOL#"));
dtHBOL.Columns.Add(new DataColumn("HBOL#"));
dtHBOL.Columns.Add(new DataColumn("Date Issued"));
keys = new DataColumn[1];
keys[0] = dtHBOL.Columns[0];
dtHBOL.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtIVs = new DataTable();
dtIVs.TableName = "IV";
dtIVs.Columns.Add(new DataColumn("Primary"));
dtIVs.Columns.Add(new DataColumn("Foreign"));
dtIVs.Columns.Add(new DataColumn("IE"));
dtIVs.Columns.Add(new DataColumn("MBOL#"));
dtIVs.Columns.Add(new DataColumn("HBOL#"));
dtIVs.Columns.Add(new DataColumn("IV#", System.Type.GetType("System.Decimal")));
dtIVs.Columns.Add(new DataColumn("Date Issued"));
keys = new DataColumn[1];
keys[0] = dtIVs.Columns[0];
dtIVs.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtRP = new DataTable();
dtRP.TableName = "RP";
dtRP.Columns.Add(new DataColumn("Primary"));
dtRP.Columns.Add(new DataColumn("Foreign"));
dtRP.Columns.Add(new DataColumn("RP#"));
dtRP.Columns.Add(new DataColumn("Date Issued"));
dtRP.Columns.Add(new DataColumn("Paid"));
keys = new DataColumn[1];
keys[0] = dtRP.Columns[0];
dtRP.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtHBOL_Tmp;
if (refNo != "")
{
dtHBOL_Tmp = HBOLs.getHBOL(refNo);
}
else
{
dtHBOL_Tmp = HBOLs.getHBOLsDuring(timeStart, timeEnd);
}
for (int i = 0; i < dtHBOL_Tmp.Rows.Count; i++)
{
string mbString = dtHBOL_Tmp.Rows[i]["MBOL#"].ToString();
DataTable dtMBOL_Tmp = new DataTable();
if (mbString != "")
{
dtMBOL_Tmp = MBs.getMBOL(mbString);
}
DataRow newRow = dtMBOL.NewRow();
if (dtMBOL_Tmp.Rows.Count != 0)
{
newRow.ItemArray = dtMBOL_Tmp.Rows[0].ItemArray;
}
newRow["Primary"] = mbol_count;
dtMBOL.Rows.Add(newRow);
DataRow hbol_row = dtHBOL.NewRow();
hbol_row.ItemArray = dtHBOL_Tmp.Rows[i].ItemArray;
hbol_row["Foreign"] = mbol_count;
hbol_row["Primary"] = hbol_count++;
dtHBOL.Rows.Add(hbol_row);
mbol_count++;
}
for (int j = 0; j < dtHBOL.Rows.Count; j++)
{
string hbString = dtHBOL.Rows[j]["HBOL#"].ToString();
DataTable dtTempIVs = new DataTable();
if (hbString != "")
{
dtTempIVs = IVs.getIVsByHB_Ocean(hbString);
}
string ivNo = "";
DataTable dtRP_Tmp;
if (dtTempIVs.Rows.Count > 0)
{
foreach (DataRow dr in dtTempIVs.Rows)
{
DataRow iv_row = dtIVs.NewRow();
iv_row.ItemArray = dr.ItemArray;
iv_row["Foreign"] = j;
iv_row["Primary"] = iv_count;
dtIVs.Rows.Add(iv_row);
ivNo = dr["IV#"].ToString();
dtRP_Tmp = new DataTable();
if (ivNo != "")
{
dtRP_Tmp = RPs.getRPsByIV(ivNo);
}
if (dtRP_Tmp.Rows.Count > 0)
{
foreach (DataRow dr2 in dtRP_Tmp.Rows)
{
DataRow rp_row = dtRP.NewRow();
rp_row.ItemArray = dr2.ItemArray;
rp_row["Foreign"] = iv_count;
rp_row["Primary"] = rp_count++;
dtRP.Rows.Add(rp_row);
}
}
iv_count++;
}
}
}
ds.Tables.Add(dtMBOL);
ds.Tables.Add(dtHBOL);
ds.Tables.Add(dtIVs);
ds.Tables.Add(dtRP);
ds.Relations.Add(new DataRelation("MBOL_TO_HBOL", dtMBOL.Columns["Primary"], dtHBOL.Columns["Foreign"]));
ds.Relations.Add(new DataRelation("HBOL_TO_IV", dtHBOL.Columns["Primary"], dtIVs.Columns["Foreign"]));
ds.Relations.Add(new DataRelation("IV_TO_RP", dtIVs.Columns["Primary"], dtRP.Columns["Foreign"]));
return(ds);
}
public DataSet trackDoc(string refNo, string timeStart, string timeEnd)
{
MAWBsTrack MBs = new MAWBsTrack(elt_account_number, ConnectStr);
HAWBsTrack HAWBs = new HAWBsTrack(elt_account_number, ConnectStr);
IVsTrack IVs = new IVsTrack(elt_account_number, ConnectStr);
RPsTrack RPs = new RPsTrack(elt_account_number, ConnectStr);
int MAWB_count = 0;
int HAWB_count = 0;
int iv_count = 0;
int rp_count = 0;
ds = new DataSet();
//---------------------------------------------------------------------------------------
DataTable dtMAWB = new DataTable();
dtMAWB.TableName = "MAWB";
dtMAWB.Columns.Add(new DataColumn("Primary"));
dtMAWB.Columns.Add(new DataColumn("IE"));
dtMAWB.Columns.Add(new DataColumn("MAWB#"));
dtMAWB.Columns.Add(new DataColumn("Date Issued"));
DataColumn[] keys = new DataColumn[1];
keys[0] = dtMAWB.Columns[0];
dtMAWB.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtHAWB = new DataTable();
dtHAWB.TableName = "HAWB";
dtHAWB.Columns.Add(new DataColumn("Primary"));
dtHAWB.Columns.Add(new DataColumn("Foreign"));
dtHAWB.Columns.Add(new DataColumn("IE"));
dtHAWB.Columns.Add(new DataColumn("MAWB#"));
dtHAWB.Columns.Add(new DataColumn("HAWB#"));
dtHAWB.Columns.Add(new DataColumn("Date Issued"));
keys = new DataColumn[1];
keys[0] = dtHAWB.Columns[0];
dtHAWB.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtIVs = new DataTable();
dtIVs.TableName = "IV";
dtIVs.Columns.Add(new DataColumn("Primary"));
dtIVs.Columns.Add(new DataColumn("Foreign"));
dtIVs.Columns.Add(new DataColumn("IE"));
dtIVs.Columns.Add(new DataColumn("MAWB#"));
dtIVs.Columns.Add(new DataColumn("HAWB#"));
dtIVs.Columns.Add(new DataColumn("IV#", System.Type.GetType("System.Decimal")));
dtIVs.Columns.Add(new DataColumn("Date Issued"));
keys = new DataColumn[1];
keys[0] = dtIVs.Columns[0];
dtIVs.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtRP = new DataTable();
dtRP.TableName = "RP";
dtRP.Columns.Add(new DataColumn("Primary"));
dtRP.Columns.Add(new DataColumn("Foreign"));
dtRP.Columns.Add(new DataColumn("RP#"));
dtRP.Columns.Add(new DataColumn("Date Issued"));
dtRP.Columns.Add(new DataColumn("Paid"));
keys = new DataColumn[1];
keys[0] = dtRP.Columns[0];
dtRP.PrimaryKey = keys;
//---------------------------------------------------------------------------------------
DataTable dtMAWB_Tmp;
if (refNo != "")
{
dtMAWB_Tmp = MBs.getMAWB(refNo);
}
else
{
dtMAWB_Tmp = MBs.getMAWBsDuring(timeStart, timeEnd);
}
foreach (DataRow dr in dtMAWB_Tmp.Rows)
{
DataRow newRow = dtMAWB.NewRow();
newRow.ItemArray = dr.ItemArray;
newRow["Primary"] = MAWB_count++;
dtMAWB.Rows.Add(newRow);
}
//dtMAWB.Merge(dtMAWB_Tmp);
if (dtMAWB.Rows.Count > 0)
{
for (int i = 0; i < dtMAWB.Rows.Count; i++)
{
DataTable dtHAWB_Tmp = new DataTable();
string mbString1 = dtMAWB.Rows[i]["MAWB#"].ToString();
if (mbString1 != "")
{
dtHAWB_Tmp = HAWBs.getHAWBsByMAWB(mbString1);
}
if (dtHAWB_Tmp.Rows.Count == 0)
{
string mbString = dtMAWB.Rows[i]["MAWB#"].ToString();
DataTable dtTempIVs = new DataTable();;
if (mbString != "")
{
dtTempIVs = IVs.getIVsByMB_Ocean(mbString);
}
DataRow HAWB_row = dtHAWB.NewRow();
HAWB_row["Foreign"] = i.ToString();
HAWB_row["Primary"] = HAWB_count;
dtHAWB.Rows.Add(HAWB_row);
if (dtTempIVs.Rows.Count > 0)
{
string ivNo = "";
DataTable dtRP_Tmp;
foreach (DataRow dr in dtTempIVs.Rows)
{
DataRow iv_row = dtIVs.NewRow();
iv_row.ItemArray = dr.ItemArray;
iv_row["Foreign"] = HAWB_count;
iv_row["Primary"] = iv_count;
dtIVs.Rows.Add(iv_row);
ivNo = dr["IV#"].ToString();
dtRP_Tmp = new DataTable();
if (ivNo != "")
{
dtRP_Tmp = RPs.getRPsByIV(ivNo);
}
if (dtRP_Tmp.Rows.Count > 0)
{
foreach (DataRow dr2 in dtRP_Tmp.Rows)
{
DataRow rp_row = dtRP.NewRow();
rp_row.ItemArray = dr2.ItemArray;
rp_row["Foreign"] = iv_count;
rp_row["Primary"] = rp_count++;
dtRP.Rows.Add(rp_row);
}
}
iv_count++;
}
}
HAWB_count++;
}
else
{
for (int j = 0; j < dtHAWB_Tmp.Rows.Count; j++)
{
DataRow HAWB_row = dtHAWB.NewRow();
HAWB_row.ItemArray = dtHAWB_Tmp.Rows[j].ItemArray;
HAWB_row["Foreign"] = i.ToString();
HAWB_row["Primary"] = HAWB_count;
dtHAWB.Rows.Add(HAWB_row);
string hbstring = dtHAWB_Tmp.Rows[j]["HAWB#"].ToString();
DataTable dtTempIVs = new DataTable();;
if (hbstring != "")
{
dtTempIVs = IVs.getIVsByHB_Ocean(hbstring);
}
string ivNo = "";
DataTable dtRP_Tmp;
if (dtTempIVs.Rows.Count > 0)
{
foreach (DataRow dr in dtTempIVs.Rows)
{
DataRow iv_row = dtIVs.NewRow();
iv_row.ItemArray = dr.ItemArray;
iv_row["Foreign"] = HAWB_count;
iv_row["Primary"] = iv_count;
dtIVs.Rows.Add(iv_row);
dtRP_Tmp = new DataTable();
ivNo = dr["IV#"].ToString();
if (ivNo != "")
{
dtRP_Tmp = RPs.getRPsByIV(ivNo);
}
if (dtRP_Tmp.Rows.Count > 0)
{
foreach (DataRow dr2 in dtRP_Tmp.Rows)
{
DataRow rp_row = dtRP.NewRow();
rp_row.ItemArray = dr2.ItemArray;
rp_row["Foreign"] = iv_count;
rp_row["Primary"] = rp_count++;
dtRP.Rows.Add(rp_row);
}
}
iv_count++;
}
}
HAWB_count++;
}
}
}
ds.Tables.Add(dtMAWB);
ds.Tables.Add(dtHAWB);
ds.Tables.Add(dtIVs);
ds.Tables.Add(dtRP);
ds.Relations.Add(new DataRelation("MAWB_TO_HAWB", dtMAWB.Columns["Primary"], dtHAWB.Columns["Foreign"]));
ds.Relations.Add(new DataRelation("HAWB_TO_IV", dtHAWB.Columns["Primary"], dtIVs.Columns["Foreign"]));
ds.Relations.Add(new DataRelation("IV_TO_RP", dtIVs.Columns["Primary"], dtRP.Columns["Foreign"]));
return(ds);
}
return(ds);
}
