public static ReportDocument LoadInventoryAdjustmentList(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Inventory.rprInventoryAdjustmentList();
dsReports ds = new dsReports();
ds.EnforceConstraints = false;
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillInventoryAdjustments(ds.DenormalizedOrders, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
{
FillNoData(ds.DenormalizedOrders);
}
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return(rpt);
}
public static ReportDocument LoadDeliveryOrderForm(string code)
{
ReportDocument rpt = new Forms.rptDeliveryOrderForm();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByOrderNo(ds.DenormalizedOrders, code, TransactionTypes.TX_DELIVERY_ORDER);
if (ds.DenormalizedOrders.Rows.Count <= 0)
FillNoData(ds.DenormalizedOrders);
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
return rpt;
}
public static ReportDocument LoadDeliveryOrderForm(int id)
{
ReportDocument rpt = new Forms.rptDeliveryOrderForm();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByID(ds.DenormalizedOrders, id);
if (ds.DenormalizedOrders.Rows.Count <= 0)
FillNoData(ds.DenormalizedOrders);
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
return rpt;
}
public static ReportDocument LoadDeliveryOrderForm(string code)
{
ReportDocument rpt = new Forms.rptDeliveryOrderForm();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByOrderNo(ds.DenormalizedOrders, code, TransactionTypes.TX_DELIVERY_ORDER);
if (ds.DenormalizedOrders.Rows.Count <= 0)
{
FillNoData(ds.DenormalizedOrders);
}
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
return(rpt);
}
public static ReportDocument LoadDeliveryOrderForm(int id)
{
ReportDocument rpt = new Forms.rptDeliveryOrderForm();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByID(ds.DenormalizedOrders, id);
if (ds.DenormalizedOrders.Rows.Count <= 0)
{
FillNoData(ds.DenormalizedOrders);
}
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
return(rpt);
}
public static ReportDocument LoadInventoryMutation(int id)
{
ReportDocument rpt = new Inventory.rprInventoryMutation();
dsReports ds = new dsReports();
ds.EnforceConstraints = false;
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByItemID(ds.DenormalizedOrders, id);
if (ds.DenormalizedOrders.Rows.Count <= 0)
{
FillNoData(ds.DenormalizedOrders);
}
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
return(rpt);
}
public static ReportDocument LoadSalesOutstanding(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Sales.rprBackOrders();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillNotCompleted(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
{
FillNoData(ds.DenormalizedOrders);
}
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return(rpt);
}
public static ReportDocument LoadPurchaseByVendor(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Purchasing.rprPurchaseByVendor();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_PURCHASE_ORDER, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
{
FillNoData(ds.DenormalizedOrders);
}
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return(rpt);
}
public static ReportDocument LoadInventoryAdjustmentList(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Inventory.rprInventoryAdjustmentList();
dsReports ds = new dsReports();
ds.EnforceConstraints = false;
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillInventoryAdjustments(ds.DenormalizedOrders, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
FillNoData(ds.DenormalizedOrders);
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return rpt;
}
public static ReportDocument LoadInventoryMutation(int id)
{
ReportDocument rpt = new Inventory.rprInventoryMutation();
dsReports ds = new dsReports();
ds.EnforceConstraints = false;
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByItemID(ds.DenormalizedOrders, id);
if (ds.DenormalizedOrders.Rows.Count <= 0)
FillNoData(ds.DenormalizedOrders);
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
return rpt;
}
public static ReportDocument LoadSalesOutstanding(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Sales.rprBackOrders();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillNotCompleted(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
FillNoData(ds.DenormalizedOrders);
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return rpt;
}
public static ReportDocument LoadPurchaseByVendor(DateTime date1, DateTime date2)
{
ReportDocument rpt = new Purchasing.rprPurchaseByVendor();
dsReports ds = new dsReports();
DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
ta.ClearBeforeFill = true;
ta.Connection = AppHelper.GetDbConnection();
ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_PURCHASE_ORDER, date1, date2);
if (ds.DenormalizedOrders.Rows.Count <= 0)
FillNoData(ds.DenormalizedOrders);
RetrieveDeveloper(ds.Developer);
RetrieveOwner(ds.Owner);
rpt.SetDataSource(ds);
rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
return rpt;
}
