public string DeleteCDFs(string uList) { string result = string.Empty; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = uList.Split(',').ToList(); var clientDefinedFields = new List <ClientDefinedField>(); foreach (var uv in tagIds) { int uvId; Int32.TryParse(uv, out uvId); var clientDefinedField = sdaCloudEntities.ClientDefinedFields.Where(q => q.ClientDefinedFieldID == uvId).SingleOrDefault(); if (clientDefinedField != null) { clientDefinedFields.Add(clientDefinedField); } else { if (!string.IsNullOrEmpty(result)) { result += ","; } result += uv; } } foreach (var cdf in clientDefinedFields) { Mapper.CreateMap <ClientDefinedField, ClientDefinedFieldDto>(); var existingCDF = Mapper.Map <ClientDefinedField, ClientDefinedFieldDto>(cdf); ////Mapper.AssertConfigurationIsValid(); InterfaceXRefDL interfaceXrefDL = new InterfaceXRefDL(); var deleted = interfaceXrefDL.DeleteInterfaceXRef(existingCDF); if (deleted >= 0) { //check this //sdaCloudEntities.DeleteObject(cdf); } } sdaCloudEntities.SaveChanges(); } return(result); }
public int UpdateCDFField(int cdfId, string field, string newValue) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { using (var transactionScope = new TransactionScope()) { var existingCDF = sdaCloudEntities.ClientDefinedFields.FirstOrDefault(i => i.ClientDefinedFieldID == cdfId); if (existingCDF != null) { Type t = existingCDF.GetType(); PropertyInfo info = t.GetProperty(field); if (info == null) { return(-1); } if (!info.CanWrite) { return(-1); } info.SetValue(existingCDF, newValue, null); result = sdaCloudEntities.SaveChanges(); Mapper.CreateMap <ClientDefinedField, ClientDefinedFieldDto>(); var cDF = Mapper.Map <ClientDefinedField, ClientDefinedFieldDto>(existingCDF); ////Mapper.AssertConfigurationIsValid(); InterfaceXRefDL interfaceXrefDL = new InterfaceXRefDL(); var interfaceXrefId = interfaceXrefDL.UpdateInterfaceXRef(cDF); } transactionScope.Complete(); } } } return(result); }
public int AddClientDefinedField(ClientDefinedFieldDto clientDefinedField) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = new ClientDefinedField { ClientID = clientDefinedField.ClientID, Table = clientDefinedField.Table, Field = clientDefinedField.Field, ColumnHeader = clientDefinedField.ColumnHeader, Format = clientDefinedField.Format, SDARangeName = clientDefinedField.SDARangeName }; sdaCloudEntities.ClientDefinedFields.AddObject(existingCDF); result = sdaCloudEntities.SaveChanges(); if (result > 0) { InterfaceXRefDL interfaceXrefDL = new InterfaceXRefDL(); var interfaceXrefId = interfaceXrefDL.AddInterfaceXRef(clientDefinedField); if (interfaceXrefId > 0) { existingCDF.InterfaceXRefID = interfaceXrefId; sdaCloudEntities.SaveChanges(); } } result = existingCDF.ClientDefinedFieldID; transactionScope.Complete(); } } return(result); }