}//end method GetClientByEmail
//method used to add a client to th
public DTO_CORE_Client AddClient(DTO_CORE_Client request)
{
DB_connection context = new DB_connection();
var outputParameter = new System.Data.Entity.Core.Objects.ObjectParameter("new_identity", typeof(int));
var id = context.proc_AddClient(request.FirstName, request.LastName, request.Email,
request.Pass, request.Gender, request.PhoneNumber, outputParameter);
id = (int)outputParameter.Value;
if (id == -1)
{
return(null); //client is already in the system
}
else if (id >= 1)
{
return(request);
}
else
{
//issue adding client
return(null);
}
}//end method AddClient
}//end method GetClientByEmail
//method used to get a client by their email
public List <DTO_CORE_Client> GetClientByEmail(DTO_CORE_Client request)
{
DB_connection context = new DB_connection();
var resultList = context.CORE_Clients.Where(client => client.Email == request.Email).ToList();
List <DTO_CORE_Client> result = new List <DTO_CORE_Client>();
foreach (CORE_Clients client in resultList)
{
DTO_CORE_Client clientByName = new DTO_CORE_Client
{
ClientID = client.ClientID,
FirstName = client.FirstName,
LastName = client.LastName,
//DateJoined = client.DateJoined,
Email = client.Email,
Pass = client.Pass,
Gender = client.Gender,
PhoneNumber = client.PhoneNumber,
Active = (bool)client.Active
};
result.Add(clientByName);
}
return(result);
}//end method GetClientByEmail
}//end method GetClientById
//method used to get a client by their name
public List <DTO_CORE_Client> GetClientByName(DTO_CORE_Client request)
{
GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection();
var resultList = context.CORE_Clients.Where(client => client.FirstName == request.FirstName &&
client.LastName == request.LastName).ToList();//FirstOrDefault();
List <DTO_CORE_Client> result = new List <DTO_CORE_Client>();
foreach (CORE_Clients client in resultList)
{
DTO_CORE_Client clientByName = new DTO_CORE_Client
{
ClientID = client.ClientID,
FirstName = client.FirstName,
LastName = client.LastName,
//DateJoined = client.DateJoined, DateJoined is killed currently due to weird issues
Email = client.Email,
Pass = client.Pass,
Gender = client.Gender,
PhoneNumber = client.PhoneNumber,
Active = (bool)client.Active
};
result.Add(clientByName);
}
return(result);
}//end method GetClientByEmail
public List <DTO_CORE_Client> GetClientAccount(DTO_CORE_Client request)
{
using (DB_connection context = new GigALoan_DAL.DB_connection())
{
var clientList = context.CORE_Clients.ToList();
DTO_CORE_Client successfulMatchedClient = null;
var returnObject = new List <DTO_CORE_Client>();
foreach (var client in clientList)
{
if (request.Email.ToLower() == client.Email.ToLower())
{
if (request.Pass == client.Pass)
{
successfulMatchedClient = new DTO_CORE_Client();
successfulMatchedClient.ClientID = client.ClientID;
successfulMatchedClient.FirstName = client.FirstName;
successfulMatchedClient.LastName = client.LastName;
successfulMatchedClient.DateJoined = client.DateJoined;
successfulMatchedClient.Email = client.Email;
successfulMatchedClient.Pass = client.Pass;
successfulMatchedClient.Gender = client.Gender;
successfulMatchedClient.PhoneNumber = client.PhoneNumber;
if (client.Active != null)
{
successfulMatchedClient.Active = (bool)client.Active;
}
returnObject.Add(successfulMatchedClient);
return(returnObject);
}
}
}
return(null);
}
}
public List <DTO_CORE_Gig> FindGigsByClientID(DTO_CORE_Client request)
{
List <DTO_CORE_Gig> results = new List <DTO_CORE_Gig>();
using (DB_connection context = new GigALoan_DAL.DB_connection())
{
var gigList = context.CORE_Gigs.Where(g => g.CORE_GigAlerts.ClientID == request.ClientID);
foreach (CORE_Gigs gig in gigList)
{
DTO_CORE_Gig result = new DTO_CORE_Gig
{
GigID = gig.GigID,
StudentID = gig.StudentID,
AlertID = gig.AlertID,
DateAccepted = gig.DateAccepted,
StudentComments = gig.StudentComments,
ClientComments = gig.ClientComments
};
if (gig.DateClosed != null)
{
result.DateClosed = (DateTime)gig.DateClosed;
}
if (gig.StudentRating != null)
{
result.StudentRating = (double)gig.StudentRating;
}
if (gig.ClientRating != null)
{
result.ClientRating = (double)gig.ClientRating;
}
results.Add(result);
}
return(results);
}
}
