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