partial void CreateNewTechnicalQuery_Saving(ref bool handled)
{
//here we need to capture what little information we may have from the screen when this is a non-project TQ.
if (!IsProjectTQ)
{
this.TQDetailProperty.MatrixSalesOrderNo = ManualSalesOrderNo;
this.TQDetailProperty.Customer = ManualCustomerName;
this.TQDetailProperty.CustomerOrderNo = ManualCustomerOrderNo;
IEnumerable <MatrixSalesOrderNumber> foundSON = (from MatrixSalesOrderNumber a in this.DataWorkspace.MDSData.MatrixSalesOrderNumbers
where a.SalesOrderNo == TQDetailProperty.MatrixSalesOrderNo
select a).AsEnumerable();
if (foundSON.Count <MatrixSalesOrderNumber>() == 0)
{
MatrixSalesOrderNumber mson = this.DataWorkspace.MDSData.MatrixSalesOrderNumbers.AddNew();
mson.Customer = TQDetailProperty.Customer;
mson.SalesOrderNo = TQDetailProperty.MatrixSalesOrderNo;
this.DataWorkspace.MDSData.SaveChanges();
}
//add data to the customer table
IEnumerable <Customer> foundCust = (from Customer c in this.DataWorkspace.MDSData.Customers
where c.CustomerName == TQDetailProperty.Customer
select c).AsEnumerable();
if (foundCust.Count <Customer>() == 0)
{
Customer cust = this.DataWorkspace.MDSData.Customers.AddNew();
cust.CustomerName = TQDetailProperty.Customer;
this.DataWorkspace.MDSData.SaveChanges();
}
}
else
{
this.TQDetailProperty.Customer = SelectedCustomer.CustomerName;
}
}
partial void CreateNewRFI_Saving(ref bool handled)
{
if (!IsProjectRFI)
{
this.RFIProperty.MatrixSalesOrderNo = RFIProperty.MatrixSalesOrderNo;
this.RFIProperty.Customer = RFIProperty.Customer;
//add data to the matrixsalesordernumber table
IEnumerable <MatrixSalesOrderNumber> foundSON = (from MatrixSalesOrderNumber a in this.DataWorkspace.MDSData.MatrixSalesOrderNumbers
where a.SalesOrderNo == RFIProperty.MatrixSalesOrderNo
select a).AsEnumerable();
if (foundSON.Count <MatrixSalesOrderNumber>() == 0)
{
MatrixSalesOrderNumber mson = this.DataWorkspace.MDSData.MatrixSalesOrderNumbers.AddNew();
mson.Customer = RFIProperty.Customer;
mson.SalesOrderNo = RFIProperty.MatrixSalesOrderNo;
this.DataWorkspace.MDSData.SaveChanges();
}
//add data to the customer table
IEnumerable <Customer> foundCust = (from Customer c in this.DataWorkspace.MDSData.Customers
where c.CustomerName == RFIProperty.Customer
select c).AsEnumerable();
if (foundCust.Count <Customer>() == 0)
{
Customer cust = this.DataWorkspace.MDSData.Customers.AddNew();
cust.CustomerName = RFIProperty.Customer;
this.DataWorkspace.MDSData.SaveChanges();
}
//add data to the Customer staff table
IEnumerable <ClientStaffMember> foundStaff = (from ClientStaffMember d in this.DataWorkspace.MDSData.ClientStaffMembers
where d.Name == RFIProperty.RFIRecipient
select d).AsEnumerable();
if (foundStaff.Count <ClientStaffMember>() == 0)
{
ClientStaffMember staff = this.DataWorkspace.MDSData.ClientStaffMembers.AddNew();
staff.Name = RFIProperty.RFIRecipient;
staff.Customer.CustomerName = RFIProperty.Customer;
this.DataWorkspace.MDSData.SaveChanges();
}
}
else
{
this.RFIProperty.Customer = SelectedCustomer.CustomerName;
//calculate the list of recipients now!
//var recipients = from r in ClientStaffMemberRFIRecipients
// where r.ClientStaffMember.Name != null
// select r.ClientStaffMember.Name;
//this.RFIProperty.RFIRecipient = String.Join(", ", recipients);
}
}
