private void GenericUpdateEntityCollection <T>(EntityCollection <T> collection, ObjectContext dbContext) where T : EntityObject, new() { int count = collection.Count(); int current = 0; List <T> collectionItemList = collection.ToList(); bool isAdded = false; while (current < count) { Object obj = null; dbContext.TryGetObjectByKey(collectionItemList[current].EntityKey, out obj); if (obj == null) { obj = new AgentAirlineMappings(); ((T)obj).EntityKey = collectionItemList[current].EntityKey; dbContext.AddObject(((T)obj).EntityKey.EntitySetName, obj); dbContext.TryGetObjectByKey(collectionItemList[current].EntityKey, out obj); dbContext.ObjectStateManager.ChangeObjectState(obj, System.Data.EntityState.Modified); collection.CreateSourceQuery().Context.ObjectStateManager.ChangeObjectState(collectionItemList[current], System.Data.EntityState.Modified); isAdded = true; } if (obj != null) { dbContext.ApplyCurrentValues <T>(((T)obj).EntityKey.EntitySetName, collectionItemList[current]); if (isAdded) { dbContext.ObjectStateManager.ChangeObjectState(obj, System.Data.EntityState.Added); collection.CreateSourceQuery().Context.ObjectStateManager.ChangeObjectState(collectionItemList[current], System.Data.EntityState.Added); } } current++; } }
public void DeleteAgentRightForAirline(AgentAirlineMappings model) { AgentAirlineMappings datatodelete = db.AgentAirlineMappings.FirstOrDefault(m => m.MappingId == model.MappingId); db.DeleteObject(datatodelete); db.SaveChanges(); }
public bool CheckDuplicateAirline(int AirlineId, int agentid) { AgentAirlineMappings ainfo = db.AgentAirlineMappings.Where(ii => (ii.AirlineId == AirlineId) && (ii.AgentId == agentid)).FirstOrDefault(); if (ainfo != null) { return(false); } else { return(true); } }
public void SaveUpdatedAirlineRight(List <AgentAirlineMappings> mapinfo) { EntityModel ent = new EntityModel(); foreach (var item in mapinfo) { //item.MappingId = ent.AgentAirlineMappings.Where(u => u.AirlineId == item.AirlineId).FirstOrDefault(); //ent.AgentAirlineMappings.AddObject(new AgentAirlineMappings() //{ // AgentId = item.AgentId, // AirlineId = item.AirlineId, // CanView = item.CanView, // CanSell = item.CanSell //}); //ent.ApplyCurrentValues(item.EntityKey.EntitySetName, mapinfo); //ent.AgentAirlineMappings.ApplyCurrentValues(item); AgentAirlineMappings amap = db.AgentAirlineMappings.Where(u => (u.AirlineId == item.AirlineId) && (u.AgentId == item.AgentId)).FirstOrDefault(); amap.MappingId = item.MappingId; db.ApplyCurrentValues(amap.EntityKey.EntitySetName, item); db.SaveChanges(); } }
public void SaveAirlineRight(AgentAirlineMappings minfo) { db.AddToAgentAirlineMappings(minfo); db.SaveChanges(); }