/// <summary>
/// Create a new cg_Products_Activities_Map object.
/// </summary>
/// <param name="productActivityMapId">Initial value of the ProductActivityMapId property.</param>
public static cg_Products_Activities_Map Createcg_Products_Activities_Map(global::System.Int64 productActivityMapId)
{
cg_Products_Activities_Map cg_Products_Activities_Map = new cg_Products_Activities_Map();
cg_Products_Activities_Map.ProductActivityMapId = productActivityMapId;
return cg_Products_Activities_Map;
}
/// <summary>
/// Deprecated Method for adding a new object to the cg_Products_Activities_Map EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTocg_Products_Activities_Map(cg_Products_Activities_Map cg_Products_Activities_Map)
{
base.AddObject("cg_Products_Activities_Map", cg_Products_Activities_Map);
}
public ActionResult product_activities_update(FormCollection collection)
{
long ProductId = Convert.ToInt64(collection["ProductId"]);
cg_Products product = db.cg_Products.Where(p => p.ProductId == ProductId).FirstOrDefault();
string[] activityIds = collection["productActivity"].Split(',');
// load existing tags
product.cg_Products_Activities_Map.Load();
var activityList = product.cg_Products_Activities_Map.ToList();
// remove all existing tags
foreach (cg_Products_Activities_Map actmap in activityList)
{
if (!activityIds.Contains(actmap.ProductActivityMapId.ToString()))
{
db.DeleteObject(actmap);
}
else
{
activityIds = activityIds.Where(val => val != actmap.ProductActivityMapId.ToString()).ToArray();
}
}
// create a collection of the new tag list
foreach (string sActivityId in activityIds)
{
if (sActivityId != "false")
{
long activityId = Convert.ToInt64(sActivityId);
// create the new object
//cg_Products_Activities_Map tmap = new cg_Products_Activities_Map() { = ProductId, ProductTagId = activityId };
cg_Products_Activities_Map amap = new cg_Products_Activities_Map();
amap.cg_ProductsReference.EntityKey = new System.Data.EntityKey("caval_goEntities.cg_Products", "ProductId", ProductId);
amap.cg_ActivitiesReference.EntityKey = new System.Data.EntityKey("caval_goEntities.cg_Activities", "ActivityId", activityId);
// add object to collection
db.AddTocg_Products_Activities_Map(amap);
//Response.Write("TagId: " + tagId + "<br /> ProductId: " + ProductId + "<hr />");
}
}
// save changes to DB
db.SaveChanges();
return RedirectToAction("product_edit", new { id = ProductId });
}
