protected void UpdateCustomerProductsTabel(RadComboBox cmbCustomerProduct, string productId)
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext(((Guid)Session["CurrentUserId"])))
{
foreach (RadComboBoxItem Item in cmbCustomerProduct.Items)
{
if (!String.IsNullOrEmpty(Item.Value))
{
var CustProdRelation = dbContext.CustomerProduct.SingleOrDefault(q => q.CustomerId == new Guid(Item.Value) && q.ProductId == new Guid(productId));
if (CustProdRelation != null) // exists
{
if (Item.Checked) //checked and exists - nothing
{
}
else // exits, but not checked - delete
{
dbContext.CustomerProduct.DeleteOnSubmit(CustProdRelation);
}
}
else //not exists
{
if (Item.Checked) //checked and not exists - insert
{
CustomerProduct newCustProd = new CustomerProduct { CustomerId = new Guid(Item.Value), ProductId = new Guid(productId) };
dbContext.CustomerProduct.InsertOnSubmit(newCustProd);
}
else // not exists and not checked - nothing
{
// dbContext.CustomerProduct.DeleteOnSubmit(CustProdRelation);
}
}
dbContext.SubmitChanges();
}
}
}
}
private void detach_CustomerProduct(CustomerProduct entity)
{
this.SendPropertyChanging();
entity.Customer = null;
}
private void attach_CustomerProduct(CustomerProduct entity)
{
this.SendPropertyChanging();
entity.Customer = this;
}
partial void DeleteCustomerProduct(CustomerProduct instance);
partial void UpdateCustomerProduct(CustomerProduct instance);
partial void InsertCustomerProduct(CustomerProduct instance);
