public OnTheSpot.Models.InterogatorInfo getInfoForInterogator(OnTheSpot.Models.AutoSortInfo customerstuff)
{
double heatseal = double.Parse(customerstuff.HeatSeal);
OnTheSpot.Models.InterogatorInfo info = (from cust in dbOTS.Customers
where cust.CustomerID == customerstuff.CustomerID
from heat in dbOTS.Heatseals
where heat.HeatsealID == heatseal
select new OnTheSpot.Models.InterogatorInfo()
{
HomePhone = cust.HomePhone, Email = cust.EMail, InvoiceReminder = cust.InvReminder,
LastOrder = cust.LastOrder, Notes = cust.Notes, OpenDate = cust.OpenDate, HeatSealMessage = heat.Message
}).SingleOrDefault();
List <OnTheSpot.EFStuff.Contacts> contacts = (from contact in dbOTS.Contacts
where contact.CustomerID == customerstuff.CustomerID
select contact).ToList();
info.CustomerID = customerstuff.CustomerID.ToString();
info.OpenDateString = info.OpenDate.Value.ToShortDateString();
info.LastOrderString = info.LastOrder.Value.ToShortDateString();
info.issues = new List <string>();
info.resolutions = new List <string>();
foreach (OnTheSpot.EFStuff.Contacts contact in contacts)
{
info.issues.Add(contact.Issue);
info.resolutions.Add(contact.Resolution);
}
info.currentIssue = info.issues[0];
info.currentResolution = info.resolutions[0];
return(info);
}
//we used the barcode to get the cutomer info from assembly database as it knows which store the
//info we need is
public OnTheSpot.Models.InterogatorInfo getInfoForInterogator(OnTheSpot.Models.AutoSortInfo customerstuff)
{
double heatseal = double.Parse(customerstuff.HeatSeal);
string storeconnectionstring = connectionNames[customerstuff.storeid - 1];
//retrieve the connection string from app.config
ConnectionStringSettingsCollection connections = ConfigurationManager.ConnectionStrings;
StoreContext db = new StoreContext(connections[storeconnectionstring].ConnectionString);
OnTheSpot.Models.InterogatorInfo info = (from cust in db.Customers
where cust.CustomerID == customerstuff.CustomerID
from heat in db.Heatseals
where heat.HeatsealID == heatseal
select new OnTheSpot.Models.InterogatorInfo()
{
HomePhone = cust.HomePhone, Email = cust.EMail, InvoiceReminder = cust.InvReminder,
LastOrder = cust.LastOrder, Notes = cust.Notes, OpenDate = cust.OpenDate, HeatSealMessage = heat.Message
}).SingleOrDefault();
if (info == null)
{
return(null);
}
List <Contact> contacts = (from contact in dbStore.Contacts
where contact.CustomerID == customerstuff.CustomerID
select contact).ToList();
info.CustomerID = customerstuff.CustomerID.ToString();
info.OpenDateString = info.OpenDate.Value.ToShortDateString();
info.LastOrderString = info.LastOrder.Value.ToShortDateString();
info.issues = new List <string>();
info.resolutions = new List <string>();
foreach (Contact contact in contacts)
{
info.issues.Add(contact.Issue);
info.resolutions.Add(contact.Resolution);
}
if (info.issues.Count > 0)
{
info.currentIssue = info.issues[0];
}
if (info.resolutions.Count > 0)
{
info.currentResolution = info.resolutions[0];
}
return(info);
}
