public int UpdatePocketVillageMappingOfPocket(List <PocketVillageMapping> pocketVillageMappingList)
{
try
{
List <PocketVillageMapping> ExistingList = GetPocketVillageMappingListOfPocket(pocketVillageMappingList.ElementAt(0).PocketId.Value).ToList();
List <PocketVillageMapping> villageMappingToUpdate = pocketVillageMappingList.Select(x => x).Where(x => x.Id > 0).ToList();
List <PocketVillageMapping> villageMappingToInsert = pocketVillageMappingList.Select(x => x).Where(x => x.Id == 0).ToList();
List <PocketVillageMapping> villageMappingToDelete = ExistingList.Select(x => x).Where(x => !pocketVillageMappingList.Select(y => y.Id).Contains(x.Id)).ToList();
InsertPocketVillageMappingOfPocket(villageMappingToInsert);
DeletePocketVillageMappingListOfPocket(villageMappingToDelete);
PocketVillageMapping pocketMapping = null;
villageMappingToUpdate.ForEach(y =>
{
pocketMapping = db.PocketVillageMappings.Select(x => x).Where(x => x.Id == y.Id).FirstOrDefault();
if (pocketMapping != null)
{
pocketMapping.IsActive = y.IsActive;
pocketMapping.PocketId = y.PocketId;
pocketMapping.SubDistrictId = y.SubDistrictId;
pocketMapping.UpdatedDate = DateTime.Now;
pocketMapping.VillageId = y.VillageId;
}
});
return(db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public int DeletePocketVillageMappingListOfPocket(List <PocketVillageMapping> pocketVillageMappingList)
{
PocketVillageMapping pocketMapping = null;
pocketVillageMappingList.ForEach(y =>
{
pocketMapping = db.PocketVillageMappings.Select(x => x).Where(x => x.Id == y.Id).FirstOrDefault();
db.PocketVillageMappings.Remove(pocketMapping);
});
return(db.SaveChanges());
}
public PocketVillageMapping GetPocketVillageMappingOfPocket(int pocketVillageMappingId)
{
try
{
PocketVillageMapping pocketMapping = db.PocketVillageMappings.Select(x => x).Where(x => x.Id == pocketVillageMappingId).FirstOrDefault();
return(pocketMapping);
}
catch (Exception ex)
{
throw ex;
}
}
