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; }