public bool SaveAllMappingFields(long id, long cid, string accountGUID)
{
CCFieldMapping fieldMapping = new CCFieldMapping();
var folderFields = this.context.CCFolderFields.Where(fid => fid.FolderID == id).ToList();
foreach (var ff in folderFields)
{
fieldMapping.ConnectionID = cid;
fieldMapping.FieldName = ff.FieldName;
fieldMapping.Caption = ff.FieldCaption;
fieldMapping.MappedFieldID = ff.FieldID;
fieldMapping.AccountGUID = accountGUID;
var res = SaveFieldMapping(fieldMapping);
}
return true;
}
public ActionResult SelectMappingFields(string fields, MappingFieldsViewModel objMappingFileds)
{
Account accountObj = (Account)Session["account"];
CCFieldMapping fieldMapping = new CCFieldMapping();
var objFields = Newtonsoft.Json.JsonConvert.DeserializeObject<List<string>>(fields);
var mappingfields = CCFieldRepository.CCFolderFields.Where(fid => fid.FolderID == objMappingFileds.FolderID).ToList();
var savedfield = CCFieldMappingsRepository.CCFieldsMapping
.Where(sid => sid.ConnectionID == objMappingFileds.SubscriptionID).ToList();
if (savedfield.Count > 0)
{
CCFieldMappingsRepository.DeleteMappingFieldBySubscriptionID(objMappingFileds.SubscriptionID);
}
foreach (var mfield in objFields)
{
var mapfield = mappingfields.FirstOrDefault(fname => fname.FieldCaption == mfield);
if (mapfield != null)
{
fieldMapping.ConnectionID = objMappingFileds.SubscriptionID;
fieldMapping.FieldName = FieldsConfigHelper.GetRealName(mapfield.FieldName);
fieldMapping.Caption = mapfield.FieldCaption;
fieldMapping.MappedFieldID = mapfield.FieldID;
fieldMapping.AccountGUID = accountObj.AccountGUID;
var res = CCFieldMappingsRepository.SaveFieldMapping(fieldMapping);
}
}
return RedirectToAction("ViewConnections", "Folder", new { id = objMappingFileds.FolderID });
}
public CCFieldMapping SaveFieldMapping(CCFieldMapping FieldMappingObj)
{
context.CCFieldMappings.Add(FieldMappingObj);
context.SaveChanges();
return FieldMappingObj;
}
