void loadReport(DateTime?FromDate, DateTime?ToDate, string ItemCode)
{
FromDate = FromDate ?? DateTime.MinValue;
ToDate = ToDate ?? DateTime.Now;
ItemCode = string.IsNullOrEmpty(ItemCode) ? "" : ItemCode;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = SettingsProvider.GetDataSource();
builder.InitialCatalog = SettingsProvider.GetDatabase();
builder.UserID = SettingsProvider.GetUserName();
builder.Password = SettingsProvider.GetPassword();
int type = 2;
int entryStatus = 0;
int transactionStatus = 0;
int defaultAddressType = 0;
using (DelivaryDataProvider db = new DelivaryDataProvider(builder.ConnectionString))
{
List <DelivaryTransactionView> result = db.getDelivaryTransactionView();
var transactionLine = from x in result
select
new ReportTransactionLine()
{
ReceiptID = x.RECEIPTID,
ItemId = x.ITEMID,
Description = x.DESCRIPTION,
Qty = x.QUANTITY == null?0:(decimal)x.QUANTITY,
TaxInckInPrice = x.SEIINGPRICE == null ? 0 : (decimal)x.SEIINGPRICE,
Comment = x.COMMENT.Replace("\r\n", " "),
ExtraInfo = x.DELIVARYTYPE
, CustomerName = x.NAME
};
this.TransactionLines = transactionLine.Count() > 0 ? new ReprotTransactionLines(transactionLine.ToList()) : null;
}
/*
* using (var db = new DeliveryDbContext(builder.ConnectionString))
* { //LINENUM changed to LINEID IN in line 103 col 155 by rafeeq
*
* var transactionCustomer = from tra_h in db.RBOTRANSACTIONTABLE
* join tra_i in db.RBOTRANSACTIONINFOCODETRANS
* on
* new { tra_h.TRANSACTIONID, INFOCODEID = } equals new { tra_i.TRANSACTIONID, tra_i.INFOCODEID } into info_d
* from info in info_d.DefaultIfEmpty()
* join cust in db.CUSTTABLE on new { CUSTACCOUNT = string.IsNullOrEmpty(info.INFORMATION) ? tra_h.CUSTACCOUNT : info.INFORMATION } equals
* new { CUSTACCOUNT = cust.ACCOUNTNUM }
* join address in db.CUSTOMERADDRESS on
* new { cust.ACCOUNTNUM, ADDRESSTYPE = defaultAddressType } equals new { address.ACCOUNTNUM, address.ADDRESSTYPE }
* where
* tra_h.TYPE == type &&
* tra_h.ENTRYSTATUS == entryStatus
* select new TransactionCustomer()
* {
* ReceiptID = tra_h.RECEIPTID,
* CustAccount = string.IsNullOrEmpty(info.INFORMATION) ? tra_h.CUSTACCOUNT : info.INFORMATION,
* Name = cust.NAME,
* Address = cust.ADDRESS,
* Phone = cust.PHONE,
* Address1 = address.ADDRESS,
* Street = address.STREET
* };
* var transactionLine = from tra_h in db.RBOTRANSACTIONTABLE
* join tra_l in db.RBOTRANSACTIONSALESTRANS
* on tra_h.TRANSACTIONID equals tra_l.TRANSACTIONID
* join tra_i in db.RBOTRANSACTIONINFOCODETRANS
* on
* new { tra_l.TRANSACTIONID, tra_l.LINENUM, INFOCODEID = Program.isDelevary } equals new { tra_i.TRANSACTIONID, LINENUM = (decimal)tra_i.LINEID, tra_i.INFOCODEID } into info_d
* from info in info_d.DefaultIfEmpty()
* join info_sub in db.RBOINFORMATIONSUBCODETABLE on
* info.INFORMATION equals info_sub.SUBCODEID into info_sub_d
* from info_s in info_sub_d.DefaultIfEmpty()
* where
* tra_h.TYPE == type &&
* tra_h.ENTRYSTATUS == entryStatus &&
* tra_l.TRANSACTIONSTATUS == transactionStatus &&
* info_s.DESCRIPTION == Program.isDelevaryValue &&
* tra_h.TRANSDATE < ToDate &&
* tra_h.TRANSDATE > FromDate &&
* tra_l.ITEMID.StartsWith(ItemCode)
* select new TransactionLine()
* {
* ReceiptID = tra_h.RECEIPTID,
* ItemId = tra_l.ITEMID,
* Description = tra_l.DESCRIPTION,
* Qty = (tra_l.QTY ?? 0) * -1,
* TaxInckInPrice = -1 * (tra_l.NETAMOUNTINCLTAX ?? 0),
* Comment = tra_l.COMMENT,
* ExtraInfo = string.IsNullOrEmpty(info_s.DESCRIPTION) ? "NON DELIVERABLE" : info_s.DESCRIPTION
* };
*
* this.TransactionLines = transactionLine.Count() > 0 ? new TransactionLines(transactionLine.ToList()) : null;
* }
*/
}
private void radioButtonReportType_CheckedChanged(object sender, EventArgs e)
{
var radioButton = (RadioButton)sender;
if (radioButton.Checked)
{
switch ((ReportType)radioButton.Tag)
{
case ReportType.SUMMARY:
this.Cursor = Cursors.WaitCursor;
this.dateTimePickerFrom.Enabled = true;
this.dateTimePickerTo.Enabled = true;
InitReport(typeof(LSDelevaryNote.Provider.Entities.DelivaryTransactionView));
using (DelivaryDataProvider db = new DelivaryDataProvider(builder.ConnectionString))
{
List <DelivaryTransactionView> result = db.getDelivaryTransactionView(
null,
this.textBoxItem.Text.Trim(),
null,
this.dateTimePickerFrom.Value,
this.dateTimePickerTo.Value,
this.comboBoxDeleveryType.SelectedText
);
this.DelivaryTransactionViewBindingSource.DataSource = result;
this.reportViewer1.RefreshReport();
}
this.Cursor = Cursors.Default;
break;
case ReportType.REPLENISHMENT:
//ReportViewer.ProgressMessage = new ProcessForm(new string[] { "Loading Location 150...", "Loading location 650...", "Loading location 295..." });
this.Cursor = Cursors.WaitCursor;
this.reportViewer1.Enabled = false;
this.dateTimePickerTo.Enabled = false;
InitReport(
typeof(LSDelevaryNote.Provider.Entities.DelivaryTransactionView),
ReportEmbeddedResource: "LSDelevaryNote.ReplenishmentReport.rdlc",
DataSourceName: "ReplanishDataSet"
);
try
{
using (DelivaryDataProvider db = new DelivaryDataProvider(builder.ConnectionString))
{
List <DelevaryRelanishment> result = db.getDelivaryReplamishmentView(
null,
this.textBoxItem.Text.Trim(),
null,
//null,
DateTime.Now.AddDays(-1).Date,
//null,
DateTime.Now.Date,
null
);
this.DelivaryTransactionViewBindingSource.DataSource = result;
this.reportViewer1.RefreshReport();
//ReportViewer.ProgressMessage.Close();
}
}
catch (Exception ex) {
MessageBox.Show(this, "Error gathering data.\nCheck the network and try again later.", "Bad data", MessageBoxButtons.OK);
}
//ReportViewer.ProgressMessage.Task = new Task(action);
//ReportViewer.ProgressMessage.ShowDialog(this);
this.reportViewer1.Enabled = true;
this.dateTimePickerFrom.Enabled = false;
this.Cursor = Cursors.Default;
break;
}
}
}
