private void SetDataSource(ReportDocument Report)
{
long iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["memoid"].ToString() != null)
{
iID = Convert.ToInt64(Request.QueryString["memoid"].ToString());
}
else
{
iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["memoid"].ToString(), Session.SessionID));
}
lblReferrer.ToolTip = iID.ToString();
}
catch { iID = long.Parse(lblReferrer.ToolTip); }
ReportDataset rptds = new ReportDataset();
DebitMemos clsDebitMemos = new DebitMemos();
System.Data.DataTable dt = clsDebitMemos.ListAsDataTable(DebitMemoID: iID);
DebitMemoItems clsDebitMemoItems = new DebitMemoItems(clsDebitMemos.Connection, clsDebitMemos.Transaction);
System.Data.DataTable dtitems = clsDebitMemoItems.ListAsDataTable(DebitMemoID: iID);
clsDebitMemos.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.DebitMemo.NewRow();
foreach (DataColumn dc in rptds.DebitMemo.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.DebitMemo.Rows.Add(drNew);
}
foreach (System.Data.DataRow dr in dtitems.Rows)
{
DataRow drNew = rptds.DebitMemoItem.NewRow();
foreach (DataColumn dc in rptds.DebitMemoItem.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.DebitMemoItem.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
long iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["retid"].ToString() != null)
{
iID = Convert.ToInt64(Request.QueryString["retid"].ToString());
}
else
{
iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["retid"].ToString(), Session.SessionID));
}
lblReferrer.ToolTip = iID.ToString();
}
catch { iID = long.Parse(lblReferrer.ToolTip); }
ReportDataset rptds = new ReportDataset();
SOReturns clsSOReturns = new SOReturns();
MySqlDataReader myreader = clsSOReturns.List(iID, "CreditMemoID", SortOption.Ascending);
while (myreader.Read())
{
DataRow drNew = rptds.SOReturns.NewRow();
foreach (DataColumn dc in rptds.SOReturns.Columns)
{
drNew[dc] = "" + myreader[dc.ColumnName];
}
rptds.SOReturns.Rows.Add(drNew);
}
myreader.Close();
SOReturnItems clsSOReturnItems = new SOReturnItems(clsSOReturns.Connection, clsSOReturns.Transaction);
System.Data.DataTable dt = clsSOReturnItems.ListAsDataTable(iID);
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SOReturnItems.NewRow();
foreach (DataColumn dc in rptds.SOReturnItems.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.SOReturnItems.Rows.Add(drNew);
}
clsSOReturns.CommitAndDispose();
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
long iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["transferoutid"].ToString() != null)
{
iID = Convert.ToInt64(Request.QueryString["transferoutid"].ToString());
}
else
{
iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["transferoutid"].ToString(), Session.SessionID));
}
}
catch { iID = Convert.ToInt64(Common.Decrypt(lblReferrer.Text.Substring(lblReferrer.Text.IndexOf("transferoutid") + 14), Session.SessionID)); }
ReportDataset rptds = new ReportDataset();
TransferOut clsTransferOut = new TransferOut();
MySqlDataReader myreader = clsTransferOut.List(iID, "TransferOutID", SortOption.Ascending);
while (myreader.Read())
{
DataRow drNew = rptds.TransferOut.NewRow();
foreach (DataColumn dc in rptds.TransferOut.Columns)
{
drNew[dc] = "" + myreader[dc.ColumnName];
}
rptds.TransferOut.Rows.Add(drNew);
}
myreader.Close();
TransferOutItem clsTransferOutItem = new TransferOutItem(clsTransferOut.Connection, clsTransferOut.Transaction);
MySqlDataReader myreaderitems = clsTransferOutItem.List(iID, "TransferOutItemID", SortOption.Ascending);
while (myreaderitems.Read())
{
DataRow drNew = rptds.TransferOutItems.NewRow();
foreach (DataColumn dc in rptds.TransferOutItems.Columns)
{
drNew[dc] = "" + myreaderitems[dc.ColumnName];
}
rptds.TransferOutItems.Rows.Add(drNew);
}
myreaderitems.Close();
clsTransferOut.CommitAndDispose();
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
Int64 iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["branchtransferid"].ToString() != null)
{
iID = Convert.ToInt64(Request.QueryString["branchtransferid"].ToString());
}
else
{
iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["branchtransferid"].ToString(), Session.SessionID));
}
}
catch { iID = Convert.ToInt64(Common.Decrypt(lblReferrer.Text.Substring(lblReferrer.Text.IndexOf("branchtransferid") + 13), Session.SessionID)); }
ReportDataset rptds = new ReportDataset();
BranchTransfer clsBranchTransfer = new BranchTransfer();
System.Data.DataTable dt = clsBranchTransfer.ListAsDataTable(iID);
BranchTransferItem clsBranchTransferItem = new BranchTransferItem(clsBranchTransfer.Connection, clsBranchTransfer.Transaction);
System.Data.DataTable dtitems = clsBranchTransferItem.ListAsDataTable(iID);
clsBranchTransfer.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.BranchTransfer.NewRow();
foreach (DataColumn dc in rptds.BranchTransfer.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.BranchTransfer.Rows.Add(drNew);
}
foreach (System.Data.DataRow dr in dtitems.Rows)
{
DataRow drNew = rptds.BranchTransferItems.NewRow();
foreach (DataColumn dc in rptds.BranchTransferItems.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.BranchTransferItems.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
ReportDataset ds = new ReportDataset();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string TransactionNo = txtTransactionNo.Text.Trim();
Stock clsStock = new Stock();
DataTable dt = clsStock.Search(TransactionNo);
clsStock.CommitAndDispose();
long StockID = Convert.ToInt64(dt.Rows[0]["StockID"].ToString());
StockItem clsStockItem = new StockItem();
DataTable dtItems = clsStockItem.ListAsDataTable(StockID);
clsStockItem.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Stocks.NewRow();
foreach (DataColumn dc in rptds.Stocks.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Stocks.Rows.Add(drNew);
}
foreach (DataRow dr in dtItems.Rows)
{
DataRow drNew = rptds.StockItems.NewRow();
foreach (DataColumn dc in rptds.StockItems.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.StockItems.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private ReportDataset GetData(int userId)
{
ReportDataset dataset = new ReportDataset();
var dataset_user = dataset.User;
var dataset_transaction = dataset.Transaction;
var dataset_transactionType = dataset.TransactionType;
User currentUser = UserController.GetUserById(userId);
var newRow = dataset_user.NewRow();
newRow["userId"] = currentUser.userId;
newRow["userFullName"] = currentUser.userFullName;
newRow["userEmail"] = currentUser.userEmail;
newRow["userRole"] = currentUser.userRole;
dataset_user.Rows.Add(newRow);
List <TransactionHeader> headers = TransactionController.GetAllTrasactionByUser(userId);
foreach (var hd in headers)
{
var transaction_header = dataset_transaction.NewRow();
transaction_header["userId"] = hd.userId;
transaction_header["itemDescription"] = hd.itemDescription;
transaction_header["price"] = hd.price;
transaction_header["created_at"] = hd.created_at;
string typeName = "Spending";
if (hd.transactionId == 1)
{
typeName = "Income";
}
transaction_header["transactionTypeId"] = typeName;
dataset_transaction.Rows.Add(transaction_header);
}
return(dataset);
}
private void SetDataSourceProducts(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string ProductGroupName = string.Empty;
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
ProductGroupName = cboGroup.SelectedItem.Text;
}
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
SubGroupName = cboSubGroup.SelectedItem.Text;
}
Products clsProduct = new Products();
System.Data.DataTable dtProductInventoryReport = clsProduct.InventoryReport(ProductGroupName, SubGroupName, txtProductCodeSearch.Text);
//ProductVariationsMatrix clsMatrix = new ProductVariationsMatrix(clsProduct.Connection, clsProduct.Transaction);
//System.Data.DataTable dtMatrixInventoryReport = clsMatrix.InventoryReport(ProductGroupName, SubGroupName, txtProductCodeSearch.Text);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dtProductInventoryReport.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
}
// private void DeleteTempDirectory(string Path)
// {
// if (Directory.Exists(Path))
// {
// DirectoryInfo dir = new DirectoryInfo(Path);
// dir.Delete(true);
// }
//
// Directory.CreateDirectory(Path);
//
// }
#endregion
#region SetDataSource
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
ChartOfAccounts clsChartOfAccount = new ChartOfAccounts();
MySqlDataReader myreader = clsChartOfAccount.List("ChartOfAccountID", SortOption.Ascending);
clsChartOfAccount.CommitAndDispose();
while (myreader.Read())
{
DataRow drNew = rptds.ChartOfAccount.NewRow();
foreach (DataColumn dc in rptds.ChartOfAccount.Columns)
{
drNew[dc] = "" + myreader[dc.ColumnName];
}
rptds.ChartOfAccount.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
long iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["soid"].ToString() != null)
{ iID = Convert.ToInt64(Request.QueryString["soid"].ToString()); }
else { iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["soid"].ToString(), Session.SessionID)); }
lblReferrer.ToolTip = iID.ToString();
}
catch { iID = long.Parse(lblReferrer.ToolTip); }
ReportDataset rptds = new ReportDataset();
SO clsSO = new SO();
MySqlDataReader myreader = clsSO.List(iID, "SOID", SortOption.Ascending);
while (myreader.Read())
{
DataRow drNew = rptds.SO.NewRow();
foreach (DataColumn dc in rptds.SO.Columns)
drNew[dc] = "" + myreader[dc.ColumnName];
rptds.SO.Rows.Add(drNew);
}
myreader.Close();
SOItem clsSOItem = new SOItem(clsSO.Connection, clsSO.Transaction);
System.Data.DataTable dt = clsSOItem.ListAsDataTable(iID);
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SOItems.NewRow();
foreach (DataColumn dc in rptds.SOItems.Columns)
drNew[dc] = "" + dr[dc.ColumnName];
rptds.SOItems.Rows.Add(drNew);
}
clsSO.CommitAndDispose();
Report.SetDataSource(rptds);
SetParameters(Report);
}
public ReportModel RunReport(DataQueryCriteria criteria, string reportType)
{
if (criteria == null)
{
throw new Exception("Criteria is required.");
}
if (!criteria.StartDate.HasValue)
{
throw new Exception("Criteria must have a StartDate value.");
}
if (!criteria.EndDate.HasValue)
{
throw new Exception("Criteria must have a EndDate value.");
}
if (criteria.StartDate.Value >= criteria.EndDate.Value)
{
throw new Exception("Criteria must have a StartDate that comes before the EndDate.");
}
IList <MeterData> meterData = QueryMeterData(criteria)
.Where(x => x.TimeStamp.Day == 1 && x.TimeStamp.Hour == 0 && x.TimeStamp.Minute == 0 && x.TimeStamp.Second == 0).ToList();
IList <Report> reports;
if (reportType != "all")
{
reports = GetReports().Where(x => x.ReportType == reportType).ToList();
}
else
{
reports = GetReports().ToList();
}
var datasets = new List <ReportDataset>();
var labels = new List <string>();
var d = criteria.StartDate.Value;
while (d < criteria.EndDate.Value)
{
labels.Add(d.ToString("MMM \\'yy"));
foreach (var rep in reports)
{
ReportDataset ds = datasets.FirstOrDefault(x => x.Label == rep.ReportName);
if (ds == null)
{
ds = new ReportDataset()
{
Label = rep.ReportName,
Data = new List <double>(),
BorderColor = rep.BorderColor,
BackgroundColor = rep.BackgroundColor,
PointBorderColor = rep.PointBorderColor,
PointBackgroundColor = rep.PointBackgroundColor,
UnitCost = rep.UnitCost,
Fill = false
};
datasets.Add(ds);
}
var md = meterData.FirstOrDefault(x => x.TimeStamp == d && x.Header == rep.Header);
var value = md == null ? 0 : md.Value;
ds.Data.Add(value);
}
d = d.AddMonths(1);
}
var result = new ReportModel()
{
Labels = labels,
Datasets = datasets.Where(x => x.Data.Sum() > 0)
};
return(result);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime PostingDateFrom = DateTime.MinValue;
try
{ PostingDateFrom = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch{}
DateTime PostingDateTo = DateTime.MinValue;
try
{ PostingDateTo = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch{}
DataClass clsDataClass = new DataClass();
System.Data.DataTable dt;
string ReportType = cboReportType.SelectedItem.Text;
switch (ReportType)
{
case "Posted SO":
Data.SO clsSO = new Data.SO();
dt = clsDataClass.DataReaderToDataTable(clsSO.List(SOStatus.Posted, PostingDateFrom, PostingDateTo));
clsSO.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drSO = rptds.SO.NewRow();
foreach (DataColumn dc in rptds.SO.Columns)
drSO[dc] = dr[dc.ColumnName];
rptds.SO.Rows.Add(drSO);
}
break;
case "Posted SO Returns":
Data.SOReturns clsSOReturns = new Data.SOReturns();
dt = clsDataClass.DataReaderToDataTable(clsSOReturns.List(SOReturnStatus.Posted, PostingDateFrom, PostingDateTo));
clsSOReturns.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drSOReturns = rptds.SOReturns.NewRow();
foreach (DataColumn dc in rptds.SOReturns.Columns)
drSOReturns[dc] = dr[dc.ColumnName];
rptds.SOReturns.Rows.Add(drSOReturns);
}
break;
case "Posted Credit Memo":
Data.CreditMemos clsCreditMemos = new Data.CreditMemos();
dt = clsDataClass.DataReaderToDataTable(clsCreditMemos.List(CreditMemoStatus.Posted, PostingDateFrom, PostingDateTo));
clsCreditMemos.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drCreditMemos = rptds.CreditMemo.NewRow();
foreach (DataColumn dc in rptds.CreditMemo.Columns)
drCreditMemos[dc] = dr[dc.ColumnName];
rptds.CreditMemo.Rows.Add(drCreditMemos);
}
break;
case "By Vendor":
Data.SalesAnalysis clsSalesAnalysis = new Data.SalesAnalysis();
dt = clsSalesAnalysis.ByVendor(PostingDateFrom, PostingDateTo);
clsSalesAnalysis.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drPAByVendor = rptds.SalesAnalysisPerCustomer.NewRow();
foreach (DataColumn dc in rptds.SalesAnalysisPerCustomer.Columns)
drPAByVendor[dc] = dr[dc.ColumnName];
rptds.SalesAnalysisPerCustomer.Rows.Add(drPAByVendor);
}
break;
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
Int64 intProductID = 0;
if (cboProductCode.Items.Count > 0)
{
intProductID = Int64.Parse(cboProductCode.SelectedItem.Value);
}
Int64 intMatrixID = 0;
if (cboVariation.Items.Count > 0)
{
intMatrixID = Int64.Parse(cboVariation.SelectedItem.Value);
}
DateTime DateFrom = DateTime.MinValue;
DateFrom = DateTime.TryParse(txtStartDate.Text + " " + txtStartTime.Text, out DateFrom) ? DateFrom : DateTime.MinValue;
DateTime DateTo = DateTime.MinValue;
DateTo = DateTime.TryParse(txtEndDate.Text + " " + txtEndTime.Text, out DateTo) ? DateTo : DateTime.MinValue;
Int32 intLimit = 0;
intLimit = Int32.TryParse(txtLimit.Text, out intLimit) ? intLimit : 0;
Int32 intBranchID = 0;
intBranchID = Int32.TryParse(cboBranch.SelectedItem.Value, out intBranchID) ? intBranchID : 0;
switch (cboReportType.SelectedValue)
{
case ReportTypes.ProductHistoryMovement:
#region Product History Movement
StockItem clsStockItem = new StockItem();
System.Data.DataTable dtProductHistoryMovement = clsStockItem.ProductMovementReport(intProductID, intMatrixID, DateFrom, DateTo, intBranchID);
clsStockItem.CommitAndDispose();
foreach (DataRow dr in dtProductHistoryMovement.Rows)
{
DataRow drNew = rptds.ProductMovement.NewRow();
foreach (DataColumn dc in rptds.ProductMovement.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.ProductMovement.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductHistoryPrice:
#region Product price history
ProductPackagePriceHistory clsProductPackagePriceHistory = new ProductPackagePriceHistory();
clsProductPackagePriceHistory.GetConnection();
System.Data.DataTable dtProductList = clsProductPackagePriceHistory.List(DateFrom, DateTo, intProductID);
clsProductPackagePriceHistory.CommitAndDispose();
foreach (DataRow dr in dtProductList.Rows)
{
DataRow drNew = rptds.ProductPriceHistory.NewRow();
foreach (DataColumn dc in rptds.ProductPriceHistory.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.ProductPriceHistory.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductHistoryMostSaleable:
#region Most Saleable
SalesTransactionItems clsSalesTransactionItemsMost = new SalesTransactionItems();
System.Data.DataTable dtMostSaleable = clsSalesTransactionItemsMost.MostSalableItems(DateFrom, DateTo, intLimit);
clsSalesTransactionItemsMost.CommitAndDispose();
foreach (DataRow dr in dtMostSaleable.Rows)
{
DataRow drNew = rptds.MostSalableItems.NewRow();
foreach (DataColumn dc in rptds.MostSalableItems.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.MostSalableItems.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductHistoryLeastSaleable:
#region Least Saleable
SalesTransactionItems clsSalesTransactionItemsLeast = new SalesTransactionItems();
System.Data.DataTable dtLeastSaleable = clsSalesTransactionItemsLeast.LeastSalableItems(DateFrom, DateTo, intLimit);
clsSalesTransactionItemsLeast.CommitAndDispose();
foreach (DataRow dr in dtLeastSaleable.Rows)
{
DataRow drNew = rptds.LeastSalableItems.NewRow();
foreach (DataColumn dc in rptds.LeastSalableItems.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.LeastSalableItems.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string ProductGroupName = string.Empty;
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
ProductGroupName = cboGroup.SelectedItem.Text;
}
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
SubGroupName = cboSubGroup.SelectedItem.Text;
}
DateTime dteIDCStartDate = DateTime.Now.AddDays(-14);
DateTime dteIDCEndDate = DateTime.Now;
try { dteIDCStartDate = Convert.ToDateTime(txtStartTransactionDate.Text + " " + txtStartTime.Text); }catch {}
try { dteIDCEndDate = Convert.ToDateTime(txtEndTransactionDate.Text + " " + txtEndTime.Text); }catch {}
Products clsProduct = new Products();
if (cboSupplier.SelectedItem.Text == Constants.ALL)
{
if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{
clsProduct.UpdateProductReorderOverStockPerSubGroup(long.Parse(cboSubGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate);
}
else if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{
clsProduct.UpdateProductReorderOverStockPerGroup(long.Parse(cboGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate);
}
else
{
clsProduct.UpdateProductReorderOverStock(dteIDCStartDate, dteIDCEndDate);
}
}
else
{
if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{
clsProduct.UpdateProductReorderOverStockPerSupplierPerSubGroup(long.Parse(cboSupplier.SelectedValue), long.Parse(cboSubGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate);
}
else if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{
clsProduct.UpdateProductReorderOverStockPerSupplierPerGroup(long.Parse(cboSupplier.SelectedValue), long.Parse(cboGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate);
}
else
{
clsProduct.UpdateProductReorderOverStockPerSupplier(long.Parse(cboSupplier.SelectedValue), dteIDCStartDate, dteIDCEndDate);
}
}
clsProduct.CommitAndDispose();
clsProduct = new Products();
System.Data.DataTable dt = (clsProduct.SearchDataTable(ProductListFilterType.ShowActiveOnly, string.Empty, long.Parse(cboSupplier.SelectedValue),
long.Parse(cboGroup.SelectedItem.Value), string.Empty, long.Parse(cboSubGroup.SelectedItem.Value), string.Empty, 0, false, false, string.Empty, SortOption.Ascending));
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drProducts = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drProducts[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drProducts);
}
//ProductVariationsMatrix clsMatrix = new ProductVariationsMatrix(clsProduct.Connection, clsProduct.Transaction);
//rptds.Tables.Add(clsMatrix.BaseListAsDataTable(0, "a.ProductID", SortOption.Ascending));
// ds.Tables.Add(clsMatrix.ForReorder("a.Quantity", SortOption.Ascending));
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DataTable dt;
switch (cboReportType.SelectedValue)
{
case ReportTypes.CustomerCredit:
#region Customer Credit
Customer clsCustomer = new Customer();
dt = clsCustomer.CustomersDataTable(cboContactName.SelectedItem.Text);
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerDetails.NewRow();
foreach (DataColumn dc in rptds.CustomerDetails.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CustomerDetails.Rows.Add(drNew);
}
SalesTransactions clsSalesTransactions = new SalesTransactions(clsCustomer.Connection, clsCustomer.Transaction);
dt = clsSalesTransactions.ListForPaymentDataTable(Convert.ToInt64(cboContactName.SelectedItem.Value));
clsCustomer.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerCredit.NewRow();
foreach (DataColumn dc in rptds.CustomerCredit.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CustomerCredit.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.CustomerCreditListWCredit:
#region Customers List With Credit
Contacts clsContact = new Contacts();
dt = clsContact.CustomerAdvanceSearch(null, cboContactName.SelectedItem.Text, cboCustomerGroup.SelectedItem.Value, true, "ContactID", SortOption.Ascending);
clsContact.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Contacts.NewRow();
foreach (DataColumn dc in rptds.Contacts.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Contacts.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void ReportViewer_Load(object sender, EventArgs e)
{
try
{
if (!_isReportViewerLoaded)
{
if (ReportType.REPORT_COMAPNY_LIST.Equals(type))
{
#region COMPANY LIST REPORT CREATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.Companies orderby c.CMP_COD select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (Company c in query)
{
dataset.Tables["Company"].Rows.Add(
new object[]
{
(int)c.CMP_COD,
(string)c.CMP_NAME,
(string)c.CMP_ADDRESS,
(string)c.VIL_NAME,
(string)c.PAR_NAME,
(string)c.COU_NAME,
(string)c.CMP_PHONE
}
);
}
dataset.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.CompanyList.rdlc";
ReportParameter[] param = new ReportParameter[4];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["Company"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
else if (ReportType.REPORT_DRIVER_LIST.Equals(type))
{
#region DRIVER LIST REPORT CREATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.Drivers orderby c.DRV_COD select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (Driver c in query)
{
dataset.Tables["Driver"].Rows.Add(
new object[]
{
(int)c.DRV_COD,
(string)c.DRV_NAME,
(string)c.DRV_ADDRESS,
(string)c.VIL_NAME,
(string)c.PAR_NAME,
(string)c.COU_NAME,
(string)c.DRV_PHONE,
(string)c.DRV_LICENSE
}
);
}
dataset.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.DriverList.rdlc";
ReportParameter[] param = new ReportParameter[4];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["Driver"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
else if (ReportType.REPORT_SERVICES_CURRENT_DAY.Equals(type))
{
#region SERVICES CURRENT DAY CREATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod &&
c.IsValid
orderby c.TRANS_COD
select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (FinancialTransaction c in query)
{
if (c.IsValid)
{
dataset.Tables["ServicesCurrentDay"].Rows.Add(
new object[]
{
(int)c.DOC_NUM,
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(string)c.Company.CMP_NAME,
(string)c.TRANS_DESTINATION,
(string)c.DOC_TYPE_NAME,
(string)c.DOCUMENT_DATE.ToString("dd MMM yyyy"),
(decimal)c.TRANS_VALUE,
(decimal)c.TRANS_FINAL_VALUE
}
);
}
}
dataset.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.ServicesCurrentDay.rdlc";
ReportParameter[] param = new ReportParameter[6];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["ServicesCurrentDay"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
else if (ReportType.REPORT_ACCUMULATED_BY_DRIVER.Equals(type))
{
#region ACCUMULATED BY DRIVER LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
decimal FinalVal = decimal.Zero;
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod &&
c.Driver.DRV_LICENSE == DrvLicense &&
c.Driver.DRV_NAME == DrvName &&
c.IsValid
orderby c.TRANS_COD
select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
ReportDataset tax = new ReportDataset();
ReportDataset DeductionSet = new ReportDataset();
foreach (FinancialTransaction c in query)
{
if (c.IsValid)
{
dataset.Tables["AccumulatedByDriver"].Rows.Add(
new object[]
{
(int)c.DOC_NUM,
(string)c.DOCUMENT_DATE.ToString("dd MMM yyyy"),
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(string)c.Company.CMP_NAME,
(string)c.TRANS_DESTINATION,
(decimal)c.TRANS_VALUE,
(decimal)c.TRANS_REDUCTION,
(decimal)c.TRANS_FINAL_VALUE,
(string)c.TRANS_COMMENTS,
(string)c.VOUCHER_NUM
}
);
FinalVal = FinalVal + c.TRANS_FINAL_VALUE;
}
}
var query2 = from t in ctx.AppliedTaxes select t;
if (query2.Count() > 0)
{
int n = 0;
foreach (AppliedTax t in query2)
{
tax.Tables["Tax"].Rows.Add(new object[] {
(int)n,
(string)t.TaxDescription,
(decimal)(t.TaxAmount * FinalVal) / 100
});
n = n + 1;
}
}
DeductionSet.Tables["Deduction"].Rows.Add(new object[] { (decimal)Deduction });
dataset.AcceptChanges();
tax.AcceptChanges();
DeductionSet.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.AccumulatedByDriver.rdlc";
ReportParameter[] param = new ReportParameter[6];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["AccumulatedByDriver"]);
ReportDataSource taxsource = new ReportDataSource("DataSet2", tax.Tables["Tax"]);
ReportDataSource deductionsource = new ReportDataSource("DataSet3", DeductionSet.Tables["Deduction"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.LocalReport.DataSources.Add(taxsource);
_reportViewer.LocalReport.DataSources.Add(deductionsource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
else if (ReportType.REPORT_RECEIPT.Equals(type))
{
#region RECEIPT REPORT LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions where c.DOC_NUM == DocNum select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (FinancialTransaction c in query)
{
string VoidTxt = null;
if (!c.IsValid)
{
VoidTxt = "VOIDED";
}
dataset.Tables["Receipt"].Rows.Add(
new object[]
{
(int)c.DOC_NUM,
(string)DateTime.Now.ToString("dd MMM yyyy"),
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(string)c.Company.CMP_NAME,
(string)c.TRANS_DESTINATION,
(string)c.DOC_TYPE_NAME,
(int)c.NO_PAX,
(string)c.DOCUMENT_DATE.ToString("dd MMM yyyy"),
(decimal)c.TRANS_VALUE,
(decimal)c.TRANS_FINAL_VALUE,
(string)c.SERV_NAME,
(string)c.VOUCHER_NUM,
(string)VoidTxt
}
);
}
dataset.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.ReceiptVoucher.rdlc";
ReportParameter[] param = new ReportParameter[4];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["Receipt"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
else if (ReportType.REPORT_ACCUMULATED_PAID.Equals(type))
{
#region ACCUMULATED PAID LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod && c.IsValid
select c;
if (query.Count() > 0)
{
List <int> txNum = new List <int>();
var query2 = from d in query select new { d.DRV_COD };
foreach (var d in query2)
{
if (!txNum.Contains(d.DRV_COD))
{
txNum.Add(d.DRV_COD);
}
}
ReportDataset dataset = new ReportDataset();
int n = 0;
foreach (var d in txNum)
{
var query3 = from tx in query where tx.DRV_COD.Equals(d) select tx;
FinancialTransaction c = query3.FirstOrDefault();
if (c != null)
{
decimal TransValue = decimal.Zero;
decimal TransReduction = decimal.Zero;
decimal TransFinalValue = decimal.Zero;
foreach (FinancialTransaction tx in query3)
{
TransValue = TransValue + tx.TRANS_VALUE;
TransReduction = TransReduction + tx.TRANS_REDUCTION;
}
TransFinalValue = TransValue - TransReduction;
dataset.Tables["AccumulatedPaid"].Rows.Add(
new object[]
{
(int)n,
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(decimal)TransValue,
(decimal)TransReduction,
(decimal)TransFinalValue
}
);
n = n + 1;
}
}
dataset.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.AccumulatedPaid.rdlc";
ReportParameter[] param = new ReportParameter[6];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["AccumulatedPaid"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
else if (ReportType.REPORT_SERVICES.Equals(type))
{
#region REPORT SERVICES LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod && c.IsValid
select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
int n = 0;
foreach (FinancialTransaction c in query)
{
dataset.Tables["Services"].Rows.Add(
new object[]
{
(int)n,
(string)c.TRANS_DATE.ToString("dd MMM yyyy"),
(string)c.Driver.DRV_LICENSE + ", " + c.Driver.DRV_NAME,
(int)c.NO_PAX,
(string)c.TRANS_DESTINATION,
(decimal)c.TRANS_FINAL_VALUE,
(string)c.VOUCHER_NUM
}
);
n = n + 1;
}
dataset.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.ServicesReport.rdlc";
ReportParameter[] param = new ReportParameter[6];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["Services"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
else if (ReportType.REPORT_HOTEL_INFORMATION.Equals(type))
{
#region HOTEL INFORMATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod &&
c.Company.CMP_NAME == HotelInfo &&
c.IsValid
orderby c.TRANS_COD
select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (FinancialTransaction c in query)
{
if (c.IsValid)
{
dataset.Tables["HotelInformation"].Rows.Add(
new object[]
{
(int)c.DOC_NUM,
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(string)c.Company.CMP_NAME,
(string)c.TRANS_DESTINATION,
(string)c.VOUCHER_NUM,
(decimal)c.TRANS_FINAL_VALUE
}
);
}
}
dataset.AcceptChanges();
_reportViewer.LocalReport.ReportEmbeddedResource = "ExpressTMS.HotelInformation.rdlc";
ReportParameter[] param = new ReportParameter[7];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
param[6] = new ReportParameter("AGENT", HotelInfo);
_reportViewer.LocalReport.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["HotelInformation"]);
_reportViewer.LocalReport.DataSources.Clear();
_reportViewer.LocalReport.DataSources.Add(datasource);
_reportViewer.RefreshReport();
_isReportViewerLoaded = true;
}
}
#endregion
}
}
}
catch (System.Exception ex)
{
log.Error(ex);
Config.FatalError();
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
ReportDataset ds = new ReportDataset();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "DT_ReportDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
//long lngProductGroupName = long.Parse(cboProductGroup.SelectedItem.Value);
//long lngSubGroupName = long.Parse(cboSubGroup.SelectedItem.Value);
string ProductGroupName = string.Empty;
if (cboProductGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
ProductGroupName = cboProductGroup.SelectedItem.Value;
}
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
SubGroupName = cboSubGroup.SelectedItem.Value;
}
string ReportType = cboReportType.SelectedItem.Text;
ProductColumns clsProductColumns = new ProductColumns();
#region clsProductColumns
clsProductColumns.ProductCode = true;
clsProductColumns.BarCode = true;
clsProductColumns.BarCode2 = true;
clsProductColumns.BarCode3 = true;
clsProductColumns.ProductDesc = true;
clsProductColumns.ProductSubGroupName = true;
clsProductColumns.BaseUnitName = true;
clsProductColumns.UnitName = true;
clsProductColumns.ProductGroupName = true;
clsProductColumns.DateCreated = true;
clsProductColumns.Price = true;
clsProductColumns.Quantity = true;
clsProductColumns.MinThreshold = true;
clsProductColumns.MaxThreshold = true;
clsProductColumns.PurchasePrice = true;
clsProductColumns.SupplierName = true;
clsProductColumns.QuantityIN = true;
clsProductColumns.QuantityOUT = true;
clsProductColumns.RIDMinThreshold = true;
clsProductColumns.RIDMaxThreshold = true;
clsProductColumns.RID = true;
//clsProductColumns.BranchActualQuantity = true;
//clsProductColumns.BranchQuantity = true;
//clsProductColumns.BranchQuantityIN = true;
//clsProductColumns.BranchQuantityOUT = true;
#endregion
ProductDetails clsSearchKey = new ProductDetails();
#region Search Key
clsSearchKey.BranchID = Convert.ToInt32(cboBranch.SelectedItem.Value);
clsSearchKey.SupplierID = Convert.ToInt32(cboContact.SelectedItem.Value);
clsSearchKey.ProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
clsSearchKey.ProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
clsSearchKey.ProductCode = txtProductCode.Text;
#endregion
Products clsProduct = new Products();
clsProduct.GetConnection();
ProductInventories clsProductInventories = new ProductInventories(clsProduct.Connection, clsProduct.Transaction);
DataTable dt;
string ProductIDs = null;
switch (cboReportType.SelectedValue)
{
case ReportTypes.ProductList:
#region Products List
dt = clsProductInventories.ListAsDataTable(Int32.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductPriceList:
#region Products Price List
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drNew);
ProductIDs += dr["ProductID"].ToString() + ",";
}
break;
#endregion
case ReportTypes.ProductListWithInvalidMatrix:
#region Products List With Invalid Unit Matrix
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text, ShowOnlyWithInvalidUnitMatrix: true);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.WeightedProductsForWeighingScale:
case ReportTypes.CountedProductsForWeighingScale:
#region Weighted and Counted Products For Weighing Scale
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
if (dr[ProductColumnNames.BarCode].ToString() != null && dr[ProductColumnNames.BarCode].ToString() != string.Empty)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drNew);
ProductIDs += dr["ProductID"].ToString() + ",";
}
}
break;
#endregion
case ReportTypes.ProductsInDemoReport:
#region Products In Demo
DateTime StartTransactionDate = DateTime.TryParse(txtStartDate.Text + " " + txtStartTime.Text, out StartTransactionDate) ? StartTransactionDate : DateTime.MinValue;
DateTime EndTransactionDate = DateTime.TryParse(txtEndDate.Text + " " + txtEndTime.Text, out EndTransactionDate) ? EndTransactionDate : DateTime.MinValue;
SalesTransactionItems clsSalesTransactionItemsDemo = new SalesTransactionItems();
System.Data.DataTable dtDemo = clsSalesTransactionItemsDemo.ProductsInDemoReport(Int32.Parse(cboBranch.SelectedItem.Value), Int64.Parse(cboContact.SelectedItem.Value), cboProductGroup.SelectedItem.Text, cboSubGroup.SelectedItem.Text, txtProductCode.Text, "", StartTransactionDate, EndTransactionDate);
clsSalesTransactionItemsDemo.CommitAndDispose();
foreach (DataRow dr in dtDemo.Rows)
{
DataRow drNew = rptds.ProductsInDemo.NewRow();
foreach (DataColumn dc in rptds.ProductsInDemo.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.ProductsInDemo.Rows.Add(drNew);
}
break;
#endregion
default:
return;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strProductGroup = cboProductGroup.SelectedItem.Text == Constants.ALL ? string.Empty : cboProductGroup.SelectedItem.Text;
string TransactionNo = txtTransactionNo.Text;
string CustomerGroupName = cboContactGroupName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactGroupName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactGroupName.SelectedItem.Text;
string CustomerName = cboContactName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE","").Trim() : cboContactName.SelectedItem.Text;
string AgentName = cboAgent.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboAgent.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboAgent.SelectedItem.Text;
string CashierName = cboCashierName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboCashierName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboCashierName.SelectedItem.Text;
string TerminalNo = cboTerminalNo.SelectedItem.Text == Constants.ALL ? string.Empty : cboTerminalNo.SelectedItem.Text;
DateTime StartValidityDate = DateTime.TryParse(txtStartValidityDate.Text + " 00:00:00" + txtStartTime.Text, out StartValidityDate) ? StartValidityDate : DateTime.MinValue;
DateTime EndValidityDate = DateTime.TryParse(txtEndValidityDate.Text + " 23:59:59", out EndValidityDate) ? EndValidityDate : DateTime.MinValue;
DateTime StartTransactionDate = DateTime.TryParse(txtStartTransactionDate.Text + " " + txtStartTime.Text, out StartTransactionDate) ? StartTransactionDate : DateTime.MinValue;
DateTime EndTransactionDate = DateTime.TryParse(txtEndTransactionDate.Text + " " + txtEndTime.Text, out EndTransactionDate) ? EndTransactionDate : DateTime.MinValue;
TransactionStatus Status = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), cboTransactionStatus.SelectedItem.Value);
PaymentTypes PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboPaymentType.SelectedItem.Value);
DataTable dt = new DataTable();
ReportDataset rptds = new ReportDataset();
SalesTransactions clsSalesTransactions;
SalesTransactionItems clsSalesTransactionItems;
SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.BranchCode = true;
clsSalesTransactionsColumns.TransactionNo = true;
clsSalesTransactionsColumns.CustomerName = true;
clsSalesTransactionsColumns.CustomerGroupName = true;
clsSalesTransactionsColumns.CashierName = true;
clsSalesTransactionsColumns.TerminalNo = true;
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.DateSuspended = true;
clsSalesTransactionsColumns.DateResumed = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.SubTotal = true;
clsSalesTransactionsColumns.Discount = true;
clsSalesTransactionsColumns.VAT = true;
clsSalesTransactionsColumns.VATableAmount = true;
clsSalesTransactionsColumns.LocalTax = true;
clsSalesTransactionsColumns.AmountPaid = true;
clsSalesTransactionsColumns.CashPayment = true;
clsSalesTransactionsColumns.ChequePayment = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
clsSalesTransactionsColumns.BalanceAmount = true;
clsSalesTransactionsColumns.ChangeAmount = true;
clsSalesTransactionsColumns.DateClosed = true;
clsSalesTransactionsColumns.PaymentType = true;
clsSalesTransactionsColumns.ItemsDiscount = true;
clsSalesTransactionsColumns.Charge = true;
clsSalesTransactionsColumns.CreditPayment = true;
clsSalesTransactionsColumns.CreatedByName = true;
clsSalesTransactionsColumns.AgentName = true;
clsSalesTransactionsColumns.PaxNo = true;
#endregion
SalesTransactionDetails clsSearchKey = new SalesTransactionDetails();
clsSearchKey = new SalesTransactionDetails();
clsSearchKey.TransactionNo = TransactionNo;
clsSearchKey.CustomerGroupName = CustomerGroupName;
clsSearchKey.CustomerName = CustomerName;
clsSearchKey.CashierName = CashierName;
clsSearchKey.TerminalNo = TerminalNo;
clsSearchKey.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsSearchKey.TransactionDateFrom = StartTransactionDate;
clsSearchKey.TransactionDateTo = EndTransactionDate;
clsSearchKey.TransactionStatus = Status;
clsSearchKey.PaymentType = PaymentType;
clsSearchKey.AgentName = AgentName;
clsSearchKey.isConsignmentSearch = cboConsignment.SelectedItem.Value;
if (clsSearchKey.isConsignmentSearch != "-1")
{
clsSearchKey.isConsignment = bool.Parse(cboConsignment.SelectedItem.Value);
}
bool boWithTrustFund = true;
string strReportType = cboReportType.SelectedValue;
switch (strReportType)
{
case ReportTypes.SalesPerHour:
#region Sales Per Hour
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.SalesPerHour(string.Empty, string.Empty, StartTransactionDate, EndTransactionDate,0, cboTerminalNo.SelectedItem.Text);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SalesPerHour.NewRow();
foreach (DataColumn dc in rptds.SalesPerHour.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.SalesPerHour.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SalesPerDay:
//case ReportTypes.SalesPerDayWithTF:
#region Sales Per Day
if (strReportType == ReportTypes.SalesPerDay) boWithTrustFund = false;
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey.BranchID, clsSearchKey.TerminalNo, TransactionStatus: clsSearchKey.TransactionStatus, TransactionDateFrom: StartTransactionDate, TransactionDateTo: EndTransactionDate, WithTF: boWithTrustFund);
//dt = clsSalesTransactions.SalesPerDay(StartTransactionDate, EndTransactionDate, boWithTrustFund);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SummarizeDailySales:
//case ReportTypes.SummarizeDailySalesWithTF:
#region SummarizeDailySales
if (strReportType == ReportTypes.SummarizeDailySales) boWithTrustFund = false;
Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory();
dt = clsTerminalReportHistory.SummarizedDailySalesReport(Int32.Parse(cboBranch.SelectedItem.Value), TerminalNo, false, StartTransactionDate, EndTransactionDate, boWithTrustFund);
clsTerminalReportHistory.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SalesReport.NewRow();
foreach (DataColumn dc in rptds.SalesReport.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.SalesReport.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SalesTransactions:
#region Sales Transactions
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "TransactionNo", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, false, "TransactionNo", SortOption.Ascending, 0);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SalesTransactionPerCustomer:
case ReportTypes.SalesTransactionPerCustomerPerGroup:
case ReportTypes.SalesTransactionPerCustomerPerGroupSummarized:
case ReportTypes.SalesTransactionPerCustomerWithCheque:
case ReportTypes.SalesTransactionPerCashierPerCustomer:
#region Sales Transaction Per Customer
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "CustomerName", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, false, "CustomerName", SortOption.Ascending, 0);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SalesTransactionPerCustomerPerItem:
#region Sales Transaction Per Customer Per Item
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "CustomerName", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, false, "CustomerName", SortOption.Ascending, 0);
clsSalesTransactions.CommitAndDispose();
string stIDs = "";
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
stIDs += "," + dr["TransactionID"].ToString();
}
if (dt.Rows.Count > 0)
{
clsSalesTransactionItems = new SalesTransactionItems();
dt = clsSalesTransactionItems.List(stIDs.Remove(0,1));
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.TransactionItems.NewRow();
foreach (DataColumn dc in rptds.TransactionItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.TransactionItems.Rows.Add(drNew);
}
}
break;
#endregion
case ReportTypes.SalesTransactionPerCashier:
#region Sales Transaction Per Cashier/Customer & Per Cashier
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "CashierName", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, false, "CashierName", SortOption.Ascending, 0);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.DailySalesTransaction:
case ReportTypes.WeeklySalesTransaction:
case ReportTypes.MonthlySalesTransaction:
#region Daily, Weekely, Monthly Sales Transaction
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "TransactionDate", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, false, "TransactionDate", SortOption.Ascending, 0);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SalesTransactionPerTerminal:
#region Sales Transaction Per Terminal
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "tblTransactions.TerminalNo", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, false, "TerminalNo", SortOption.Ascending, 0);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SalesTransactionPerItem:
case ReportTypes.SalesTransactionPerItemWoutPurchaseDetails:
#region Sales Transaction Per Item
SaleperItemFilterType enumSaleperItemFilterType = SaleperItemFilterType.ShowBothPositiveAndNegative;
if (rdoShowPositiveOnly.Checked) enumSaleperItemFilterType = SaleperItemFilterType.ShowPositiveOnly;
if (rdoShowNegativeOnly.Checked) enumSaleperItemFilterType = SaleperItemFilterType.ShowNegativeOnly;
clsSalesTransactionItems = new SalesTransactionItems();
if (cboProductGroup.Text == Constants.ALL)
dt = clsSalesTransactionItems.SalesPerItem(TransactionNo + "%", CustomerName + "%", CashierName + "%",
TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
else
dt = clsSalesTransactionItems.SalesPerItemByGroup(strProductGroup + "%", TransactionNo + "%", CustomerName + "%", CashierName + "%",
TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
clsSalesTransactionItems.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SalesTransactionPerItem.NewRow();
foreach (DataColumn dc in rptds.SalesTransactionPerItem.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.SalesTransactionPerItem.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.CashSalesDaily:
case ReportTypes.CashSalesMonthly:
#region Cash-Sales Daily & Cash-Sales Monthly
clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.TransactionStatusName = true;
clsSalesTransactionsColumns.CashPayment = true;
#endregion
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.Cash_Cheque_CreditCard_Credit_Sales(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "tblTransactions.TerminalNo", System.Data.SqlClient.SortOrder.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CashSales.NewRow();
foreach (DataColumn dc in rptds.CashSales.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CashSales.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ChequePaymentList:
#region ChequePaymentList
ChequePaymentDetails clsChequeSearchKeys = new ChequePaymentDetails();
clsChequeSearchKeys.TransactionNo = TransactionNo;
clsChequeSearchKeys.CustomerGroupName = CustomerGroupName;
clsChequeSearchKeys.CustomerName = CustomerName;
clsChequeSearchKeys.CashierName = CashierName;
clsChequeSearchKeys.TerminalNo = TerminalNo;
clsChequeSearchKeys.BranchDetails.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsChequeSearchKeys.TransactionDateFrom = StartTransactionDate;
clsChequeSearchKeys.TransactionDateTo = EndTransactionDate;
clsChequeSearchKeys.ValidityDateFrom = StartValidityDate;
clsChequeSearchKeys.ValidityDateTo = StartValidityDate;
clsChequeSearchKeys.TransactionStatus = Status;
clsChequeSearchKeys.PaymentType = PaymentType;
clsChequeSearchKeys.AgentName = AgentName;
ChequePayments clsChequePayments = new ChequePayments();
dt = clsChequePayments.ListAsReport(clsChequeSearchKeys);
clsChequePayments.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ChequePayments.NewRow();
foreach (DataColumn dc in rptds.ChequePayments.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.ChequePayments.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ChequeSalesDaily:
case ReportTypes.ChequeSalesMonthly:
#region Cheque-Sales Daily & Cheque-Sales Monthly
clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.TransactionStatusName = true;
clsSalesTransactionsColumns.ChequePayment = true;
#endregion
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.Cash_Cheque_CreditCard_Credit_Sales(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "tblTransactions.TerminalNo", System.Data.SqlClient.SortOrder.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ChequeSales.NewRow();
foreach (DataColumn dc in rptds.ChequeSales.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.ChequeSales.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.CreditCardSalesDaily:
case ReportTypes.CreditCardSalesMonthly:
#region Card-Sales Daily Card-Sales Monthly
clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.TransactionStatusName = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
#endregion
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.Cash_Cheque_CreditCard_Credit_Sales(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "tblTransactions.TerminalNo", System.Data.SqlClient.SortOrder.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CreditCardSales.NewRow();
foreach (DataColumn dc in rptds.CreditCardSales.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CreditCardSales.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.PaidOut:
#region PaidOut Report
PaidOutColumns clsPaidOutColumns = new PaidOutColumns();
clsPaidOutColumns.BranchDetails = true;
clsPaidOutColumns.TerminalNo = true;
clsPaidOutColumns.Amount = true;
clsPaidOutColumns.PaymentType = true;
clsPaidOutColumns.DateCreated = true;
clsPaidOutColumns.TerminalNo = true;
clsPaidOutColumns.CashierID = true;
clsPaidOutColumns.CashierName = true;
clsPaidOutColumns.Remarks = true;
PaidOutDetails clsPaidOutSeachKey = new PaidOutDetails();
clsPaidOutSeachKey.StartTransactionDate = StartTransactionDate;
clsPaidOutSeachKey.EndTransactionDate = EndTransactionDate;
PaidOut clsPaidOut = new PaidOut();
dt = clsPaidOut.ListAsDataTable(clsPaidOutColumns, clsPaidOutSeachKey);
clsPaidOut.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.PaidOut.NewRow();
foreach (DataColumn dc in rptds.PaidOut.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.PaidOut.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.Disburse:
#region Disburse Report
DisburseColumns clsDisburseColumns = new DisburseColumns();
clsDisburseColumns.BranchDetails = true;
clsDisburseColumns.TerminalNo = true;
clsDisburseColumns.Amount = true;
clsDisburseColumns.PaymentType = true;
clsDisburseColumns.DateCreated = true;
clsDisburseColumns.TerminalNo = true;
clsDisburseColumns.CashierID = true;
clsDisburseColumns.CashierName = true;
clsDisburseColumns.Remarks = true;
DisburseDetails clsDisburseSeachKey = new DisburseDetails();
clsDisburseSeachKey.StartTransactionDate = StartTransactionDate;
clsDisburseSeachKey.EndTransactionDate = EndTransactionDate;
Disburses clsDisburse = new Disburses();
dt = clsDisburse.ListAsDataTable(clsDisburseColumns, clsDisburseSeachKey);
clsDisburse.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Disburse.NewRow();
foreach (DataColumn dc in rptds.Disburse.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Disburse.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.RecieveOnAccount:
#region WithHold Report
WithholdColumns clsWithHoldColumns = new WithholdColumns();
clsWithHoldColumns.BranchDetails = true;
clsWithHoldColumns.TerminalNo = true;
clsWithHoldColumns.Amount = true;
clsWithHoldColumns.PaymentType = true;
clsWithHoldColumns.DateCreated = true;
clsWithHoldColumns.TerminalNo = true;
clsWithHoldColumns.CashierID = true;
clsWithHoldColumns.CashierName = true;
clsWithHoldColumns.Remarks = true;
WithholdDetails clsWithHoldSeachKey = new WithholdDetails();
clsWithHoldSeachKey.StartTransactionDate = StartTransactionDate;
clsWithHoldSeachKey.EndTransactionDate = EndTransactionDate;
Withhold clsWithHold = new Withhold();
dt = clsWithHold.ListAsDataTable(clsWithHoldColumns, clsWithHoldSeachKey);
clsWithHold.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Withhold.NewRow();
foreach (DataColumn dc in rptds.Withhold.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Withhold.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strProductGroup = cboProductGroup.SelectedItem.Text == Constants.ALL ? string.Empty : cboProductGroup.SelectedItem.Text;
string TransactionNo = txtTransactionNo.Text;
string CustomerGroupName = cboContactGroupName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactGroupName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactGroupName.SelectedItem.Text;
string CustomerName = cboContactName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE","").Trim() : cboContactName.SelectedItem.Text;
string AgentName = cboAgent.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboAgent.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboAgent.SelectedItem.Text;
string CashierName = cboCashierName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboCashierName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboCashierName.SelectedItem.Text;
string TerminalNo = cboTerminalNo.SelectedItem.Text == Constants.ALL ? string.Empty : cboTerminalNo.SelectedItem.Text;
DateTime StartTransactionDate = DateTime.MinValue;
StartTransactionDate = DateTime.TryParse(txtStartTransactionDate.Text + " " + txtStartTime.Text, out StartTransactionDate) ? StartTransactionDate : DateTime.MinValue;
DateTime EndTransactionDate = DateTime.MinValue;
EndTransactionDate = DateTime.TryParse(txtEndTransactionDate.Text + " " + txtEndTime.Text, out EndTransactionDate) ? EndTransactionDate : DateTime.MinValue;
TransactionStatus Status = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), cboTransactionStatus.SelectedItem.Value);
PaymentTypes PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboPaymentType.SelectedItem.Value);
DataTable dt = new DataTable();
ReportDataset rptds = new ReportDataset();
SalesTransactions clsSalesTransactions;
SalesTransactionItems clsSalesTransactionItems;
SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.BranchCode = true;
clsSalesTransactionsColumns.TransactionNo = true;
clsSalesTransactionsColumns.CustomerName = true;
clsSalesTransactionsColumns.CustomerGroupName = true;
clsSalesTransactionsColumns.CashierName = true;
clsSalesTransactionsColumns.TerminalNo = true;
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.DateSuspended = true;
clsSalesTransactionsColumns.DateResumed = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.SubTotal = true;
clsSalesTransactionsColumns.Discount = true;
clsSalesTransactionsColumns.VAT = true;
clsSalesTransactionsColumns.VATableAmount = true;
clsSalesTransactionsColumns.LocalTax = true;
clsSalesTransactionsColumns.AmountPaid = true;
clsSalesTransactionsColumns.CashPayment = true;
clsSalesTransactionsColumns.ChequePayment = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
clsSalesTransactionsColumns.BalanceAmount = true;
clsSalesTransactionsColumns.ChangeAmount = true;
clsSalesTransactionsColumns.DateClosed = true;
clsSalesTransactionsColumns.PaymentType = true;
clsSalesTransactionsColumns.ItemsDiscount = true;
clsSalesTransactionsColumns.Charge = true;
clsSalesTransactionsColumns.CreditPayment = true;
clsSalesTransactionsColumns.CreatedByName = true;
clsSalesTransactionsColumns.AgentName = true;
clsSalesTransactionsColumns.PaxNo = true;
#endregion
SalesTransactionDetails clsSearchKey = new SalesTransactionDetails();
clsSearchKey = new SalesTransactionDetails();
clsSearchKey.TransactionNo = TransactionNo;
clsSearchKey.CustomerGroupName = CustomerGroupName;
clsSearchKey.CustomerName = CustomerName;
clsSearchKey.CashierName = CashierName;
clsSearchKey.TerminalNo = TerminalNo;
clsSearchKey.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsSearchKey.TransactionDateFrom = StartTransactionDate;
clsSearchKey.TransactionDateTo = EndTransactionDate;
clsSearchKey.TransactionStatus = Status;
clsSearchKey.PaymentType = PaymentType;
clsSearchKey.AgentName = AgentName;
clsSearchKey.isConsignmentSearch = cboConsignment.SelectedItem.Value;
if (clsSearchKey.isConsignmentSearch != "-1")
{
clsSearchKey.isConsignment = bool.Parse(cboConsignment.SelectedItem.Value);
}
string strReportType = cboReportType.SelectedValue;
switch (strReportType)
{
case ReportTypes.ANALYTICS_All:
case ReportTypes.ANALYTICS_All_Covers:
#region Daily, Weekely, Monthly Sales Transaction
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "TransactionDate", System.Data.SqlClient.SortOrder.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ANALYTICS_ItemsForPOBasedOnSales:
#region Items For PO Based On Sales
SaleperItemFilterType enumSaleperItemFilterType = SaleperItemFilterType.ShowBothPositiveAndNegative;
if (rdoShowPositiveOnly.Checked) enumSaleperItemFilterType = SaleperItemFilterType.ShowPositiveOnly;
if (rdoShowNegativeOnly.Checked) enumSaleperItemFilterType = SaleperItemFilterType.ShowNegativeOnly;
clsSalesTransactionItems = new SalesTransactionItems();
//if (cboProductGroup.Text == Constants.ALL)
// dt = clsSalesTransactionItems.SalesPerItem(TransactionNo + "%", CustomerName + "%", CashierName + "%",
// TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
//else
// dt = clsSalesTransactionItems.SalesPerItemByGroup(strProductGroup + "%", TransactionNo + "%", CustomerName + "%", CashierName + "%",
// TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
if (cboProductGroup.Text == Constants.ALL)
dt = clsSalesTransactionItems.SalesPerItem(TransactionNo, CustomerName, CashierName, TerminalNo, StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
else
dt = clsSalesTransactionItems.SalesPerItemByGroupProc(strProductGroup, TransactionNo, CustomerName, CashierName, TerminalNo, StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
clsSalesTransactionItems.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SalesTransactionPerItem.NewRow();
foreach (DataColumn dc in rptds.SalesTransactionPerItem.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.SalesTransactionPerItem.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ReportDataset rptds = new ReportDataset();
Data.Contacts clsContacts;
System.Data.DataTable dt;
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
CreditPaymentDetails clsCreditPaymentDetails = new CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new BranchDetails() { BranchID = Int32.Parse(cboBranch.SelectedItem.Value) };
clsCreditPaymentDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.CreditType = CreditType.Individual;
clsCreditPaymentDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPurchases.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPurchases.Columns)
drNew[dc] = "" + dr[dc.ColumnName];
rptds.ContactCreditPurchases.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
CreditPaymentCashDetails clsCreditPaymentCashDetails = new CreditPaymentCashDetails();
clsCreditPaymentCashDetails.BranchDetails = new BranchDetails() { BranchID = Int32.Parse(cboBranch.SelectedItem.Value) };
clsCreditPaymentCashDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.CreditType = CreditType.Individual;
clsCreditPaymentCashDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentCashDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentCashDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPaymentCashDetailedAsDataTable(clsCreditPaymentCashDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPaymentCash.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPaymentCash.Columns)
drNew[dc] = "" + dr[dc.ColumnName];
rptds.ContactCreditPaymentCash.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
Data.Billing clsBilling = new Data.Billing();
dt = clsBilling.ListAsDataTable(GuarantorID: 0, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value), CreditType: CreditType.Individual, BillingDate: DateTime.Parse(cboBillingDate.SelectedItem.Value), CheckIsBillPrinted: false, SortField: "GUA.ContactName, CUS.ContactName", SortOrder: System.Data.SqlClient.SortOrder.Descending);
clsBilling.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Data.DataRow drNew = rptds.CreditBillHeader.NewRow();
foreach (System.Data.DataColumn dc in rptds.CreditBillHeader.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CreditBillHeader.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CustomerCreditSummarizedStatistics:
#region CustomerCreditSummarizedStatistics
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
dt = clsContactCreditCardInfos.IHCreditCardSummarizedStatistics(false);
clsContactCreditCardInfos.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CCISummary.NewRow();
foreach (DataColumn dc in rptds.CCISummary.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CCISummary.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
public static void Main(string[] args)
{
string printername = "";
AssemblyResolver.HandleUnresolvedAssemblies();
#if REPMAN_DOTNET2
// Bug in .Net 1.x, don't enable, but you can use a .manifest file
#if FORMS
Application.EnableVisualStyles();
#endif
#endif
bool dothrow = false;
Report rp = new Report();
try
{
bool asyncexecution = true;
bool stdin = false;
bool pdf = false;
bool metafile = false;
bool showprintdialog = false;
string filename = "";
string pdffilename = "";
string fieldsfilename = "";
bool deletereport = false;
bool showprogress = false;
bool preview = false;
bool showparams = false;
bool compressedpdf = true;
bool systempreview = false;
bool showdata = false;
bool showfields = false;
bool testconnection = false;
string connectionname = "";
bool doprint = true;
bool evaluatetext = false;
bool syntaxcheck = false;
bool doread = true;
string evaltext = "";
string dataset = "";
SortedList <string, string> ParamValues = new SortedList <string, string>();
#if REPMAN_DOTNET2
bool showproviders = false;
string providersfilename = "";
#endif
try
{
for (int i = 0; i < args.Length; i++)
{
if (args[i].Trim().Length > 0)
{
switch (args[i].ToUpper())
{
case "-STDIN":
stdin = true;
break;
case "-PREVIEW":
preview = true;
break;
case "-SHOWPARAMS":
showparams = true;
break;
case "-SYNCEXECUTION":
asyncexecution = false;
break;
case "-SYSTEMPREVIEW":
systempreview = true;
break;
case "-U":
compressedpdf = false;
break;
case "-THROW":
dothrow = true;
break;
case "-PDF":
pdf = true;
if (args.GetUpperBound(0) > i)
{
i++;
pdffilename = args[i];
}
break;
case "-M":
metafile = true;
if (args.GetUpperBound(0) > i)
{
i++;
pdffilename = args[i];
}
break;
case "-SHOWDATA":
showdata = true;
doprint = false;
if (args.GetUpperBound(0) > i)
{
i++;
dataset = args[i];
}
break;
case "-TESTCONNECTION":
doprint = false;
testconnection = true;
if (args.GetUpperBound(0) > i)
{
i++;
connectionname = args[i];
}
break;
case "-EVAL":
doprint = false;
evaluatetext = true;
if (args.GetUpperBound(0) > i)
{
i++;
evaltext = args[i];
}
break;
case "-SYNTAX":
doprint = false;
syntaxcheck = true;
if (args.GetUpperBound(0) > i)
{
i++;
evaltext = args[i];
}
break;
case "-SHOWFIELDS":
showfields = true;
doprint = false;
if (args.GetUpperBound(0) > i)
{
i++;
dataset = args[i];
}
if (args.GetUpperBound(0) > i)
{
i++;
fieldsfilename = args[i];
}
break;
case "-GETPROVIDERS":
showproviders = true;
doprint = false;
doread = false;
if (args.GetUpperBound(0) > i)
{
i++;
providersfilename = args[i];
}
break;
case "-GETPRINTERS":
System.Text.StringBuilder nprinters = new System.Text.StringBuilder();
nprinters.AppendLine("Installed printers:");
foreach (string pname in System.Drawing.Printing.PrinterSettings.InstalledPrinters)
{
nprinters.AppendLine(pname);
}
#if FORMS
MessageBox.Show(nprinters.ToString());
#else
System.Console.WriteLine(nprinters.ToString());
#endif
break;
case "-PRINTERNAME":
if (args.GetUpperBound(0) > i)
{
i++;
printername = args[i];
}
else
{
throw new Exception("A printer name must be provided after -printername");
}
break;
case "-SHOWPROGRESS":
showprogress = true;
break;
case "-DELETEREPORT":
deletereport = true;
break;
case "-PRINTDIALOG":
showprintdialog = true;
break;
default:
// Get parameter names and values
string argname = args[i];
if (argname[0] == '-')
{
bool correctparam = false;
if (argname.Length > 7)
{
if (argname.Substring(0, 6).ToUpper() == "-PARAM")
{
argname = argname.Substring(6, argname.Length - 6);
int indexequ = argname.IndexOf('=');
if (indexequ < 0)
{
throw new Exception("Invalid syntax in -param, -paramPARAMNAME=value syntax must be used");
}
string paramvalue = argname.Substring(indexequ + 1, argname.Length - indexequ - 1);
argname = argname.Substring(0, indexequ);
ParamValues.Add(argname, paramvalue);
System.Console.WriteLine("Decoded parameter: " + argname + " value " + paramvalue);
correctparam = true;
}
}
if (!correctparam)
{
throw new Exception("Invalid argument:" + args[i]);
}
}
else
{
if (filename.Length > 0)
{
filename = args[i];
}
else
{
filename = args[i];
}
}
break;
}
}
}
AddCustomFactories();
#if REPMAN_DOTNET2
if (showproviders)
{
string messageproviders = "";
/*#if REPMAN_MONO
* if (providersfilename.Length == 0)
* {
* foreach (Provider p in ProviderFactory.Providers)
* {
* if (messageproviders.Length!=0)
* messageproviders=messageproviders+(char)13+(char)10;
* messageproviders=messageproviders+p.Name;
*
* }
* MessageBox.Show(messageproviders,"Data providers");
* }
* else
* {
* FileStream providersstream = new FileStream(providersfilename,System.IO.FileMode.Create,System.IO.FileAccess.Write,System.IO.FileShare.None);
* try
* {
* foreach (Provider p2 in ProviderFactory.Providers)
* {
* StreamUtil.SWriteLine(providersstream,p2.Name);
* }
* }
* finally
* {
* providersstream.Close();
* }
*
* }
#else*/
int indexp;
DataTable atable = DbProviderFactories.GetFactoryClasses();
if (providersfilename.Length == 0)
{
bool firebirdfound = false;
bool mysqlfound = false;
bool sqlitefound = false;
for (indexp = 0; indexp < atable.Rows.Count; indexp++)
{
if (messageproviders.Length != 0)
{
messageproviders = messageproviders + (char)13 + (char)10;
}
string nprovider = atable.Rows[indexp][2].ToString();
if (nprovider == DatabaseInfo.FIREBIRD_PROVIDER)
{
firebirdfound = true;
}
if (nprovider == DatabaseInfo.MYSQL_PROVIDER)
{
mysqlfound = true;
}
if (nprovider == DatabaseInfo.SQLITE_PROVIDER)
{
sqlitefound = true;
}
messageproviders = messageproviders + atable.Rows[indexp][2].ToString();
}
if (!firebirdfound)
{
messageproviders = DatabaseInfo.FIREBIRD_PROVIDER + (char)13 + (char)10 + messageproviders;
}
if (!mysqlfound)
{
messageproviders = DatabaseInfo.MYSQL_PROVIDER + (char)13 + (char)10 + messageproviders;
}
if (!sqlitefound)
{
messageproviders = DatabaseInfo.SQLITE_PROVIDER + (char)13 + (char)10 + messageproviders;
}
#if FORMS
MessageBox.Show(messageproviders, "Data providers");
#else
System.Console.WriteLine("Data providers");
System.Console.WriteLine(messageproviders);
#endif
}
else
{
FileStream providersstream = new FileStream(providersfilename, System.IO.FileMode.Create, System.IO.FileAccess.Write, System.IO.FileShare.None);
try
{
bool firebirdfound = false;
bool mysqlfound = false;
bool sqlitefound = false;
Strings nstrings = new Strings();
for (indexp = 0; indexp < atable.Rows.Count; indexp++)
{
string nprovider = atable.Rows[indexp][2].ToString();
if (nprovider == DatabaseInfo.FIREBIRD_PROVIDER)
{
firebirdfound = true;
}
if (nprovider == DatabaseInfo.MYSQL_PROVIDER)
{
mysqlfound = true;
}
if (nprovider == DatabaseInfo.SQLITE_PROVIDER)
{
sqlitefound = true;
}
nstrings.Add(nprovider);
}
if (!firebirdfound)
{
nstrings.Insert(0, DatabaseInfo.FIREBIRD_PROVIDER);
}
if (!mysqlfound)
{
nstrings.Insert(0, DatabaseInfo.MYSQL_PROVIDER);
}
if (!sqlitefound)
{
nstrings.Insert(0, DatabaseInfo.SQLITE_PROVIDER);
}
foreach (string nstring in nstrings)
{
StreamUtil.SWriteLine(providersstream, nstring);
}
}
finally
{
providersstream.Close();
}
}
//#endif
}
#endif
if (doread)
{
if (stdin)
{
Stream astream = System.Console.OpenStandardInput();
rp.LoadFromStream(astream, 8192);
}
else
{
if (filename.Length == 0)
{
throw new Exception("You must provide a report filename");
}
rp.LoadFromFile(filename);
}
foreach (string nparamname in ParamValues.Keys)
{
string nvalue = ParamValues[nparamname];
if (rp.Params.IndexOf(nparamname) < 0)
{
System.Console.WriteLine("Warning: parameter not found created: " + nparamname);
Reportman.Reporting.Param xparam = new Reportman.Reporting.Param(rp);
xparam.Alias = nparamname;
xparam.Visible = false;
rp.Params.Add(xparam);
//throw new Exception("Parameter " + nparamname + " not found");
}
rp.Params[nparamname].Value = nvalue;
}
}
if (showdata)
{
rp.PrintOnlyIfDataAvailable = false;
PrintOutPDF printpdf3 = new PrintOutPDF();
rp.BeginPrint(printpdf3);
#if FORMS
DataShow.ShowData(rp, dataset);
#else
rp.DataInfo[dataset].Connect();
ReportDataset ndataset = rp.DataInfo[dataset].Data;
foreach (DataColumn ncol in ndataset.Columns)
{
string nstring = ncol.ColumnName.PadLeft(30);
if (nstring.Length > 30)
{
nstring = nstring.Substring(0, 30);
}
System.Console.Write(nstring);
}
System.Console.WriteLine();
while (!ndataset.Eof)
{
foreach (DataColumn ncol in ndataset.Columns)
{
string nstring = ndataset.CurrentRow[ncol.ColumnName].ToString().PadLeft(30);
if (nstring.Length > 30)
{
nstring = nstring.Substring(0, 30);
}
System.Console.Write(nstring);
}
System.Console.WriteLine();
ndataset.Next();
}
#endif
}
if (testconnection)
{
int conindex = rp.DatabaseInfo.IndexOf(connectionname);
if (conindex < 0)
{
throw new Exception("Connection name not found:" + connectionname);
}
rp.DatabaseInfo[conindex].Connect();
#if FORMS
MessageBox.Show("Connexion successfull:" + connectionname);
#else
System.Console.WriteLine("Connexion successfull:" + connectionname);
#endif
}
if (showfields)
{
int index = rp.DataInfo.IndexOf(dataset);
if (index < 0)
{
throw new Exception("Dataset not found:" + dataset);
}
rp.DataInfo[index].Connect();
FileStream fstream = new FileStream(fieldsfilename,
System.IO.FileMode.Create, System.IO.FileAccess.Write,
System.IO.FileShare.None);
try
{
rp.DataInfo[index].GetFieldsInfo(fstream);
}
finally
{
fstream.Close();
}
}
if ((evaluatetext) || (syntaxcheck))
{
rp.PrintOnlyIfDataAvailable = false;
PrintOutPDF printpdf2 = new PrintOutPDF();
rp.BeginPrint(printpdf2);
if (evaluatetext)
{
try
{
Variant aresult = rp.Evaluator.EvaluateText(evaltext);
#if FORMS
MessageBox.Show("Result:" + aresult.ToString());
#else
System.Console.WriteLine("Result:" + aresult.ToString());
#endif
}
catch (EvalException e)
{
#if FORMS
MessageBox.Show("Error Line: " + e.SourceLine.ToString() +
" Error position:" + e.SourcePos.ToString() + " - " + e.Message);
#else
System.Console.WriteLine("Error Line: " + e.SourceLine.ToString() +
" Error position:" + e.SourcePos.ToString() + " - " + e.Message);
#endif
}
catch (Exception E)
{
#if FORMS
MessageBox.Show("Error: " + E.Message);
#else
System.Console.WriteLine("Error: " + E.Message);
#endif
}
}
else
{
try
{
rp.Evaluator.CheckSyntax(evaltext);
#if FORMS
MessageBox.Show("Syntax check ok");
#else
System.Console.WriteLine("Syntax check ok");
#endif
}
catch (Exception E)
{
#if FORMS
MessageBox.Show("Error: " + E.Message);
#else
System.Console.WriteLine("Error: " + E.Message);
#endif
}
}
}
// Ask for parameters?
if (doprint)
{
if (showparams)
{
#if FORMS
doprint = ParamsForm.ShowParams(rp);
#else
throw new Exception("Show params not supported in console mode");
#endif
}
}
if (doprint)
{
if (showprogress)
#if FORMS
{
ReportProgressForm fprogres = new ReportProgressForm();
fprogres.SetMetaFile(rp.MetaFile);
fprogres.Show();
}
#else
{ throw new Exception("Show progress not supported in console mode"); }
#endif
if (pdf)
{
rp.AsyncExecution = false;
PrintOutPDF printpdf = new PrintOutPDF();
printpdf.FileName = pdffilename;
printpdf.Compressed = compressedpdf;
printpdf.Print(rp.MetaFile);
}
else
if (metafile)
{
rp.AsyncExecution = false;
rp.TwoPass = true;
PrintOutPDF printpdf = new PrintOutPDF();
printpdf.FileName = "";
printpdf.Compressed = compressedpdf;
printpdf.Print(rp.MetaFile);
rp.MetaFile.SaveToFile(pdffilename, compressedpdf);
}
else
{
rp.AsyncExecution = asyncexecution;
#if FORMS
PrintOutReportWinForms prw = new PrintOutReportWinForms(rp);
prw.Preview = preview;
prw.ShowInTaskbar = true;
prw.SystemPreview = systempreview;
prw.ShowPrintDialog = showprintdialog;
prw.Print(rp.MetaFile);
#else
PrintOutPrint prw = new PrintOutPrint();
if (printername.Length > 0)
{
PrintOutNet.DefaultPrinterName = printername;
}
prw.Print(rp.MetaFile);
#endif
// PrintOutWinForms prw = new PrintOutWinForms();
// prw.OptimizeWMF = WMFOptimization.Gdiplus;
}
}
}
finally
{
if (deletereport)
{
if (filename.Length > 0)
{
System.IO.File.Delete(filename);
}
}
}
}
catch (Exception E)
{
if (!dothrow)
{
int i;
string amessage = E.Message + (char)13 + (char)10;
for (i = 0; i < args.Length; i++)
{
amessage = amessage + (char)13 + (char)10 + "Arg" + i.ToString() + ":" + args[i];
}
Strings astrings = GetParams();
for (i = 0; i < astrings.Count; i++)
{
amessage = amessage + (char)13 + (char)10 + astrings[i];
}
#if FORMS
MessageBox.Show(amessage, "Error");
#else
System.Console.WriteLine(amessage);
#endif
System.Console.WriteLine(E.StackTrace);
}
else
{
PrintParams();
throw;
}
// Variant.WriteStringToUTF8Stream(amessage,System.Console.OpenStandardError());
}
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
Data.TerminalReport clsTerminalReport = new Data.TerminalReport();
Data.Terminal clsTerminal = new Data.Terminal(clsTerminalReport.Connection, clsTerminalReport.Transaction);
Data.TerminalDetails clsTerminalDetails = clsTerminal.Details(txtTerminalNo.Text);
clsTerminalReport.SyncTransactionSales(clsTerminalDetails.BranchDetails.BranchID, txtTerminalNo.Text);
System.Data.DataTable dt = clsTerminalReport.List(txtTerminalNo.Text);
clsTerminalReport.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.TerminalReport.NewRow();
foreach (DataColumn dc in rptds.TerminalReport.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.TerminalReport.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime PostingDateFrom = DateTime.MinValue;
try
{ PostingDateFrom = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch {}
DateTime PostingDateTo = DateTime.MinValue;
try
{ PostingDateTo = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch {}
eSalesFilter clseSalesFilter = new eSalesFilter();
if (lblTask.Text == "esales")
{
clseSalesFilter.FilterIncludeIneSales = true;
clseSalesFilter.IncludeIneSales = true;
}
DataClass clsDataClass = new DataClass();
System.Data.DataTable dt;
string ReportType = cboReportType.SelectedItem.Text;
long lngSupplierID = long.Parse(cboSupplier.SelectedValue);
switch (ReportType)
{
case "Posted PO":
Data.PO clsPO = new Data.PO();
dt = clsPO.ListAsDataTable(POStatus.Posted, new Data.PODetails(), Constants.C_DATE_MIN_VALUE, Constants.C_DATE_MIN_VALUE, PostingDateFrom, PostingDateTo, SupplierID: lngSupplierID, clseSalesFilter: clseSalesFilter);
clsPO.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drPO = rptds.PO.NewRow();
foreach (DataColumn dc in rptds.PO.Columns)
{
drPO[dc] = dr[dc.ColumnName];
}
rptds.PO.Rows.Add(drPO);
}
break;
case "Posted PO Returns":
Data.POReturns clsPOReturns = new Data.POReturns();
dt = clsPOReturns.ListAsDataTable(POReturnStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo, SupplierID: lngSupplierID, clseSalesFilter: clseSalesFilter);
clsPOReturns.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drPOReturns = rptds.POReturns.NewRow();
foreach (DataColumn dc in rptds.POReturns.Columns)
{
drPOReturns[dc] = dr[dc.ColumnName];
}
rptds.POReturns.Rows.Add(drPOReturns);
}
break;
case "Posted Debit Memo":
Data.DebitMemos clsDebitMemos = new Data.DebitMemos();
dt = clsDebitMemos.ListAsDataTable(DebitMemoStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo, SupplierID: lngSupplierID, clseSalesFilter: clseSalesFilter);
clsDebitMemos.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drDebitMemos = rptds.DebitMemo.NewRow();
foreach (DataColumn dc in rptds.DebitMemo.Columns)
{
drDebitMemos[dc] = dr[dc.ColumnName];
}
rptds.DebitMemo.Rows.Add(drDebitMemos);
}
break;
case "By Vendor":
Data.PurchaseAnalysis clsPurchaseAnalysis = new Data.PurchaseAnalysis();
dt = clsPurchaseAnalysis.ByVendor(PostingDateFrom, PostingDateTo);
clsPurchaseAnalysis.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drPAByVendor = rptds.PurchaseAnalysisPerVendor.NewRow();
foreach (DataColumn dc in rptds.PurchaseAnalysisPerVendor.Columns)
{
drPAByVendor[dc] = dr[dc.ColumnName];
}
rptds.PurchaseAnalysisPerVendor.Rows.Add(drPAByVendor);
}
break;
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strReportType = cboReportType.SelectedValue;
Int32 ForReorder = 0;
Int32 OverStock = 0;
if (strReportType == ReportTypes.ItemsForReOrder)
ForReorder = 1;
else if (strReportType == ReportTypes.OverStockItems)
OverStock = 1;
ReportDataset rptds = new ReportDataset();
#region Search Key
Int32 intBranchID = Convert.ToInt32(cboBranch.SelectedItem.Value);
Int64 lngSupplierID = Convert.ToInt32(cboContact.SelectedItem.Value);
Int64 lngProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
Int64 lngProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
string stProductCode = txtProductCode.Text;
#endregion
string ExpirationDate = Constants.C_DATE_MIN_VALUE_STRING;
if (strReportType == ReportTypes.ExpiredInventory)
ExpirationDate = txtExpiryDate.Text;
int isSummary = intBranchID == 0 ? 1 : 0;
ProductInventories clsProductInventories;
System.Data.DataTable dt;
switch (strReportType)
{
case ReportTypes.SummarizedInventoryByBranch:
clsProductInventories = new ProductInventories();
dt = clsProductInventories.SummarizedInventory(SummarizedInventoryTypes.byBranch, intBranchID, lngSupplierID, lngProductGroupID, true);
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SummarizedInventory.NewRow();
foreach (DataColumn dc in rptds.SummarizedInventory.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SummarizedInventory.Rows.Add(drNew);
}
break;
case ReportTypes.SummarizedInventoryBySupplier:
clsProductInventories = new ProductInventories();
dt = clsProductInventories.SummarizedInventory(SummarizedInventoryTypes.bySupplier, intBranchID, lngSupplierID, lngProductGroupID, true);
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SummarizedInventory.NewRow();
foreach (DataColumn dc in rptds.SummarizedInventory.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SummarizedInventory.Rows.Add(drNew);
}
break;
case ReportTypes.SummarizedInventoryByGroup:
clsProductInventories = new ProductInventories();
dt = clsProductInventories.SummarizedInventory(SummarizedInventoryTypes.byGroup, intBranchID, lngSupplierID, lngProductGroupID, true);
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SummarizedInventory.NewRow();
foreach (DataColumn dc in rptds.SummarizedInventory.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SummarizedInventory.Rows.Add(drNew);
}
break;
default:
clsProductInventories = new ProductInventories();
if (cboMonth.SelectedItem.Value == DateTime.Now.Month.ToString("0#") && cboYear.SelectedItem.Value == DateTime.Now.Year.ToString())
{
dt = clsProductInventories.ListAsDataTable(BranchID: intBranchID, ProductCode: stProductCode, ProductGroupID: lngProductGroupID, ProductSubGroupID: lngProductSubGroupID, SupplierID: lngSupplierID, isSummary : isSummary, ExpirationDate: ExpirationDate, ForReorder: ForReorder, OverStock: OverStock);
}else {
dt = clsProductInventories.ListAsDataTable(Month: int.Parse(cboMonth.SelectedItem.Value), Year: int.Parse(cboYear.SelectedItem.Value.ToString()), BranchID: intBranchID, ProductCode: stProductCode, ProductGroupID: lngProductGroupID, ProductSubGroupID: lngProductSubGroupID, SupplierID: lngSupplierID, isSummary: isSummary, ExpirationDate: ExpirationDate, ForReorder: ForReorder, OverStock: OverStock);
}
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
//if (dr[ProductColumnNames.BarCode].ToString() != null && dr[ProductColumnNames.BarCode].ToString() != string.Empty)
//{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drNew);
//}
}
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string ProductGroupName = string.Empty;
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING) ProductGroupName = cboGroup.SelectedItem.Text;
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING) SubGroupName = cboSubGroup.SelectedItem.Text;
DateTime dteIDCStartDate = DateTime.Now.AddDays(-14);
DateTime dteIDCEndDate = DateTime.Now;
try { dteIDCStartDate = Convert.ToDateTime(txtStartTransactionDate.Text + " " + txtStartTime.Text);}catch{}
try { dteIDCEndDate = Convert.ToDateTime(txtEndTransactionDate.Text + " " + txtEndTime.Text);}catch{}
Products clsProduct = new Products();
if (cboSupplier.SelectedItem.Text == Constants.ALL)
{
if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{ clsProduct.UpdateProductReorderOverStockPerSubGroup(long.Parse(cboSubGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate); }
else if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{ clsProduct.UpdateProductReorderOverStockPerGroup(long.Parse(cboGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate); }
else
{ clsProduct.UpdateProductReorderOverStock(dteIDCStartDate, dteIDCEndDate); }
}
else
{
if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{ clsProduct.UpdateProductReorderOverStockPerSupplierPerSubGroup(long.Parse(cboSupplier.SelectedValue), long.Parse(cboSubGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate); }
else if (cboSubGroup.SelectedItem.Text == Constants.ALL)
{ clsProduct.UpdateProductReorderOverStockPerSupplierPerGroup(long.Parse(cboSupplier.SelectedValue), long.Parse(cboGroup.SelectedItem.Value), dteIDCStartDate, dteIDCEndDate); }
else
{ clsProduct.UpdateProductReorderOverStockPerSupplier(long.Parse(cboSupplier.SelectedValue), dteIDCStartDate, dteIDCEndDate); }
}
clsProduct.CommitAndDispose();
clsProduct = new Products();
System.Data.DataTable dt = (clsProduct.SearchDataTable(ProductListFilterType.ShowActiveOnly, string.Empty, long.Parse(cboSupplier.SelectedValue),
long.Parse(cboGroup.SelectedItem.Value), string.Empty, long.Parse(cboSubGroup.SelectedItem.Value), string.Empty, 0, false, false, string.Empty, SortOption.Ascending));
clsProduct.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drProducts = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drProducts[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drProducts);
}
//ProductVariationsMatrix clsMatrix = new ProductVariationsMatrix(clsProduct.Connection, clsProduct.Transaction);
//rptds.Tables.Add(clsMatrix.BaseListAsDataTable(0, "a.ProductID", SortOption.Ascending));
// ds.Tables.Add(clsMatrix.ForReorder("a.Quantity", SortOption.Ascending));
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strProductGroup = cboProductGroup.SelectedItem.Text == Constants.ALL ? string.Empty : cboProductGroup.SelectedItem.Text;
string TransactionNo = txtTransactionNo.Text;
string CustomerGroupName = cboContactGroupName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactGroupName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactGroupName.SelectedItem.Text;
string CustomerName = cboContactName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactName.SelectedItem.Text;
string AgentName = cboAgent.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboAgent.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboAgent.SelectedItem.Text;
string CashierName = cboCashierName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboCashierName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboCashierName.SelectedItem.Text;
string TerminalNo = cboTerminalNo.SelectedItem.Text == Constants.ALL ? string.Empty : cboTerminalNo.SelectedItem.Text;
DateTime StartTransactionDate = DateTime.MinValue;
StartTransactionDate = DateTime.TryParse(txtStartTransactionDate.Text + " " + txtStartTime.Text, out StartTransactionDate) ? StartTransactionDate : DateTime.MinValue;
DateTime EndTransactionDate = DateTime.MinValue;
EndTransactionDate = DateTime.TryParse(txtEndTransactionDate.Text + " " + txtEndTime.Text, out EndTransactionDate) ? EndTransactionDate : DateTime.MinValue;
TransactionStatus Status = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), cboTransactionStatus.SelectedItem.Value);
PaymentTypes PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboPaymentType.SelectedItem.Value);
DataTable dt = new DataTable();
ReportDataset rptds = new ReportDataset();
SalesTransactions clsSalesTransactions;
SalesTransactionItems clsSalesTransactionItems;
SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.BranchCode = true;
clsSalesTransactionsColumns.TransactionNo = true;
clsSalesTransactionsColumns.CustomerName = true;
clsSalesTransactionsColumns.CustomerGroupName = true;
clsSalesTransactionsColumns.CashierName = true;
clsSalesTransactionsColumns.TerminalNo = true;
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.DateSuspended = true;
clsSalesTransactionsColumns.DateResumed = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.SubTotal = true;
clsSalesTransactionsColumns.Discount = true;
clsSalesTransactionsColumns.VAT = true;
clsSalesTransactionsColumns.VATableAmount = true;
clsSalesTransactionsColumns.LocalTax = true;
clsSalesTransactionsColumns.AmountPaid = true;
clsSalesTransactionsColumns.CashPayment = true;
clsSalesTransactionsColumns.ChequePayment = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
clsSalesTransactionsColumns.BalanceAmount = true;
clsSalesTransactionsColumns.ChangeAmount = true;
clsSalesTransactionsColumns.DateClosed = true;
clsSalesTransactionsColumns.PaymentType = true;
clsSalesTransactionsColumns.ItemsDiscount = true;
clsSalesTransactionsColumns.Charge = true;
clsSalesTransactionsColumns.CreditPayment = true;
clsSalesTransactionsColumns.CreatedByName = true;
clsSalesTransactionsColumns.AgentName = true;
clsSalesTransactionsColumns.PaxNo = true;
#endregion
SalesTransactionDetails clsSearchKey = new SalesTransactionDetails();
clsSearchKey = new SalesTransactionDetails();
clsSearchKey.TransactionNo = TransactionNo;
clsSearchKey.CustomerGroupName = CustomerGroupName;
clsSearchKey.CustomerName = CustomerName;
clsSearchKey.CashierName = CashierName;
clsSearchKey.TerminalNo = TerminalNo;
clsSearchKey.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsSearchKey.TransactionDateFrom = StartTransactionDate;
clsSearchKey.TransactionDateTo = EndTransactionDate;
clsSearchKey.TransactionStatus = Status;
clsSearchKey.PaymentType = PaymentType;
clsSearchKey.AgentName = AgentName;
clsSearchKey.isConsignmentSearch = cboConsignment.SelectedItem.Value;
if (clsSearchKey.isConsignmentSearch != "-1")
{
clsSearchKey.isConsignment = bool.Parse(cboConsignment.SelectedItem.Value);
}
string strReportType = cboReportType.SelectedValue;
switch (strReportType)
{
case ReportTypes.ANALYTICS_All:
case ReportTypes.ANALYTICS_All_Covers:
#region Daily, Weekely, Monthly Sales Transaction
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "TransactionDate", System.Data.SqlClient.SortOrder.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ANALYTICS_ItemsForPOBasedOnSales:
#region Items For PO Based On Sales
SaleperItemFilterType enumSaleperItemFilterType = SaleperItemFilterType.ShowBothPositiveAndNegative;
if (rdoShowPositiveOnly.Checked)
{
enumSaleperItemFilterType = SaleperItemFilterType.ShowPositiveOnly;
}
if (rdoShowNegativeOnly.Checked)
{
enumSaleperItemFilterType = SaleperItemFilterType.ShowNegativeOnly;
}
clsSalesTransactionItems = new SalesTransactionItems();
//if (cboProductGroup.Text == Constants.ALL)
// dt = clsSalesTransactionItems.SalesPerItem(TransactionNo + "%", CustomerName + "%", CashierName + "%",
// TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
//else
// dt = clsSalesTransactionItems.SalesPerItemByGroup(strProductGroup + "%", TransactionNo + "%", CustomerName + "%", CashierName + "%",
// TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
if (cboProductGroup.Text == Constants.ALL)
{
dt = clsSalesTransactionItems.SalesPerItem(TransactionNo, CustomerName, CashierName, TerminalNo, StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
}
else
{
dt = clsSalesTransactionItems.SalesPerItemByGroupProc(strProductGroup, TransactionNo, CustomerName, CashierName, TerminalNo, StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
}
clsSalesTransactionItems.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SalesTransactionPerItem.NewRow();
foreach (DataColumn dc in rptds.SalesTransactionPerItem.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SalesTransactionPerItem.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
System.Data.DataTable dt;
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartTransactionDate.Text); }
catch { }
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndTransactionDate.Text); }
catch { }
ContactReward clsContactReward;
switch (cboReportType.SelectedValue)
{
case ReportTypes.RewardsHistory:
#region RewardsHistory
clsContactReward = new ContactReward();
dt = clsContactReward.RewardsMovement(StartTransactionDate, EndTransactionDate, long.Parse(cboContactName.SelectedItem.Value));
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.RewardsMovement.NewRow();
foreach (DataColumn dc in rptds.RewardsMovement.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.RewardsMovement.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.RewardsSummary:
#region RewardsSummary
clsContactReward = new ContactReward();
dt = clsContactReward.RewardsSummary(StartTransactionDate, EndTransactionDate, long.Parse(cboContactName.SelectedItem.Value));
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Rewards.NewRow();
foreach (DataColumn dc in rptds.Rewards.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Rewards.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.RewardsSummaryStatistics:
#region RewardsSummaryStatistics
clsContactReward = new ContactReward();
dt = clsContactReward.SummarizedStatistics();
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.RewardsSummary.NewRow();
foreach (DataColumn dc in rptds.RewardsSummary.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.RewardsSummary.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
System.Data.DataTable dt;
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartTransactionDate.Text); }
catch { }
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndTransactionDate.Text); }
catch { }
ContactReward clsContactReward;
switch (cboReportType.SelectedValue)
{
case ReportTypes.RewardsHistory:
#region RewardsHistory
clsContactReward = new ContactReward();
dt = clsContactReward.RewardsMovement(StartTransactionDate, EndTransactionDate, long.Parse(cboContactName.SelectedItem.Value));
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.RewardsMovement.NewRow();
foreach (DataColumn dc in rptds.RewardsMovement.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.RewardsMovement.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.RewardsSummary:
#region RewardsSummary
clsContactReward = new ContactReward();
dt = clsContactReward.RewardsSummary(StartTransactionDate, EndTransactionDate, long.Parse(cboContactName.SelectedItem.Value));
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Rewards.NewRow();
foreach (DataColumn dc in rptds.Rewards.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Rewards.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.RewardsSummaryStatistics:
#region RewardsSummaryStatistics
clsContactReward = new ContactReward();
dt = clsContactReward.SummarizedStatistics();
clsContactReward.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.RewardsSummary.NewRow();
foreach (DataColumn dc in rptds.RewardsSummary.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.RewardsSummary.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
//long lngProductGroupName = long.Parse(cboProductGroup.SelectedItem.Value);
//long lngSubGroupName = long.Parse(cboSubGroup.SelectedItem.Value);
string ProductGroupName = string.Empty;
if (cboProductGroup.SelectedItem.Value != Constants.ZERO_STRING) ProductGroupName = cboProductGroup.SelectedItem.Value;
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING) SubGroupName = cboSubGroup.SelectedItem.Value;
string ReportType = cboReportType.SelectedItem.Text;
ProductColumns clsProductColumns = new ProductColumns();
#region clsProductColumns
clsProductColumns.ProductCode = true;
clsProductColumns.BarCode = true;
clsProductColumns.BarCode2 = true;
clsProductColumns.BarCode3 = true;
clsProductColumns.ProductDesc = true;
clsProductColumns.ProductSubGroupName = true;
clsProductColumns.BaseUnitName = true;
clsProductColumns.UnitName = true;
clsProductColumns.ProductGroupName = true;
clsProductColumns.DateCreated = true;
clsProductColumns.Price = true;
clsProductColumns.Quantity = true;
clsProductColumns.MinThreshold = true;
clsProductColumns.MaxThreshold = true;
clsProductColumns.PurchasePrice = true;
clsProductColumns.SupplierName = true;
clsProductColumns.QuantityIN = true;
clsProductColumns.QuantityOUT = true;
clsProductColumns.RIDMinThreshold = true;
clsProductColumns.RIDMaxThreshold = true;
clsProductColumns.RID = true;
//clsProductColumns.BranchActualQuantity = true;
//clsProductColumns.BranchQuantity = true;
//clsProductColumns.BranchQuantityIN = true;
//clsProductColumns.BranchQuantityOUT = true;
#endregion
ProductDetails clsSearchKey = new ProductDetails();
#region Search Key
clsSearchKey.BranchID = Convert.ToInt32(cboBranch.SelectedItem.Value);
clsSearchKey.SupplierID = Convert.ToInt32(cboContact.SelectedItem.Value);
clsSearchKey.ProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
clsSearchKey.ProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
clsSearchKey.ProductCode = txtProductCode.Text;
#endregion
Products clsProduct = new Products();
clsProduct.GetConnection();
ProductInventories clsProductInventories = new ProductInventories(clsProduct.Connection, clsProduct.Transaction);
DataTable dt;
string ProductIDs = null;
switch (cboReportType.SelectedValue)
{
case ReportTypes.ProductList:
#region Products List
dt = clsProductInventories.ListAsDataTable(Int32.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductPriceList:
#region Products Price List
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
ProductIDs += dr["ProductID"].ToString() + ",";
}
break;
#endregion
case ReportTypes.ProductListWithInvalidMatrix:
#region Products List With Invalid Unit Matrix
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text, ShowOnlyWithInvalidUnitMatrix: true);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.WeightedProductsForWeighingScale:
case ReportTypes.CountedProductsForWeighingScale:
#region Weighted and Counted Products For Weighing Scale
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
if (dr[ProductColumnNames.BarCode].ToString() != null && dr[ProductColumnNames.BarCode].ToString() != string.Empty)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
ProductIDs += dr["ProductID"].ToString() + ",";
}
}
break;
#endregion
case ReportTypes.ProductsInDemoReport:
#region Products In Demo
DateTime StartTransactionDate = DateTime.TryParse(txtStartDate.Text + " " + txtStartTime.Text, out StartTransactionDate) ? StartTransactionDate : DateTime.MinValue;
DateTime EndTransactionDate = DateTime.TryParse(txtEndDate.Text + " " + txtEndTime.Text, out EndTransactionDate) ? EndTransactionDate : DateTime.MinValue;
SalesTransactionItems clsSalesTransactionItemsDemo = new SalesTransactionItems();
System.Data.DataTable dtDemo = clsSalesTransactionItemsDemo.ProductsInDemoReport(Int32.Parse(cboBranch.SelectedItem.Value), Int64.Parse(cboContact.SelectedItem.Value), cboProductGroup.SelectedItem.Text, cboSubGroup.SelectedItem.Text, txtProductCode.Text, "", StartTransactionDate, EndTransactionDate);
clsSalesTransactionItemsDemo.CommitAndDispose();
foreach (DataRow dr in dtDemo.Rows)
{
DataRow drNew = rptds.ProductsInDemo.NewRow();
foreach (DataColumn dc in rptds.ProductsInDemo.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.ProductsInDemo.Rows.Add(drNew);
}
break;
#endregion
default:
return;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string TransactionNo = Session["tranno"].ToString();
ReportDataset rptds = new ReportDataset();
Stock clsStock = new Stock();
DataTable dt = clsStock.Search(TransactionNo);
clsStock.CommitAndDispose();
long StockID = Convert.ToInt64(dt.Rows[0]["StockID"].ToString());
StockItem clsStockItem = new StockItem();
DataTable dtItems = clsStockItem.ListAsDataTable(StockID);
clsStockItem.CommitAndDispose();
foreach(DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Stocks.NewRow();
foreach (DataColumn dc in rptds.Stocks.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Stocks.Rows.Add(drNew);
}
foreach(DataRow dr in dtItems.Rows)
{
DataRow drNew = rptds.StockItems.NewRow();
foreach (DataColumn dc in rptds.StockItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.StockItems.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DataTable dt;
switch (cboReportType.SelectedValue)
{
case ReportTypes.CustomerCredit:
#region Customer Credit
Customer clsCustomer = new Customer();
dt = clsCustomer.CustomersDataTable(cboContactName.SelectedItem.Text);
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerDetails.NewRow();
foreach (DataColumn dc in rptds.CustomerDetails.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CustomerDetails.Rows.Add(drNew);
}
SalesTransactions clsSalesTransactions = new SalesTransactions(clsCustomer.Connection, clsCustomer.Transaction);
dt = clsSalesTransactions.ListForPaymentDataTable(Convert.ToInt64(cboContactName.SelectedItem.Value));
clsCustomer.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerCredit.NewRow();
foreach (DataColumn dc in rptds.CustomerCredit.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CustomerCredit.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.CustomerCreditListWCredit:
#region Customers List With Credit
Contacts clsContact = new Contacts();
dt = clsContact.CustomerAdvanceSearch(null, cboContactName.SelectedItem.Text, cboCustomerGroup.SelectedItem.Value, true, "ContactID", SortOption.Ascending);
clsContact.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Contacts.NewRow();
foreach (DataColumn dc in rptds.Contacts.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Contacts.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ContactGroupCategory enumContactGroupCategory = (ContactGroupCategory)Enum.Parse(typeof(ContactGroupCategory), cboContactGroupCategory.SelectedValue);
ReportDataset rptds = new ReportDataset();
Contacts clsContact = new Contacts();
System.Data.DataTable dt = clsContact.AdvanceSearchDataTable(enumContactGroupCategory, cboContactCode.SelectedItem.Value, cboContactName.SelectedItem.Value, Convert.ToInt16(cboDeleted.SelectedItem.Value), Convert.ToInt32(cboGroup.SelectedItem.Value), false, "ContactID", SortOption.Ascending);
clsContact.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Contacts.NewRow();
foreach (DataColumn dc in rptds.Contacts.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Contacts.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DataRow drNew;
/****************************sales transaction *****************************/
SalesTransactions clsSalesTransactions = new SalesTransactions();
SalesTransactionDetails clsDetails = clsSalesTransactions.Details(txtTransactionNo.Text, txtTerminalNo.Text, int.Parse(cboBranch.SelectedItem.Value));
clsSalesTransactions.CommitAndDispose();
if (clsDetails.isExist == true )
{
drNew = rptds.Transactions.NewRow();
drNew["BranchCode"] = clsDetails.BranchCode;
drNew["TransactionID"] = clsDetails.TransactionID;
drNew["TransactionNo"] = clsDetails.TransactionNo;
drNew["CustomerName"] = clsDetails.CustomerName;
drNew["CashierName"] = clsDetails.CashierName;
drNew["TerminalNo"] = clsDetails.TerminalNo;
drNew["TransactionDate"] = clsDetails.TransactionDate;
drNew["DateSuspended"] = clsDetails.DateSuspended.ToString();
drNew["DateResumed"] = clsDetails.DateResumed;
drNew["TransactionStatus"] = clsDetails.TransactionStatus;
drNew["SubTotal"] = clsDetails.SubTotal;
drNew["ItemsDiscount"] = clsDetails.ItemsDiscount;
drNew["Discount"] = clsDetails.Discount;
drNew["VAT"] = clsDetails.VAT;
drNew["VatableAmount"] = clsDetails.VATableAmount;
drNew["LocalTax"] = clsDetails.LocalTax;
drNew["AmountPaid"] = clsDetails.AmountPaid;
drNew["CashPayment"] = clsDetails.CashPayment;
drNew["ChequePayment"] = clsDetails.ChequePayment;
drNew["CreditCardPayment"] = clsDetails.CreditCardPayment;
drNew["BalanceAmount"] = clsDetails.BalanceAmount;
drNew["ChangeAmount"] = clsDetails.ChangeAmount;
drNew["DateClosed"] = clsDetails.DateClosed;
drNew["PaymentType"] = clsDetails.PaymentType.ToString("d");
drNew["ItemsDiscount"] = clsDetails.ItemsDiscount;
drNew["Charge"] = clsDetails.Charge;
drNew["CreditPayment"] = clsDetails.CreditPayment;
drNew["CreatedByName"] = clsDetails.CreatedByName;
rptds.Transactions.Rows.Add(drNew);
/****************************sales transaction items*****************************/
SalesTransactionItems clsSalesTransactionItems = new SalesTransactionItems();
System.Data.DataTable dt = clsSalesTransactionItems.List(clsDetails.TransactionID, clsDetails.TransactionDate,"TransactionItemsID",SortOption.Ascending);
clsSalesTransactionItems.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
drNew = rptds.TransactionItems.NewRow();
foreach (DataColumn dc in rptds.TransactionItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.TransactionItems.Rows.Add(drNew);
}
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string ContactCode = string.Empty;
if (cboContact.SelectedItem.Value != Constants.ZERO_STRING)
{
ContactCode = cboContact.SelectedItem.Text;
}
string ProductGroupName = string.Empty;
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
ProductGroupName = cboGroup.SelectedItem.Text;
}
string ProductSubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
ProductSubGroupName = cboSubGroup.SelectedItem.Text;
}
System.Data.DataTable dt = null;
if (lblType.Text == "invcount")
{
Int64 lngSupplierID = Convert.ToInt64(cboContact.SelectedItem.Value);
Int64 lngProductgroupID = Convert.ToInt64(cboGroup.SelectedItem.Value);
Int64 lngProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
ProductInventories clsProductInventories = new ProductInventories();
dt = clsProductInventories.ListAsDataTable(BranchID: int.Parse(lblBranchID.Text), SupplierID: lngSupplierID, ProductGroupID: lngProductgroupID, ProductSubGroupID: lngProductSubGroupID, clsProductListFilterType: ProductListFilterType.ShowActiveOnly, SortField: "ProductCode ASC, MatrixDescription ASC, BarCode1", SortOrder: SortOption.Desscending);
//Contacts clsContacts = new Contacts(clsProductInventories.Connection, clsProductInventories.Transaction);
//ContactDetails clsContactDetails = clsContacts.Details(lngSupplierID);
clsProductInventories.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drInventory = rptds.ProductInventory.NewRow();
foreach (DataColumn dc in rptds.ProductInventory.Columns)
{
drInventory[dc] = dr[dc.ColumnName];
}
rptds.ProductInventory.Rows.Add(drInventory);
}
}
else
{
Data.Inventory clsInventory = new Data.Inventory();
dt = clsInventory.DataList(cboInventoryNo.SelectedItem.Text, chkIncludeShortOverProducts.Checked, long.Parse(cboContact.SelectedItem.Value), long.Parse(cboGroup.SelectedItem.Value), SortField: "InventoryID", SortOrder: SortOption.Ascending);
clsInventory.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drInventory = rptds.Inventory.NewRow();
foreach (DataColumn dc in rptds.Inventory.Columns)
{
drInventory[dc] = dr[dc.ColumnName];
}
rptds.Inventory.Rows.Add(drInventory);
}
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
ChartOfAccounts clsChartOfAccount = new ChartOfAccounts();
MySqlDataReader myreader = clsChartOfAccount.BalanceSheet("ChartOfAccountID", SortOption.Ascending);
clsChartOfAccount.CommitAndDispose();
while(myreader.Read())
{
DataRow drNew = rptds.ChartOfAccount.NewRow();
foreach (DataColumn dc in rptds.ChartOfAccount.Columns)
drNew[dc] = "" + myreader[dc.ColumnName];
rptds.ChartOfAccount.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime PostingDateFrom = DateTime.MinValue;
try
{ PostingDateFrom = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch {}
DateTime PostingDateTo = DateTime.MinValue;
try
{ PostingDateTo = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch {}
DataClass clsDataClass = new DataClass();
System.Data.DataTable dt;
string ReportType = cboReportType.SelectedItem.Text;
switch (ReportType)
{
case "Posted SO":
Data.SO clsSO = new Data.SO();
dt = clsDataClass.DataReaderToDataTable(clsSO.List(SOStatus.Posted, PostingDateFrom, PostingDateTo));
clsSO.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drSO = rptds.SO.NewRow();
foreach (DataColumn dc in rptds.SO.Columns)
{
drSO[dc] = dr[dc.ColumnName];
}
rptds.SO.Rows.Add(drSO);
}
break;
case "Posted SO Returns":
Data.SOReturns clsSOReturns = new Data.SOReturns();
dt = clsDataClass.DataReaderToDataTable(clsSOReturns.List(SOReturnStatus.Posted, PostingDateFrom, PostingDateTo));
clsSOReturns.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drSOReturns = rptds.SOReturns.NewRow();
foreach (DataColumn dc in rptds.SOReturns.Columns)
{
drSOReturns[dc] = dr[dc.ColumnName];
}
rptds.SOReturns.Rows.Add(drSOReturns);
}
break;
case "Posted Credit Memo":
Data.CreditMemos clsCreditMemos = new Data.CreditMemos();
dt = clsDataClass.DataReaderToDataTable(clsCreditMemos.List(CreditMemoStatus.Posted, PostingDateFrom, PostingDateTo));
clsCreditMemos.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drCreditMemos = rptds.CreditMemo.NewRow();
foreach (DataColumn dc in rptds.CreditMemo.Columns)
{
drCreditMemos[dc] = dr[dc.ColumnName];
}
rptds.CreditMemo.Rows.Add(drCreditMemos);
}
break;
case "By Vendor":
Data.SalesAnalysis clsSalesAnalysis = new Data.SalesAnalysis();
dt = clsSalesAnalysis.ByVendor(PostingDateFrom, PostingDateTo);
clsSalesAnalysis.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drPAByVendor = rptds.SalesAnalysisPerCustomer.NewRow();
foreach (DataColumn dc in rptds.SalesAnalysisPerCustomer.Columns)
{
drPAByVendor[dc] = dr[dc.ColumnName];
}
rptds.SalesAnalysisPerCustomer.Rows.Add(drPAByVendor);
}
break;
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
Int64 iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["branchtransferid"].ToString() != null)
{ iID = Convert.ToInt64(Request.QueryString["branchtransferid"].ToString()); }
else
{ iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["branchtransferid"].ToString(), Session.SessionID)); }
}
catch { iID = Convert.ToInt64(Common.Decrypt(lblReferrer.Text.Substring(lblReferrer.Text.IndexOf("branchtransferid") + 13), Session.SessionID)); }
ReportDataset rptds = new ReportDataset();
BranchTransfer clsBranchTransfer = new BranchTransfer();
System.Data.DataTable dt = clsBranchTransfer.ListAsDataTable(iID);
BranchTransferItem clsBranchTransferItem = new BranchTransferItem(clsBranchTransfer.Connection, clsBranchTransfer.Transaction);
System.Data.DataTable dtitems = clsBranchTransferItem.ListAsDataTable(iID);
clsBranchTransfer.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.BranchTransfer.NewRow();
foreach (DataColumn dc in rptds.BranchTransfer.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.BranchTransfer.Rows.Add(drNew);
}
foreach (System.Data.DataRow dr in dtitems.Rows)
{
DataRow drNew = rptds.BranchTransferItems.NewRow();
foreach (DataColumn dc in rptds.BranchTransferItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.BranchTransferItems.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strProductGroup = cboProductGroup.SelectedItem.Text == Constants.ALL ? string.Empty : cboProductGroup.SelectedItem.Text;
string TransactionNo = txtTransactionNo.Text;
string CustomerName = cboContactName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE","").Trim() : cboContactName.SelectedItem.Text;
string AgentName = cboAgent.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboAgent.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboAgent.SelectedItem.Text;
string CashierName = cboCashierName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboCashierName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboCashierName.SelectedItem.Text;
string TerminalNo = cboTerminalNo.SelectedItem.Text == Constants.ALL ? string.Empty : cboTerminalNo.SelectedItem.Text;
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartTransactionDate.Text + " " + txtStartTime.Text); }
catch { }
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndTransactionDate.Text + " " + txtEndTime.Text); }
catch { }
TransactionStatus Status = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), cboTransactionStatus.SelectedItem.Value);
PaymentTypes PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboPaymentType.SelectedItem.Value);
DataTable dt = new DataTable();
ReportDataset rptds = new ReportDataset();
SalesTransactions clsSalesTransactions;
SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.BranchCode = true;
clsSalesTransactionsColumns.TransactionNo = true;
clsSalesTransactionsColumns.CustomerName = true;
clsSalesTransactionsColumns.CustomerGroupName = true;
clsSalesTransactionsColumns.CashierName = true;
clsSalesTransactionsColumns.TerminalNo = true;
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.DateSuspended = true;
clsSalesTransactionsColumns.DateResumed = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.SubTotal = true;
clsSalesTransactionsColumns.Discount = true;
clsSalesTransactionsColumns.VAT = true;
clsSalesTransactionsColumns.VATableAmount = true;
clsSalesTransactionsColumns.LocalTax = true;
clsSalesTransactionsColumns.AmountPaid = true;
clsSalesTransactionsColumns.CashPayment = true;
clsSalesTransactionsColumns.ChequePayment = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
clsSalesTransactionsColumns.BalanceAmount = true;
clsSalesTransactionsColumns.ChangeAmount = true;
clsSalesTransactionsColumns.DateClosed = true;
clsSalesTransactionsColumns.PaymentType = true;
clsSalesTransactionsColumns.ItemsDiscount = true;
clsSalesTransactionsColumns.Charge = true;
clsSalesTransactionsColumns.CreditPayment = true;
clsSalesTransactionsColumns.CreatedByName = true;
clsSalesTransactionsColumns.AgentName = true;
clsSalesTransactionsColumns.PaxNo = true;
#endregion
SalesTransactionDetails clsSearchKey = new SalesTransactionDetails();
clsSearchKey = new SalesTransactionDetails();
clsSearchKey.TransactionNo = TransactionNo;
clsSearchKey.CustomerName = CustomerName;
clsSearchKey.CashierName = CashierName;
clsSearchKey.TerminalNo = TerminalNo;
clsSearchKey.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsSearchKey.TransactionDateFrom = StartTransactionDate;
clsSearchKey.TransactionDateTo = EndTransactionDate;
clsSearchKey.TransactionStatus = Status;
clsSearchKey.PaymentType = PaymentType;
clsSearchKey.AgentName = AgentName;
clsSearchKey.isConsignmentSearch = cboConsignment.SelectedItem.Value;
if (clsSearchKey.isConsignmentSearch != "-1")
{
clsSearchKey.isConsignment = bool.Parse(cboConsignment.SelectedItem.Value);
}
bool boWithTrustFund = true;
string strReportType = cboReportType.SelectedValue;
switch (strReportType)
{
case ReportTypes.SalesPerDay:
#region Sales Per Day
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey.BranchID, clsSearchKey.TerminalNo, TransactionStatus: clsSearchKey.TransactionStatus, TransactionDateFrom: StartTransactionDate, TransactionDateTo: EndTransactionDate, WithTF: boWithTrustFund);
//dt = clsSalesTransactions.SalesPerDay(StartTransactionDate, EndTransactionDate, boWithTrustFund);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.SummarizeDailySales:
#region SummarizeDailySales
Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory();
dt = clsTerminalReportHistory.SummarizedDailySalesReport(Int32.Parse(cboBranch.SelectedItem.Value), TerminalNo, true, StartTransactionDate, EndTransactionDate, boWithTrustFund);
clsTerminalReportHistory.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SalesReport.NewRow();
foreach (DataColumn dc in rptds.SalesReport.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.SalesReport.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strReportType = cboReportType.SelectedValue;
Int32 ForReorder = 0;
Int32 OverStock = 0;
if (strReportType == ReportTypes.ItemsForReOrder)
{
ForReorder = 1;
}
else if (strReportType == ReportTypes.OverStockItems)
{
OverStock = 1;
}
ReportDataset rptds = new ReportDataset();
#region Search Key
Int32 intBranchID = Convert.ToInt32(cboBranch.SelectedItem.Value);
Int64 lngSupplierID = Convert.ToInt32(cboContact.SelectedItem.Value);
Int64 lngProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
Int64 lngProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
string stProductCode = txtProductCode.Text;
#endregion
string ExpirationDate = Constants.C_DATE_MIN_VALUE_STRING;
if (strReportType == ReportTypes.ExpiredInventory)
{
ExpirationDate = txtExpiryDate.Text;
}
int isSummary = intBranchID == 0 ? 1 : 0;
ProductInventories clsProductInventories;
System.Data.DataTable dt;
switch (strReportType)
{
case ReportTypes.SummarizedInventoryByBranch:
clsProductInventories = new ProductInventories();
dt = clsProductInventories.SummarizedInventory(SummarizedInventoryTypes.byBranch, intBranchID, lngSupplierID, lngProductGroupID, true);
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SummarizedInventory.NewRow();
foreach (DataColumn dc in rptds.SummarizedInventory.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SummarizedInventory.Rows.Add(drNew);
}
break;
case ReportTypes.SummarizedInventoryBySupplier:
clsProductInventories = new ProductInventories();
dt = clsProductInventories.SummarizedInventory(SummarizedInventoryTypes.bySupplier, intBranchID, lngSupplierID, lngProductGroupID, true);
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SummarizedInventory.NewRow();
foreach (DataColumn dc in rptds.SummarizedInventory.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SummarizedInventory.Rows.Add(drNew);
}
break;
case ReportTypes.SummarizedInventoryByGroup:
clsProductInventories = new ProductInventories();
dt = clsProductInventories.SummarizedInventory(SummarizedInventoryTypes.byGroup, intBranchID, lngSupplierID, lngProductGroupID, true);
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SummarizedInventory.NewRow();
foreach (DataColumn dc in rptds.SummarizedInventory.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SummarizedInventory.Rows.Add(drNew);
}
break;
default:
clsProductInventories = new ProductInventories();
if (cboMonth.SelectedItem.Value == DateTime.Now.Month.ToString("0#") && cboYear.SelectedItem.Value == DateTime.Now.Year.ToString())
{
dt = clsProductInventories.ListAsDataTable(BranchID: intBranchID, ProductCode: stProductCode, ProductGroupID: lngProductGroupID, ProductSubGroupID: lngProductSubGroupID, SupplierID: lngSupplierID, isSummary: isSummary, ExpirationDate: ExpirationDate, ForReorder: ForReorder, OverStock: OverStock);
}
else
{
dt = clsProductInventories.ListAsDataTable(Month: int.Parse(cboMonth.SelectedItem.Value), Year: int.Parse(cboYear.SelectedItem.Value.ToString()), BranchID: intBranchID, ProductCode: stProductCode, ProductGroupID: lngProductGroupID, ProductSubGroupID: lngProductSubGroupID, SupplierID: lngSupplierID, isSummary: isSummary, ExpirationDate: ExpirationDate, ForReorder: ForReorder, OverStock: OverStock);
}
clsProductInventories.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
//if (dr[ProductColumnNames.BarCode].ToString() != null && dr[ProductColumnNames.BarCode].ToString() != string.Empty)
//{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Products.Rows.Add(drNew);
//}
}
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
Int64 iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["retid"].ToString() != null)
{ iID = Convert.ToInt64(Request.QueryString["retid"].ToString()); }
else
{ iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["retid"].ToString(), Session.SessionID)); }
lblReferrer.ToolTip = iID.ToString();
}
catch { iID = long.Parse(lblReferrer.ToolTip); }
ReportDataset rptds = new ReportDataset();
POReturns clsPOReturns = new POReturns();
System.Data.DataTable dt = clsPOReturns.ListAsDataTable(DebitMemoID: iID);
POReturnItems clsPOReturnItems = new POReturnItems(clsPOReturns.Connection, clsPOReturns.Transaction);
System.Data.DataTable dtitems = clsPOReturnItems.ListAsDataTable(iID);
clsPOReturns.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.POReturns.NewRow();
foreach (DataColumn dc in rptds.POReturns.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.POReturns.Rows.Add(drNew);
}
foreach(System.Data.DataRow dr in dtitems.Rows)
{
DataRow drNew = rptds.POReturnItems.NewRow();
foreach (DataColumn dc in rptds.POReturnItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.POReturnItems.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime PostingDateFrom = DateTime.MinValue;
try
{ PostingDateFrom = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch{}
DateTime PostingDateTo = DateTime.MinValue;
try
{ PostingDateTo = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch{}
System.Data.DataTable dt;
string ReportType = cboReportType.SelectedItem.Text;
switch (ReportType)
{
case "Posted PO":
Data.PO clsPO = new Data.PO();
dt = clsPO.ListAsDataTable(POStatus.Posted, new Data.PODetails(), Constants.C_DATE_MIN_VALUE, Constants.C_DATE_MIN_VALUE, PostingDateFrom, PostingDateTo);
clsPO.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drPO = rptds.PO.NewRow();
foreach (DataColumn dc in rptds.PO.Columns)
drPO[dc] = dr[dc.ColumnName];
rptds.PO.Rows.Add(drPO);
}
break;
case "Posted PO Returns":
Data.POReturns clsPOReturns = new Data.POReturns();
dt = clsPOReturns.ListAsDataTable(POReturnStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo);
clsPOReturns.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drPOReturns = rptds.POReturns.NewRow();
foreach (DataColumn dc in rptds.POReturns.Columns)
drPOReturns[dc] = dr[dc.ColumnName];
rptds.POReturns.Rows.Add(drPOReturns);
}
break;
case "Posted Debit Memo":
Data.DebitMemos clsDebitMemos = new Data.DebitMemos();
dt = clsDebitMemos.ListAsDataTable(DebitMemoStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo);
clsDebitMemos.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drDebitMemos = rptds.DebitMemo.NewRow();
foreach (DataColumn dc in rptds.DebitMemo.Columns)
drDebitMemos[dc] = dr[dc.ColumnName];
rptds.DebitMemo.Rows.Add(drDebitMemos);
}
break;
case "By Vendor":
Data.PurchaseAnalysis clsPurchaseAnalysis = new Data.PurchaseAnalysis();
dt = clsPurchaseAnalysis.ByVendor(PostingDateFrom, PostingDateTo);
clsPurchaseAnalysis.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drPAByVendor = rptds.PurchaseAnalysisPerVendor.NewRow();
foreach (DataColumn dc in rptds.PurchaseAnalysisPerVendor.Columns)
drPAByVendor[dc] = dr[dc.ColumnName];
rptds.PurchaseAnalysisPerVendor.Rows.Add(drPAByVendor);
}
break;
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
ReportDataset ds = new ReportDataset();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "DT_ReportDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
ReportDataset ds = new ReportDataset();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
private void SetDataSource(ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ReportDataset rptds = new ReportDataset();
Data.Contacts clsContacts;
System.Data.DataTable dt;
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
CreditPaymentDetails clsCreditPaymentDetails = new CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new BranchDetails()
{
BranchID = Int32.Parse(cboBranch.SelectedItem.Value)
};
clsCreditPaymentDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.CreditType = CreditType.Individual;
clsCreditPaymentDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPurchases.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPurchases.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.ContactCreditPurchases.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
CreditPaymentCashDetails clsCreditPaymentCashDetails = new CreditPaymentCashDetails();
clsCreditPaymentCashDetails.BranchDetails = new BranchDetails()
{
BranchID = Int32.Parse(cboBranch.SelectedItem.Value)
};
clsCreditPaymentCashDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.CreditType = CreditType.Individual;
clsCreditPaymentCashDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentCashDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentCashDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPaymentCashDetailedAsDataTable(clsCreditPaymentCashDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPaymentCash.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPaymentCash.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.ContactCreditPaymentCash.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
Data.Billing clsBilling = new Data.Billing();
dt = clsBilling.ListAsDataTable(GuarantorID: 0, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value), CreditType: CreditType.Individual, BillingDate: DateTime.Parse(cboBillingDate.SelectedItem.Value), CheckIsBillPrinted: false, SortField: "GUA.ContactName, CUS.ContactName", SortOrder: System.Data.SqlClient.SortOrder.Descending);
clsBilling.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Data.DataRow drNew = rptds.CreditBillHeader.NewRow();
foreach (System.Data.DataColumn dc in rptds.CreditBillHeader.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CreditBillHeader.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CustomerCreditSummarizedStatistics:
#region CustomerCreditSummarizedStatistics
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
dt = clsContactCreditCardInfos.IHCreditCardSummarizedStatistics(false);
clsContactCreditCardInfos.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CCISummary.NewRow();
foreach (DataColumn dc in rptds.CCISummary.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CCISummary.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSourceProducts(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string ProductGroupName = string.Empty;
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING) ProductGroupName = cboGroup.SelectedItem.Text;
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING) SubGroupName = cboSubGroup.SelectedItem.Text;
Products clsProduct = new Products();
System.Data.DataTable dtProductInventoryReport = clsProduct.InventoryReport(ProductGroupName, SubGroupName, txtProductCodeSearch.Text);
//ProductVariationsMatrix clsMatrix = new ProductVariationsMatrix(clsProduct.Connection, clsProduct.Transaction);
//System.Data.DataTable dtMatrixInventoryReport = clsMatrix.InventoryReport(ProductGroupName, SubGroupName, txtProductCodeSearch.Text);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dtProductInventoryReport.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DataRow drNew;
/****************************sales transaction *****************************/
SalesTransactions clsSalesTransactions = new SalesTransactions();
SalesTransactionDetails clsDetails = clsSalesTransactions.Details(txtTransactionNo.Text, txtTerminalNo.Text, int.Parse(cboBranch.SelectedItem.Value));
clsSalesTransactions.CommitAndDispose();
if (clsDetails.isExist == true)
{
drNew = rptds.Transactions.NewRow();
drNew["BranchCode"] = clsDetails.BranchCode;
drNew["TransactionID"] = clsDetails.TransactionID;
drNew["TransactionNo"] = clsDetails.TransactionNo;
drNew["CustomerName"] = clsDetails.CustomerName;
drNew["CashierName"] = clsDetails.CashierName;
drNew["TerminalNo"] = clsDetails.TerminalNo;
drNew["TransactionDate"] = clsDetails.TransactionDate;
drNew["DateSuspended"] = clsDetails.DateSuspended.ToString();
drNew["DateResumed"] = clsDetails.DateResumed;
drNew["TransactionStatus"] = clsDetails.TransactionStatus;
drNew["SubTotal"] = clsDetails.SubTotal;
drNew["ItemsDiscount"] = clsDetails.ItemsDiscount;
drNew["Discount"] = clsDetails.Discount;
drNew["VAT"] = clsDetails.VAT;
drNew["VatableAmount"] = clsDetails.VATableAmount;
drNew["LocalTax"] = clsDetails.LocalTax;
drNew["AmountPaid"] = clsDetails.AmountPaid;
drNew["CashPayment"] = clsDetails.CashPayment;
drNew["ChequePayment"] = clsDetails.ChequePayment;
drNew["CreditCardPayment"] = clsDetails.CreditCardPayment;
drNew["BalanceAmount"] = clsDetails.BalanceAmount;
drNew["ChangeAmount"] = clsDetails.ChangeAmount;
drNew["DateClosed"] = clsDetails.DateClosed;
drNew["PaymentType"] = clsDetails.PaymentType.ToString("d");
drNew["ItemsDiscount"] = clsDetails.ItemsDiscount;
drNew["Charge"] = clsDetails.Charge;
drNew["CreditPayment"] = clsDetails.CreditPayment;
drNew["CreatedByName"] = clsDetails.CreatedByName;
rptds.Transactions.Rows.Add(drNew);
/****************************sales transaction items*****************************/
SalesTransactionItems clsSalesTransactionItems = new SalesTransactionItems();
System.Data.DataTable dt = clsSalesTransactionItems.List(clsDetails.TransactionID, clsDetails.TransactionDate, "TransactionItemsID", SortOption.Ascending);
clsSalesTransactionItems.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
drNew = rptds.TransactionItems.NewRow();
foreach (DataColumn dc in rptds.TransactionItems.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.TransactionItems.Rows.Add(drNew);
}
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSourceProductHistory(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime DateFrom = DateTime.MinValue;
try
{ DateFrom = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch { }
DateTime DateTo = DateTime.MinValue;
try
{ DateTo = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch { }
StockItem clsStockItem = new StockItem();
MySqlDataReader myreader = clsStockItem.ProductHistoryReport(Convert.ToInt64(cboProductCode.SelectedItem.Value), DateFrom, DateTo);
clsStockItem.CommitAndDispose();
while (myreader.Read())
{
DataRow drStockItem = rptds.ProductHistory.NewRow();
foreach (DataColumn dc in rptds.ProductHistory.Columns)
drStockItem[dc] = myreader[dc.ColumnName];
rptds.ProductHistory.Rows.Add(drStockItem);
}
Report.SetDataSource(rptds);
}
private bool ExportReport(ReportType type, string outname, string fmt)
{
try
{
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>" + fmt + "</OutputFormat>" +
" <PageWidth>21cm</PageWidth>" +
" <PageHeight>25cm</PageHeight>" +
" <MarginTop>2cm</MarginTop>" +
" <MarginLeft>2cm</MarginLeft>" +
" <MarginRight>2cm</MarginRight>" +
" <MarginBottom>2cm</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] bytes;
string reportType = fmt;
string mimeType = "";
string encoding = "";
string fileNameExtension = "";
LocalReport _reportViewer = new LocalReport();
if (ReportType.REPORT_COMAPNY_LIST.Equals(type))
{
#region COMPANY LIST REPORT CREATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.Companies orderby c.CMP_COD select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (Company c in query)
{
dataset.Tables["Company"].Rows.Add(
new object[]
{
(int)c.CMP_COD,
(string)c.CMP_NAME,
(string)c.CMP_ADDRESS,
(string)c.VIL_NAME,
(string)c.PAR_NAME,
(string)c.COU_NAME,
(string)c.CMP_PHONE
}
);
}
dataset.AcceptChanges();
_reportViewer.ReportEmbeddedResource = "ExpressTMS.CompanyList.rdlc";
ReportParameter[] param = new ReportParameter[4];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
_reportViewer.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["Company"]);
_reportViewer.DataSources.Clear();
_reportViewer.DataSources.Add(datasource);
bytes = _reportViewer.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
FileStream fs = new FileStream(outname,
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
return(true);
}
}
#endregion
}
else if (ReportType.REPORT_DRIVER_LIST.Equals(type))
{
#region DRIVER LIST REPORT CREATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.Drivers orderby c.DRV_COD select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (Driver c in query)
{
dataset.Tables["Driver"].Rows.Add(
new object[]
{
(int)c.DRV_COD,
(string)c.DRV_NAME,
(string)c.DRV_ADDRESS,
(string)c.VIL_NAME,
(string)c.PAR_NAME,
(string)c.COU_NAME,
(string)c.DRV_PHONE,
(string)c.DRV_LICENSE
}
);
}
dataset.AcceptChanges();
_reportViewer.ReportEmbeddedResource = "ExpressTMS.DriverList.rdlc";
ReportParameter[] param = new ReportParameter[4];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
_reportViewer.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["Driver"]);
_reportViewer.DataSources.Clear();
_reportViewer.DataSources.Add(datasource);
bytes = _reportViewer.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
FileStream fs = new FileStream(outname,
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
return(true);
}
}
#endregion
}
else if (ReportType.REPORT_SERVICES_CURRENT_DAY.Equals(type))
{
#region SERVICES CURRENT DAY CREATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod && c.IsValid
orderby c.TRANS_COD
select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (FinancialTransaction c in query)
{
if (c.IsValid)
{
dataset.Tables["ServicesCurrentDay"].Rows.Add(
new object[]
{
(int)c.DOC_NUM,
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(string)c.Company.CMP_NAME,
(string)c.TRANS_DESTINATION,
(string)c.DOC_TYPE_NAME,
(string)c.DOCUMENT_DATE.ToString("dd MMM yyyy"),
(decimal)c.TRANS_VALUE,
(decimal)c.TRANS_FINAL_VALUE
}
);
}
}
dataset.AcceptChanges();
_reportViewer.ReportEmbeddedResource = "ExpressTMS.ServicesCurrentDay.rdlc";
ReportParameter[] param = new ReportParameter[6];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
_reportViewer.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["ServicesCurrentDay"]);
_reportViewer.DataSources.Clear();
_reportViewer.DataSources.Add(datasource);
bytes = _reportViewer.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
FileStream fs = new FileStream(outname,
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
return(true);
}
}
#endregion
}
else if (ReportType.REPORT_ACCUMULATED_BY_DRIVER.Equals(type))
{
#region ACCUMULATED BY DRIVER LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
decimal FinalVal = decimal.Zero;
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod &&
c.Driver.DRV_LICENSE == DrvLicense &&
c.Driver.DRV_NAME == DrvName &&
c.IsValid
orderby c.TRANS_COD
select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
ReportDataset tax = new ReportDataset();
ReportDataset DeductionSet = new ReportDataset();
foreach (FinancialTransaction c in query)
{
if (c.IsValid)
{
dataset.Tables["AccumulatedByDriver"].Rows.Add(
new object[]
{
(int)c.DOC_NUM,
(string)c.DOCUMENT_DATE.ToString("dd MMM yyyy"),
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(string)c.Company.CMP_NAME,
(string)c.TRANS_DESTINATION,
(decimal)c.TRANS_VALUE,
(decimal)c.TRANS_REDUCTION,
(decimal)c.TRANS_FINAL_VALUE,
(string)c.TRANS_COMMENTS,
(string)c.VOUCHER_NUM
}
);
FinalVal = FinalVal + c.TRANS_FINAL_VALUE;
}
}
var query2 = from t in ctx.AppliedTaxes select t;
if (query2.Count() > 0)
{
int n = 0;
foreach (AppliedTax t in query2)
{
tax.Tables["Tax"].Rows.Add(new object[] {
(int)n,
(string)t.TaxDescription,
(decimal)(t.TaxAmount * FinalVal) / 100
});
n = n + 1;
}
}
DeductionSet.Tables["Deduction"].Rows.Add(new object[] { (decimal)Deduction });
dataset.AcceptChanges();
tax.AcceptChanges();
DeductionSet.AcceptChanges();
_reportViewer.ReportEmbeddedResource = "ExpressTMS.AccumulatedByDriver.rdlc";
ReportParameter[] param = new ReportParameter[6];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
_reportViewer.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["AccumulatedByDriver"]);
ReportDataSource taxsource = new ReportDataSource("DataSet2", tax.Tables["Tax"]);
ReportDataSource deductionsource = new ReportDataSource("DataSet3", DeductionSet.Tables["Deduction"]);
_reportViewer.DataSources.Clear();
_reportViewer.DataSources.Add(datasource);
_reportViewer.DataSources.Add(taxsource);
_reportViewer.DataSources.Add(deductionsource);
bytes = _reportViewer.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
FileStream fs = new FileStream(outname,
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
return(true);
}
}
#endregion
}
else if (ReportType.REPORT_ACCUMULATED_PAID.Equals(type))
{
#region ACCUMULATED PAID LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod && c.IsValid
select c;
if (query.Count() > 0)
{
List <int> txNum = new List <int>();
var query2 = from d in query select new { d.DRV_COD };
foreach (var d in query2)
{
if (!txNum.Contains(d.DRV_COD))
{
txNum.Add(d.DRV_COD);
}
}
ReportDataset dataset = new ReportDataset();
int n = 0;
foreach (var d in txNum)
{
var query3 = from tx in query where tx.DRV_COD.Equals(d) select tx;
FinancialTransaction c = query3.FirstOrDefault();
if (c != null)
{
decimal TransValue = decimal.Zero;
decimal TransReduction = decimal.Zero;
decimal TransFinalValue = decimal.Zero;
foreach (FinancialTransaction tx in query3)
{
TransValue = TransValue + tx.TRANS_VALUE;
TransReduction = TransReduction + tx.TRANS_REDUCTION;
}
TransFinalValue = TransValue - TransReduction;
dataset.Tables["AccumulatedPaid"].Rows.Add(
new object[]
{
(int)n,
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(decimal)TransValue,
(decimal)TransReduction,
(decimal)TransFinalValue
}
);
n = n + 1;
}
}
dataset.AcceptChanges();
_reportViewer.ReportEmbeddedResource = "ExpressTMS.AccumulatedPaid.rdlc";
ReportParameter[] param = new ReportParameter[6];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
_reportViewer.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["AccumulatedPaid"]);
_reportViewer.DataSources.Clear();
_reportViewer.DataSources.Add(datasource);
bytes = _reportViewer.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
FileStream fs = new FileStream(outname,
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
return(true);
}
}
#endregion
}
else if (ReportType.REPORT_HOTEL_INFORMATION.Equals(type))
{
#region SERVICES CURRENT DAY CREATION LOGIC
using (ExpressTaxi ctx = new ExpressTaxi(conn))
{
var query = from c in ctx.FinancialTransactions
where
c.TRANS_DATE >= startPeriod &&
c.TRANS_DATE <= endPeriod &&
c.Company.CMP_NAME == HotelInfo &&
c.IsValid
orderby c.TRANS_COD
select c;
if (query.Count() > 0)
{
ReportDataset dataset = new ReportDataset();
foreach (FinancialTransaction c in query)
{
if (c.IsValid)
{
dataset.Tables["HotelInformation"].Rows.Add(
new object[]
{
(int)c.DOC_NUM,
(string)c.Driver.DRV_LICENSE,
(string)c.Driver.DRV_NAME,
(string)c.Company.CMP_NAME,
(string)c.TRANS_DESTINATION,
(string)c.VOUCHER_NUM,
(decimal)c.TRANS_FINAL_VALUE
}
);
}
}
dataset.AcceptChanges();
_reportViewer.ReportEmbeddedResource = "ExpressTMS.HotelInformation.rdlc";
ReportParameter[] param = new ReportParameter[7];
param[0] = new ReportParameter("CMP_NAME", Config.CMP_NAME);
param[1] = new ReportParameter("CMP_ADDRESSLINE1", Config.CMP_ADDRESSLINE1);
param[2] = new ReportParameter("CMP_ADDRESSLINE2", Config.CMP_ADDRESSLINE2);
param[3] = new ReportParameter("CMP_PHONEFAX", Config.CMP_PHONEFAX);
param[4] = new ReportParameter("START_DATE", startPeriod.ToString("dd MMM yyyy"));
param[5] = new ReportParameter("END_DATE", endPeriod.ToString("dd MMM yyyy"));
param[6] = new ReportParameter("AGENT", HotelInfo);
_reportViewer.SetParameters(param);
ReportDataSource datasource = new ReportDataSource("DataSet1", dataset.Tables["HotelInformation"]);
_reportViewer.DataSources.Clear();
_reportViewer.DataSources.Add(datasource);
bytes = _reportViewer.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
FileStream fs = new FileStream(outname,
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
return(true);
}
}
#endregion
}
}
catch (System.Exception ex)
{
log.Error(ex);
}
return(false);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string ContactCode = string.Empty;
if (cboContact.SelectedItem.Value != Constants.ZERO_STRING) ContactCode = cboContact.SelectedItem.Text;
string ProductGroupName = string.Empty;
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING) ProductGroupName = cboGroup.SelectedItem.Text;
string ProductSubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING) ProductSubGroupName = cboSubGroup.SelectedItem.Text;
System.Data.DataTable dt = null;
if (lblType.Text == "invcount")
{
Int64 lngSupplierID = Convert.ToInt64(cboContact.SelectedItem.Value);
Int64 lngProductgroupID = Convert.ToInt64(cboGroup.SelectedItem.Value);
Int64 lngProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
ProductInventories clsProductInventories = new ProductInventories();
dt = clsProductInventories.ListAsDataTable(BranchID: int.Parse(lblBranchID.Text), SupplierID: lngSupplierID, ProductGroupID: lngProductgroupID, ProductSubGroupID: lngProductSubGroupID, clsProductListFilterType: ProductListFilterType.ShowActiveOnly, SortField: "ProductCode ASC, MatrixDescription ASC, BarCode1", SortOrder: SortOption.Desscending);
//Contacts clsContacts = new Contacts(clsProductInventories.Connection, clsProductInventories.Transaction);
//ContactDetails clsContactDetails = clsContacts.Details(lngSupplierID);
clsProductInventories.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drInventory = rptds.ProductInventory.NewRow();
foreach (DataColumn dc in rptds.ProductInventory.Columns)
drInventory[dc] = dr[dc.ColumnName];
rptds.ProductInventory.Rows.Add(drInventory);
}
}
else
{
Data.Inventory clsInventory = new Data.Inventory();
dt = clsInventory.DataList(cboInventoryNo.SelectedItem.Text, chkIncludeShortOverProducts.Checked, long.Parse(cboContact.SelectedItem.Value), long.Parse(cboGroup.SelectedItem.Value), SortField: "InventoryID", SortOrder: SortOption.Ascending);
clsInventory.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drInventory = rptds.Inventory.NewRow();
foreach (DataColumn dc in rptds.Inventory.Columns)
drInventory[dc] = dr[dc.ColumnName];
rptds.Inventory.Rows.Add(drInventory);
}
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
long iID = 0;
try
{
if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["transferinid"].ToString() != null)
{ iID = Convert.ToInt64(Request.QueryString["transferinid"].ToString()); }
else
{ iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["transferinid"].ToString(), Session.SessionID)); }
}
catch { iID = Convert.ToInt64(Common.Decrypt(lblReferrer.Text.Substring(lblReferrer.Text.IndexOf("transferinid") + 13), Session.SessionID)); }
ReportDataset rptds = new ReportDataset();
TransferIn clsTransferIn = new TransferIn();
MySqlDataReader myreader = clsTransferIn.List(iID, "TransferInID", SortOption.Ascending);
while(myreader.Read())
{
DataRow drNew = rptds.TransferIn.NewRow();
foreach (DataColumn dc in rptds.TransferIn.Columns)
drNew[dc] = "" + myreader[dc.ColumnName];
rptds.TransferIn.Rows.Add(drNew);
}
myreader.Close();
TransferInItem clsTransferInItem = new TransferInItem(clsTransferIn.Connection, clsTransferIn.Transaction);
MySqlDataReader myreaderitems = clsTransferInItem.List(iID, "TransferInItemID", SortOption.Ascending);
while(myreaderitems.Read())
{
DataRow drNew = rptds.TransferInItems.NewRow();
foreach (DataColumn dc in rptds.TransferInItems.Columns)
drNew[dc] = "" + myreaderitems[dc.ColumnName];
rptds.TransferInItems.Rows.Add(drNew);
}
myreaderitems.Close();
clsTransferIn.CommitAndDispose();
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strProductGroup = cboProductGroup.SelectedItem.Text == Constants.ALL ? string.Empty : cboProductGroup.SelectedItem.Text;
string TransactionNo = txtTransactionNo.Text;
string CustomerName = cboContactName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactName.SelectedItem.Text;
string AgentName = cboAgent.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboAgent.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboAgent.SelectedItem.Text;
string CashierName = cboCashierName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboCashierName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboCashierName.SelectedItem.Text;
string TerminalNo = cboTerminalNo.SelectedItem.Text == Constants.ALL ? string.Empty : cboTerminalNo.SelectedItem.Text;
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartTransactionDate.Text + " " + txtStartTime.Text); }
catch { }
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndTransactionDate.Text + " " + txtEndTime.Text); }
catch { }
TransactionStatus Status = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), cboTransactionStatus.SelectedItem.Value);
PaymentTypes PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboPaymentType.SelectedItem.Value);
DataTable dt = new DataTable();
ReportDataset rptds = new ReportDataset();
SalesTransactions clsSalesTransactions;
//SalesTransactionItems clsSalesTransactionItems;
SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.BranchCode = true;
clsSalesTransactionsColumns.TransactionNo = true;
clsSalesTransactionsColumns.CustomerName = true;
clsSalesTransactionsColumns.CustomerGroupName = true;
clsSalesTransactionsColumns.CashierName = true;
clsSalesTransactionsColumns.TerminalNo = true;
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.DateSuspended = true;
clsSalesTransactionsColumns.DateResumed = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.SubTotal = true;
clsSalesTransactionsColumns.Discount = true;
clsSalesTransactionsColumns.VAT = true;
clsSalesTransactionsColumns.VATableAmount = true;
clsSalesTransactionsColumns.LocalTax = true;
clsSalesTransactionsColumns.AmountPaid = true;
clsSalesTransactionsColumns.CashPayment = true;
clsSalesTransactionsColumns.ChequePayment = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
clsSalesTransactionsColumns.BalanceAmount = true;
clsSalesTransactionsColumns.ChangeAmount = true;
clsSalesTransactionsColumns.DateClosed = true;
clsSalesTransactionsColumns.PaymentType = true;
clsSalesTransactionsColumns.ItemsDiscount = true;
clsSalesTransactionsColumns.Charge = true;
clsSalesTransactionsColumns.CreditPayment = true;
clsSalesTransactionsColumns.CreatedByName = true;
clsSalesTransactionsColumns.AgentName = true;
clsSalesTransactionsColumns.PaxNo = true;
#endregion
SalesTransactionDetails clsSearchKey = new SalesTransactionDetails();
clsSearchKey = new SalesTransactionDetails();
clsSearchKey.TransactionNo = TransactionNo;
clsSearchKey.CustomerName = CustomerName;
clsSearchKey.CashierName = CashierName;
clsSearchKey.TerminalNo = TerminalNo;
clsSearchKey.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsSearchKey.TransactionDateFrom = StartTransactionDate;
clsSearchKey.TransactionDateTo = EndTransactionDate;
clsSearchKey.TransactionStatus = Status;
clsSearchKey.PaymentType = PaymentType;
clsSearchKey.AgentName = AgentName;
clsSearchKey.isConsignmentSearch = cboConsignment.SelectedItem.Value;
if (clsSearchKey.isConsignmentSearch != "-1")
{
clsSearchKey.isConsignment = bool.Parse(cboConsignment.SelectedItem.Value);
}
bool boWithTrustFund = true;
string strReportType = cboReportType.SelectedValue;
switch (strReportType)
{
case ReportTypes.MANAGEMENT_PerBranch:
case ReportTypes.MANAGEMENT_PerBranchPerMonth:
case ReportTypes.MANAGEMENT_PerBranchPerMonthWithCovers:
case ReportTypes.MANAGEMENT_PerBranchPerDay:
case ReportTypes.MANAGEMENT_PerCustomerGroupPerDay:
#region Daily, Weekely, Monthly Sales Transaction
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "TransactionDate", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, boWithTrustFund, "TransactionDate", SortOption.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
Int64 intProductID = 0;
if (cboProductCode.Items.Count > 0) intProductID = Int64.Parse(cboProductCode.SelectedItem.Value);
Int64 intMatrixID = 0;
if (cboVariation.Items.Count > 0) intMatrixID = Int64.Parse(cboVariation.SelectedItem.Value);
DateTime DateFrom = DateTime.MinValue;
DateFrom = DateTime.TryParse(txtStartDate.Text + " " + txtStartTime.Text, out DateFrom) ? DateFrom : DateTime.MinValue;
DateTime DateTo = DateTime.MinValue;
DateTo = DateTime.TryParse(txtEndDate.Text + " " + txtEndTime.Text, out DateTo) ? DateTo : DateTime.MinValue;
Int32 intLimit = 0;
intLimit = Int32.TryParse(txtLimit.Text, out intLimit) ? intLimit : 0;
Int32 intBranchID = 0;
intBranchID = Int32.TryParse(cboBranch.SelectedItem.Value, out intBranchID) ? intBranchID : 0;
switch (cboReportType.SelectedValue)
{
case ReportTypes.ProductHistoryMovement:
#region Product History Movement
StockItem clsStockItem = new StockItem();
System.Data.DataTable dtProductHistoryMovement = clsStockItem.ProductMovementReport(intProductID, intMatrixID, DateFrom, DateTo, intBranchID);
clsStockItem.CommitAndDispose();
foreach (DataRow dr in dtProductHistoryMovement.Rows)
{
DataRow drNew = rptds.ProductMovement.NewRow();
foreach (DataColumn dc in rptds.ProductMovement.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.ProductMovement.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductHistoryPrice:
#region Product price history
ProductPackagePriceHistory clsProductPackagePriceHistory = new ProductPackagePriceHistory();
clsProductPackagePriceHistory.GetConnection();
System.Data.DataTable dtProductList = clsProductPackagePriceHistory.List(DateFrom, DateTo, intProductID);
clsProductPackagePriceHistory.CommitAndDispose();
foreach (DataRow dr in dtProductList.Rows)
{
DataRow drNew = rptds.ProductPriceHistory.NewRow();
foreach (DataColumn dc in rptds.ProductPriceHistory.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.ProductPriceHistory.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductHistoryMostSaleable:
#region Most Saleable
SalesTransactionItems clsSalesTransactionItemsMost = new SalesTransactionItems();
System.Data.DataTable dtMostSaleable = clsSalesTransactionItemsMost.MostSalableItems(DateFrom, DateTo, intLimit);
clsSalesTransactionItemsMost.CommitAndDispose();
foreach (DataRow dr in dtMostSaleable.Rows)
{
DataRow drNew = rptds.MostSalableItems.NewRow();
foreach (DataColumn dc in rptds.MostSalableItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.MostSalableItems.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductHistoryLeastSaleable:
#region Least Saleable
SalesTransactionItems clsSalesTransactionItemsLeast = new SalesTransactionItems();
System.Data.DataTable dtLeastSaleable = clsSalesTransactionItemsLeast.LeastSalableItems(DateFrom, DateTo, intLimit);
clsSalesTransactionItemsLeast.CommitAndDispose();
foreach (DataRow dr in dtLeastSaleable.Rows)
{
DataRow drNew = rptds.LeastSalableItems.NewRow();
foreach (DataColumn dc in rptds.LeastSalableItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.LeastSalableItems.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime ActivityDateFrom = DateTime.TryParse(txtStartTransactionDate.Text + " 00:00", out ActivityDateFrom) ? ActivityDateFrom : Constants.C_DATE_MIN_VALUE;
DateTime ActivityDateTo = DateTime.TryParse(txtEndTransactionDate.Text + " 23:59", out ActivityDateTo) ? ActivityDateTo : Constants.C_DATE_MIN_VALUE;
CashierLogs clsCashierLogs = new CashierLogs();
System.Data.DataTable dt = clsCashierLogs.LoginLogoutReport(ActivityDateFrom, ActivityDateTo, null);
clsCashierLogs.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drLoginLogout = rptds.LoginLogout.NewRow();
foreach (DataColumn dc in rptds.LoginLogout.Columns)
drLoginLogout[dc] = dr[dc.ColumnName];
rptds.LoginLogout.Rows.Add(drLoginLogout);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
