public List<Client> RetrieveClientByClientNameAndDomain(string clientName, string domain)
{
DataSet dataSet = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(this.ConnectString, "SP_RetrieveCentralConnectClientByClientNameAndDomain", clientName, domain);
List<Client> clients = new List<Client>();
foreach (DataRow item in dataSet.Tables[0].Rows)
{
Client client = new Client();
client.ClientName = item["ClientName"] as string;
client.Domain = item["Domain"] as string;
client.ProductNumber = item["ProductNumber"] as string;
client.SerialNumber = item["SerialNumber"] as string;
client.CoreSystemModel = item["CoreSystemModel"] as string;
client.MAC = item["MAC"] as string;
client.OSName = item["OSName"] as string;
client.OSVersion = item["OSVersion"] as string;
client.IPAddress = HP.TS.Devops.Core.IPHelper.NumberToIP((int)item["IPAddress"]);
client.CompanyName = item["CompanyName"] as string;
client.PrimaryContact = item["PrimaryContact"] as string;
client.SecondaryContact = item["SecondaryContact"] as string;
client.CreateBy = item["CreateBy"] as string;
clients.Add(client);
}
return clients;
}
public CentralConnectCode CreateClient(Client client)
{
//Contact
ContactAction contactAction = new ContactAction(this.ConnectString);
List<Contact> primaryContacts = contactAction.RetrieveContactByFullName(client.PrimaryContact);
if (primaryContacts.Count != 1)
{
return CentralConnectCode.PrimaryContactNotFound;
}
List<Contact> secondaryContacts = contactAction.RetrieveContactByFullName(client.SecondaryContact);
if (secondaryContacts.Count != 1)
{
return CentralConnectCode.SecondaryContactNotFound;
}
//Company
CompanyAction companyAction = new CompanyAction(this.ConnectString);
List<Company> companys = companyAction.RetrieveCompanyByCompanyName(client.CompanyName);
if (companys.Count != 1)
{
return CentralConnectCode.CompanyNotFound;
}
if (Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(this.ConnectString, "SP_CreateCentralConnectClient", client.ClientName, client.Domain, client.ProductNumber, client.SerialNumber, client.CoreSystemModel, client.OSName, client.OSVersion, client.CompanyName, client.PrimaryContact, client.SecondaryContact, client.CreateBy) != 1)
{
return CentralConnectCode.CreateClientFail;
}
return CentralConnectCode.Success;
}