private String GetCustomerString()
{
CurrentDayPickup r = CurrentPickup;
IQuerySurface db = new DispatchAR.DispatchDB();
//var qry = from cust in db.CUSTOMERS
// where cust.CustomerID=r.CDPCustomerID
// select cust;
/****************
String CustomerString = "";
qry.WHERE("CustomerID", r.CDPCustomerID);
CollectionOfOneCustomer = controller.FetchByQuery(qry);
//error checking
if (CollectionOfOneCustomer.Count != 1)
{
string htmlobj;
htmlobj = qry.Inspect();
StringBuilder ss = new StringBuilder();
ss.AppendLine("Cannot See Details");
ss.AppendLine(CurrentPickup.CurrentDayPickupID.ToString());
ss.Append(htmlobj);
CustomerString = ss.ToString();
}
* ***********************/
String CustomerString = "";
//foreach (var cust in qry) // there is only one
//{
// StringBuilder CustStringBuilder = new StringBuilder();
// CustStringBuilder.AppendLine(cust.CustomerName + " (" + cust.CustomerID + ")");
// CustStringBuilder.AppendLine(cust.Address1);
// //s.AppendLine(.Address2)
// CustStringBuilder.AppendLine(cust.City + ", " + cust.State);
// CustStringBuilder.AppendLine("");
// CustStringBuilder.Append("Contact: ");
// CustStringBuilder.AppendLine(cust.Contact);
// CustStringBuilder.Append("Closing Time: ");
// CustStringBuilder.AppendLine(cust.ClosingTime);
// CustStringBuilder.Append("Phone: ");
// CustStringBuilder.AppendLine(cust.Phone);
// CustomerString = CustStringBuilder.ToString();
// }
return CustomerString;
}
private void GetPickupsForThisInstance()
{
var db = new DispatchDB();
var AllPickupsToday = from cdp in db.CurrentDayPickups
select cdp;
DailyCount = AllPickupsToday.Count();
var qry = from cdp in db.CurrentDayPickups
where cdp.CDPDefaultRouteID == this.Tag
select cdp;
PickupsThisRoute = qry.ToList<CurrentDayPickup>();
}
public frmDeleteDrivers()
{
InitializeComponent();
driver = (DriverBLL)WinClient.ApplicationContext["DriverBLL"];
db = new DispatchDB();
}