private void StoreClientInfo(int clientId, LbClient clientProfile)
{
using (var context = new LBDataEntities())
{
context.Connection.Open();
var query = context.tblClients.Where(x => x.ClientId == clientId);
if (!query.Any())
{
var entry = new tblClient();
entry.ClientName = clientProfile.ClientName;
entry.ContactName = clientProfile.ContactName;
entry.ContactEmail = clientProfile.ContactEmail;
entry.ContactPhoneNumber = clientProfile.ContactPhoneNumber;
entry.AccountOpenDate = clientProfile.AccountOpened;
context.tblClients.AddObject(entry);
}
else
{
var entry = query.First();
entry.ClientName = clientProfile.ClientName;
entry.ContactName = clientProfile.ContactName;
entry.ContactEmail = clientProfile.ContactEmail;
entry.ContactPhoneNumber = clientProfile.ContactPhoneNumber;
entry.AccountOpenDate = clientProfile.AccountOpened;
}
context.SaveChanges();
}
}
private bool IsValidUserCredentials(string username, string password)
{
using (var context = new LBDataEntities())
{
context.Connection.Open();
var query = context.tblUsers.Where(x => x.Username.Equals(username));
var entry = query.FirstOrDefault();
if (query != null && query.Any())
{
return(entry.Password == password);
}
}
return(false);
}
private int QueryClientId(string clientName)
{
int clientId = -1;
using (var context = new LBDataEntities())
{
context.Connection.Open();
var query = context.tblClients.Where(x => x.ClientName == clientName);
if (query != null && query.Any())
{
var entry = query.First();
clientId = entry.ClientId;
}
}
return(clientId);
}
private List <int> QueryClientIds()
{
List <int> clientIds = new List <int>();
using (var context = new LBDataEntities())
{
context.Connection.Open();
var query = context.tblClients.Select(x => x.ClientId);
if (query.Any())
{
clientIds = query.ToList();
}
}
return(clientIds);
}
private void DeleteClient(int clientId)
{
using (var context = new LBDataEntities())
{
context.Connection.Open();
var query = context.tblClients.Where(x => x.ClientId == clientId);
if (query != null && query.Any())
{
var entry = query.First();
context.tblClients.DeleteObject(entry);
context.SaveChanges();
}
else
{
errMsg = String.Format("Could not find client {0} in the DB.", clientId);
}
}
}
private LbClient QueryClientProfile(int clientId)
{
LbClient clientProfile = new LbClient(String.Empty, DateTime.Now);
using (var context = new LBDataEntities())
{
context.Connection.Open();
var query = context.tblClients.Where(x => x.ClientId == clientId);
if (query != null && query.Any())
{
var entry = query.First();
clientProfile.ClientName = entry.ClientName;
clientProfile.ContactName = entry.ContactName;
clientProfile.ContactEmail = entry.ContactEmail;
clientProfile.ContactPhoneNumber = entry.ContactPhoneNumber;
if (entry.AccountOpenDate.HasValue)
{
clientProfile.AccountOpened = entry.AccountOpenDate.Value;
}
}
}
return(clientProfile);
}
private void SetConnectionString(LBDataEntities context)
{
context.Connection.ConnectionString = String.Format("datasource={0};initial catalog=LBData;integrated security=False;user id={1};password={2};MultipleActiveResultSets=True;App=EntityFramework",
dbSourceAddress, dbUsername, dbUserPassword);
}
