public Report(ReprotTransactionLines transactionLines)
{
this.TransactionLines = transactionLines;
InitializeComponent();
init();
this.dataGridViewReport.DataSource = this.TransactionLines;
}
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;
* }
*/
}
