public void FindClient(string clientName)
{
using (InfrastructureEntities context = new InfrastructureEntities())
{
var result = context.Clients.FirstOrDefault(x => x.Name == clientName);
CodeName = result.Code;
Id = result.Id;
Name = result.Name;
}
}
public string GetAuthKey(int clientVendorId)
{
using (InfrastructureEntities context = new InfrastructureEntities()) {
var result = context.AuthorizationWS.Where(x => x.ClientVendorId == clientVendorId).ToList();
foreach (var obj in result)
{
UniqueIdentifier = obj.AuthorizationGuid.ToString();
}
}
return(UniqueIdentifier);
}
public int GetClientVendorId(string vendorName, string clientName)
{
using (InfrastructureEntities context = new InfrastructureEntities())
{
var result = context.v_ClientVendors.Where(c => c.ClientName == clientName && c.VendorName == vendorName).ToList();
foreach (var obj in result)
{
Id = obj.ClientVenderId;
}
}
return(Id);
}
public void CreateClientVendorRel(Client client, Vendor vendor, AuthKey authKey)
{
using (InfrastructureEntities context = new InfrastructureEntities()) {
var result = context.ClientVendorRels.Select(v => v).ToList();
var clientVendor = new ClientVendorRel();
clientVendor.ClientId = client.Id;
clientVendor.VendorId = vendor.Id;
clientVendor.SourceName = vendor.VendorName + "-" + client.CodeName;
clientVendor.Enabled = true;
clientVendor.CreatedTime = DateTime.Now;
context.ClientVendorRels.Add(clientVendor);
context.SaveChanges();
authKey.UniqueIdentifier = authKey.CreateAuthKey(clientVendor);
}
}
private void AddVendor(string vendorName)
{
using (InfrastructureEntities context = new InfrastructureEntities())
{
var results = context.Vendors.Select(v => v).ToList();
var vendor = new Data.Vendor();
vendor.CreatedTime = DateTime.Now;
vendor.Enabled = true;
vendor.VendorName = vendorName;
vendor.Id = results.Count;
results.Add(vendor);
context.Vendors.Add(vendor);
context.SaveChanges();
}
}
//private List<Client> FindClients()
//{
// using (InfrastructureEntities context = new InfrastructureEntities())
// {
// return FindClients(context);
// }
//}
private List <Client> FindClients(List <Client> clientList)
{
using (InfrastructureEntities context = new InfrastructureEntities())
{
var result = context.Clients.OrderBy(x => x.Name).ToList();
foreach (var obj in result)
{
Client client = new Client();
client.Id = obj.Id;
client.Name = obj.Name;
client.CodeName = obj.Code;
clientList.Add(client);
}
}
return(clientList);
}
public void FindVendor(string vendorName)
{
using (InfrastructureEntities context = new InfrastructureEntities())
{
var result = context.Vendors.FirstOrDefault(x => x.VendorName == vendorName);
if (result == null)
{
AddVendor(vendorName);
}
else
{
Id = result.Id;
VendorName = result.VendorName;
}
}
}
public string CreateAuthKey(ClientVendorRel clientVendor)
{
AuthKey authKey = new AuthKey();
using (InfrastructureEntities context = new InfrastructureEntities()) {
var result = context.AuthorizationWS.Select(v => v).ToList();
var newAuth = new AuthorizationW();
newAuth.AuthorizationGuid = Guid.NewGuid();
authKey.UniqueIdentifier = newAuth.AuthorizationGuid.ToString();
newAuth.ClientVendorId = clientVendor.Id;
newAuth.InternalURL = "http://api.dev.rmiatl.org/lead/v2/";
newAuth.Enabled = true;
newAuth.CreatedTime = DateTime.Now;
context.AuthorizationWS.Add(newAuth);
context.SaveChanges();
}
return(authKey.UniqueIdentifier);
}
private List <ClientVendor> FindClientVendor(List <ClientVendor> clientVendorsRel)
{
using (InfrastructureEntities context = new InfrastructureEntities())
{
var result = context.ClientVendorRels.Select(x => x).OrderBy(x => x.SourceName).ToList();
foreach (var obj in result)
{
ClientVendor clientVendor = new ClientVendor();
clientVendor.Id = obj.Id;
clientVendor.ClientId = obj.ClientId;
clientVendor.VendorId = obj.VendorId;
clientVendor.SourceName = obj.SourceName;
clientVendor.Enabled = obj.Enabled;
clientVendor.CreatedTime = obj.CreatedTime;
clientVendorsRel.Add(clientVendor);
}
}
return(clientVendorsRel);
}
private List <Vendor> FindVendors(List <Vendor> vendorList)
{
using (InfrastructureEntities context = new InfrastructureEntities())
{
var result = context.Vendors.Select(x => x).OrderBy(x => x.VendorName).ToList();
foreach (var obj in result)
{
if (obj.VendorName != "Test")
{
Vendor vendor = new Vendor();
vendor.Id = obj.Id;
vendor.VendorName = obj.VendorName;
vendor.Enabled = obj.Enabled;
vendor.CreatedTime = obj.CreatedTime;
vendorList.Add(vendor);
}
}
}
return(vendorList);
}
