private void Init()
{
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 (var db = new DeliveryDbContext(builder.ConnectionString))
{
var data = from tra_h in db.RBOTRANSACTIONTABLE
join tra_i in db.RBOTRANSACTIONINFOCODETRANS
on tra_h.TRANSACTIONID equals tra_i.TRANSACTIONID into tra_h_is
from tra_h_i in tra_h_is.DefaultIfEmpty()
join cust in db.CUSTTABLE on
string.IsNullOrEmpty(tra_h_i.INFORMATION) ? tra_h.CUSTACCOUNT : tra_h_i.INFORMATION
equals cust.ACCOUNTNUM
join cust_ad in db.CUSTOMERADDRESS on
cust.ACCOUNTNUM equals cust_ad.ACCOUNTNUM
where tra_h_i.INFOCODEID == Program.customerInfoCode &&
tra_h.TYPE == type &&
tra_h.ENTRYSTATUS == entryStatus &&
(from ss in db.RBOTRANSACTIONINFOCODETRANS
join ww in db.RBOINFORMATIONSUBCODETABLE
on new { p1 = (string)ss.INFOCODEID, p2 = (string)ss.SUBINFOCODEID }
equals new { p1 = (string)ww.INFOCODEID, p2 = (string)ww.SUBCODEID }
where ss.TRANSACTIONID == tra_h.TRANSACTIONID &&
ww.INFOCODEID == Program.isDelevary &&
ww.DESCRIPTION == Program.isDelevaryValue
select ss.TRANSACTIONID
).Any()
select new TransCust()
{
ReceiptID = tra_h.RECEIPTID,
Customer = string.IsNullOrEmpty(tra_h_i.INFORMATION) ? tra_h.CUSTACCOUNT : tra_h_i.INFORMATION,
CustomerName = cust.NAME,
CustomerAddredd = cust.ADDRESS,
CustomerPhone = string.IsNullOrEmpty(cust_ad.STREET)?cust.PHONE:cust_ad.STREET
};
((ListBox)this.checkedListBoxCustomer).DataSource = data.ToList();
}
}
private void sendSMS(string v, bool confirm = false)
{
int type = 2;
int entryStatus = 0;
int transactionStatus = 0;
int defaultAddressType = 0;
string customerInfoCode = "INF00007";
string isDelevary = "INF00004";
var receipt = v;
if (!String.IsNullOrEmpty(receipt))
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = SettingsProvider.GetDataSource();
builder.InitialCatalog = SettingsProvider.GetDatabase();
builder.UserID = SettingsProvider.GetUserName();
builder.Password = SettingsProvider.GetPassword();
using (var db = new DeliveryDbContext(builder.ConnectionString))
{
/* var transactionCustomer = (from tra_h in db.RBOTRANSACTIONTABLE
* join tra_i in db.RBOTRANSACTIONINFOCODETRANS
* on
* new { tra_h.TRANSACTIONID, INFOCODEID = customerInfoCode } 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.RECEIPTID == receipt &&
* 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
* }).ToList()[0];
*/
var data = from tra_h in db.RBOTRANSACTIONTABLE
join tra_i in db.RBOTRANSACTIONINFOCODETRANS
on tra_h.TRANSACTIONID equals tra_i.TRANSACTIONID into tra_h_is
from tra_h_i in tra_h_is.DefaultIfEmpty()
join cust in db.CUSTTABLE on
string.IsNullOrEmpty(tra_h_i.INFORMATION) ? tra_h.CUSTACCOUNT : tra_h_i.INFORMATION
equals cust.ACCOUNTNUM
join cust_ad in db.CUSTOMERADDRESS on
cust.ACCOUNTNUM equals cust_ad.ACCOUNTNUM
where tra_h_i.INFOCODEID == Program.customerInfoCode &&
tra_h.TYPE == type &&
tra_h.ENTRYSTATUS == entryStatus &&
tra_h.RECEIPTID == receipt &&
(from ss in db.RBOTRANSACTIONINFOCODETRANS
join ww in db.RBOINFORMATIONSUBCODETABLE
on new { p1 = (string)ss.INFOCODEID, p2 = (string)ss.SUBINFOCODEID }
equals new { p1 = (string)ww.INFOCODEID, p2 = (string)ww.SUBCODEID }
where ss.TRANSACTIONID == tra_h.TRANSACTIONID &&
ww.INFOCODEID == Program.isDelevary &&
ww.DESCRIPTION == Program.isDelevaryValue
select ss.TRANSACTIONID
).Any()
select new TransCust()
{
ReceiptID = tra_h.RECEIPTID,
Customer = string.IsNullOrEmpty(tra_h_i.INFORMATION) ? tra_h.CUSTACCOUNT : tra_h_i.INFORMATION,
CustomerName = cust.NAME,
CustomerAddredd = cust.ADDRESS,
CustomerPhone = string.IsNullOrEmpty(cust_ad.STREET) ? cust.PHONE : cust_ad.STREET
};
var sms = data.ToList()[0];
if (confirm ||
MessageBox.Show(this, "Do you want to resend SMS?" +
Environment.NewLine +
sms.CustomerName +
Environment.NewLine + sms.getSendablePhone(), "Confirm resend.", MessageBoxButtons.YesNo
) == DialogResult.Yes)
{
//var result = sms.SendMessage(sms.CustomerName + "Your order confirmed with Grand Stores LLC. Our Representative will contact you soon.");
var result = sms.SendMessage(sms.CustomerName + @"Dear Valued customer, " + Environment.NewLine +
@"Thank you for choosing Grand Stores.Our Call Centre will call you to confirm the tentative delivery schedule soon." + Environment.NewLine +
@"For any queries, please contact: +97148800999");
MessageBox.Show(result, "Messege send result.");
}
}
}
}
private void RefreshReport(string receiptIN)
{
var receipt = receiptIN;
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;
string customerInfoCode = "INF00007";
string isDelevary = "INF00004";
Transaction TransactionHeader = new Transaction();
TransactionCustomer TransactionCustomer = new TransactionCustomer();
TransactionLines TransactionLines = new TransactionLines(null);
using (var db = new DeliveryDbContext(builder.ConnectionString))
{
var transaction = from tra_h in db.RBOTRANSACTIONTABLE
join sto in db.RBOSTORETABLE on tra_h.STORE equals sto.STOREID
where tra_h.RECEIPTID == receipt &&
tra_h.TYPE == type &&
tra_h.ENTRYSTATUS == entryStatus
select new Transaction()
{
ReceiptID = tra_h.RECEIPTID,
StoreID = sto.STOREID,
Name = sto.NAME,
TransDate = tra_h.TRANSDATE ?? DateTime.MinValue,
NetAmount = tra_h.NETAMOUNT ?? 0
};
// LINENUM changed to LINENUM = (decimal)tra_i.LINEID in line 334 colu 156 by rafeeq
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 = 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.RECEIPTID == receipt &&
tra_h.TYPE == type &&
tra_h.ENTRYSTATUS == entryStatus &&
tra_l.TRANSACTIONSTATUS == transactionStatus
select new TransactionLine()
{
ItemId = tra_l.ITEMID,
Description = tra_l.DESCRIPTION,
Qty = (tra_l.QTY ?? 0) * -1,
TaxInckInPrice = tra_l.TAXINCLINPRICE ?? 0,
Comment = tra_l.COMMENT,
ExtraInfo = string.IsNullOrEmpty(info_s.DESCRIPTION) ? "NON DELIVERABLE" : info_s.DESCRIPTION
};
var transactionCustomer = from tra_h in db.RBOTRANSACTIONTABLE
join tra_i in db.RBOTRANSACTIONINFOCODETRANS
on
new { tra_h.TRANSACTIONID, INFOCODEID = customerInfoCode } 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.RECEIPTID == receipt &&
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
};
TransactionHeader = transaction.Count() > 0 ? transaction.ToList()[0] : null;
TransactionLines = transactionLine.Count() > 0 ? new TransactionLines(transactionLine.ToList()) : null;
TransactionCustomer = transactionCustomer.Count() > 0 ? transactionCustomer.ToList()[0] : null;
this.dataGridViewReceipt.DataSource = transaction.ToList();
this.dataGridViewTransaction.DataSource = transactionLine.ToList();
this.dataGridViewCustomer.DataSource = transactionCustomer.ToList();
this.TransactionBindingSource.DataSource = TransactionHeader;
this.TransactionCustomerBindingSource.DataSource = TransactionCustomer;
this.TransactionLinesBindingSource.DataSource = TransactionLines;
//ReportDataSource dataSourceTran = new ReportDataSource("Transaction", transaction.Count() > 0 ? transaction.ToList()[0] : null);
//ReportDataSource dataSourceCust = new ReportDataSource("TrransactionCustomer", transactionCustomer.Count() > 0 ? transactionCustomer.ToList()[0] : null);
//ReportDataSource dataSourceLine = new ReportDataSource("TransactionLines", transactionLine.Count() > 0 ? new TransactionLines(transactionLine.ToList()) : null);
//this.reportViewerDelivary.LocalReport.DataSources.Add(dataSourceTran);
//Sthis.reportViewerDelivary.LocalReport.DataSources.Add(dataSourceCust);
//this.reportViewerDelivary.LocalReport.DataSources.Add(dataSourceLine);
this.reportViewerDelivary.RefreshReport();
}
this.dataGridViewReceipt.Refresh();
}