public int DeleteInterfaceXRef(ClientDefinedFieldDto clientDefinedField) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = sdaCloudEntities.InterfaceXRefs.FirstOrDefault(i => i.InterfaceXRefID == clientDefinedField.InterfaceXRefID); if (existingCDF != null) { //sdaCloudEntities.DeleteObject(existingCDF); } result = sdaCloudEntities.SaveChanges(); if (result >= 0) { var client = sdaCloudEntities.Clients.FirstOrDefault(o => o.ClientID == clientDefinedField.ClientID); if (client != null) { client.CRMXrefUpdDT = DateTime.Now; sdaCloudEntities.SaveChanges(); } } transactionScope.Complete(); } } return(result); }
public int AddInterfaceXRef(ClientDefinedFieldDto clientDefinedField) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = new InterfaceXRef { Txn = "CRMXref", ClientID = clientDefinedField.ClientID, InterfaceTable = clientDefinedField.Table, InterfaceField = clientDefinedField.Field, InterfaceFieldType = (clientDefinedField.Format.Equals("Text")) ? "Varchar" : "Decimal", SDASMTable = clientDefinedField.Table, SDASMField = clientDefinedField.Field, SDASMFieldType = clientDefinedField.Format, SDARangeName = clientDefinedField.SDARangeName }; sdaCloudEntities.InterfaceXRefs.AddObject(existingCDF); sdaCloudEntities.SaveChanges(); result = existingCDF.InterfaceXRefID; if (result > 0) { var client = sdaCloudEntities.Clients.FirstOrDefault(o => o.ClientID == clientDefinedField.ClientID); if (client != null) { client.CRMXrefUpdDT = DateTime.Now; sdaCloudEntities.SaveChanges(); } } 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); }
public int UpdateInterfaceXRef(ClientDefinedFieldDto clientDefinedField) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = sdaCloudEntities.InterfaceXRefs.FirstOrDefault(i => i.InterfaceXRefID == clientDefinedField.InterfaceXRefID); if (existingCDF != null) { existingCDF.InterfaceTable = clientDefinedField.Table; existingCDF.InterfaceField = clientDefinedField.Field; existingCDF.InterfaceFieldType = (clientDefinedField.Format.Equals("Text")) ? "Varchar" : "Decimal"; existingCDF.SDASMTable = clientDefinedField.Table; existingCDF.SDASMField = clientDefinedField.Field; existingCDF.SDASMFieldType = clientDefinedField.Format; existingCDF.SDARangeName = clientDefinedField.SDARangeName; } result = sdaCloudEntities.SaveChanges(); if (result > 0) { var client = sdaCloudEntities.Clients.FirstOrDefault(o => o.ClientID == clientDefinedField.ClientID); if (client != null) { client.CRMXrefUpdDT = DateTime.Now; sdaCloudEntities.SaveChanges(); } } transactionScope.Complete(); } } return(result); }
public int AddClientDefinedField(ClientDefinedFieldDto clientDefinedField) { var clientDefinedFieldDl = new ClientDefinedFieldDL(); return(clientDefinedFieldDl.AddClientDefinedField(clientDefinedField)); }