public User SelectUserByID(int userID)
{
User user = null;
using (var context = new dconfianzaEntities())
{
reg_spSelectUserByID_Result userEF = context.reg_spSelectUserByID(userID).FirstOrDefault();
if (userEF != null)
{
user = new User();
user.ActivationDate = userEF.ActivationDate.HasValue ? userEF.ActivationDate.Value : DateTime.MinValue;
user.BirthDate = userEF.BirthDate.HasValue ? userEF.BirthDate.Value : (DateTime?)null;
user.CreatedDate = userEF.CreatedDate;
user.CreatedBy = userEF.CreatedBy.HasValue ? userEF.CreatedBy.Value : 0;
user.Description = userEF.Description;
user.Email = userEF.Email;
user.FacebookID = userEF.FacebookID.HasValue ? userEF.FacebookID.Value : 0;
user.FirstName = userEF.FirstName;
user.Gender = userEF.Gender.HasValue ? userEF.Gender.Value : 0;
user.IsApproved = userEF.IsApproved.HasValue ? userEF.IsApproved.Value : false;
user.IsLockedOut = userEF.IsLockedOut.HasValue ? userEF.IsLockedOut.Value : false;
user.LastLoginDate = userEF.LastLoginDate.HasValue ? userEF.LastLoginDate.Value : DateTime.MinValue;
user.LastName = userEF.LastName;
user.LastUpdatedBy = userEF.LastUpdatedBy.HasValue ? userEF.LastUpdatedBy.Value : 0;
user.LastUpdatedDate = userEF.LastUpdatedDate.HasValue ? userEF.LastUpdatedDate.Value : DateTime.MinValue;
user.Password = null;
user.TerminationDate = userEF.TerminationDate.HasValue ? userEF.TerminationDate.Value : DateTime.MinValue;
user.UserID = userEF.UserID;
user.IsProfileComplete = this.IsProfileComplete(user.UserID);
}
}
return(user);
}
public int ContactMessageInsert(int userID, String email, String message)
{
using (var context = new dconfianzaEntities())
{
return((int)context.spContacMessageInsert(email, message, userID).FirstOrDefault().ContactMessageID);
}
}
public List <WorkerReview> SelectWorkerReviews(int workerID)
{
List <WorkerReview> list = null;
using (var context = new dconfianzaEntities())
{
List <spWorkeReviewSelectByID_Result> result = context.spWorkeReviewSelectByID(workerID).ToList();
if (result != null)
{
list = new List <WorkerReview>();
foreach (spWorkeReviewSelectByID_Result item in result)
{
WorkerReview workerReview = new WorkerReview();
workerReview.ID = item.WorkerReviewID;
workerReview.WorkerID = item.WorkerID;
workerReview.FirstName = item.FirstName;
workerReview.LastName = item.LastName;
workerReview.Review = item.Review;
workerReview.Rating = item.Rating;
workerReview.CreatedDate = item.CreatedDate;
workerReview.CreatedByFirstName = item.CreatedByFirstName;
workerReview.CreatedByLastName = item.CreatedByLastName;
list.Add(workerReview);
}
}
}
return(list);
}
public Worker SelectWorkerByID(int workerID)
{
Worker worker = null;
using (var context = new dconfianzaEntities())
{
spWorkerSelectByID_Result result = context.spWorkerSelectByID(workerID).FirstOrDefault();
if (result != null)
{
worker = worker = new Worker();
worker.ID = result.WorkerID;
worker.FirstName = result.FirstName;
worker.LastName = result.LastName;
worker.MobilPhone = result.MobilPhone;
worker.WorkPhone = result.WorkPhone;
worker.Email = result.Email;
worker.LocationID = result.LocationID;
worker.LocationName = result.LocationName;
worker.Rating = result.Rating.Value;
worker.Resume = result.Resume;
worker.Active = result.Active;
worker.CreatedDate = result.CreatedDate;
worker.CreatedByID = result.CreatedByID;
worker.CreatedByFirstName = result.CreatedByFirstName;
worker.CreatedByLastName = result.CreatedByLastName;
worker.ServiceID = result.ServiceID;
worker.ServiceName = result.ServiceName;
}
}
return(worker);
}
/// <summary>
/// Crea un nuevo usuario
/// </summary>
/// <param name="firstName"></param>
/// <param name="lastName"></param>
/// <param name="email"></param>
/// <param name="password"></param>
/// <returns></returns>
public User CreateUser(User user)
{
using (var context = new dconfianzaEntities())
{
int userID = (int)context.reg_spInsertUser(user.FirstName, user.LastName, user.Email, null, user.Password).FirstOrDefault().UserID;
return(SelectUserByID(userID));
}
}
public int WorkerInsert(String firstName, String lastName, String mobilePhone, String workPhone, String email, int locationID, int serviceID, int userID)
{
using (var context = new dconfianzaEntities())
{
spWorkerInsert_Result result = context.spWorkerInsert(firstName, lastName, mobilePhone, workPhone, email, locationID, serviceID, null, userID).FirstOrDefault();
return((int)result.WorkerID);
}
}
public int WorkerReviewInsert(int userID, int workerID, string review, double rating)
{
using (var context = new dconfianzaEntities())
{
spWorkerReviewInsert_Result result = context.spWorkerReviewInsert(userID, workerID, review, rating).FirstOrDefault();
return((int)result.WorkerReviewID);
}
}
public int FindUserByEmail(string email)
{
int userID = 0;
using (var context = new dconfianzaEntities())
{
userID = context.reg_spFindUserByEmail(email).FirstOrDefault().UserID;
}
return(userID);
}
public User LoginByEmail(string email, byte[] password)
{
int? userID = 0;
User retUser = null;
using (var context = new dconfianzaEntities())
{
userID = context.reg_spLoginByEmail(email, password).SingleOrDefault();
}
if (userID.HasValue && userID.Value > 0)
{
retUser = this.SelectUserByID(userID.Value);
}
return(retUser);
}
public List <Service> SelectServiceByLocationID(int locationID)
{
List <Service> list = null;
using (var context = new dconfianzaEntities())
{
List <spSelectServiceByLocationID_Result> result = context.spSelectServiceByLocationID(locationID).ToList();
if (result != null)
{
list = new List <Service>();
foreach (spSelectServiceByLocationID_Result item in result)
{
Service service = new Service();
service.ID = item.ServiceID;
service.Name = item.ServiceName;
list.Add(service);
}
}
}
return(list);
}
public List <Location> SelectLocation()
{
List <Location> list = null;
using (var context = new dconfianzaEntities())
{
List <spLocationSelectAll_Result> result = context.spLocationSelectAll().ToList();
if (result != null)
{
list = new List <Location>();
foreach (spLocationSelectAll_Result item in result)
{
Location location = new Location();
location.ID = item.LocationID;
location.Name = item.LocationName;
list.Add(location);
}
}
}
return(list);
}
public List <Worker> SelectActiveWorkersByLocationAndService(int locationID, int serviceID)
{
List <Worker> list = null;
using (var context = new dconfianzaEntities())
{
List <spSelectActiveWorkersByLocationAndService_Result> result = context.spSelectActiveWorkersByLocationAndService(locationID, serviceID).ToList();
if (result != null)
{
list = new List <Worker>();
foreach (spSelectActiveWorkersByLocationAndService_Result item in result)
{
Worker worker = new Worker();
worker.ID = item.WorkerID;
worker.FirstName = item.FirstName;
worker.LastName = item.LastName;
worker.MobilPhone = item.MobilPhone;
worker.WorkPhone = item.WorkPhone;
worker.Email = item.Email;
worker.LocationID = item.LocationID;
worker.LocationName = item.LocationName;
worker.Rating = item.Rating.Value;
worker.Resume = item.Resume;
worker.Active = item.Active;
worker.CreatedDate = item.CreatedDate;
worker.CreatedByID = item.CreatedByID;
worker.CreatedByFirstName = item.CreatedByFirstName;
worker.CreatedByLastName = item.CreatedByLastName;
worker.ServiceID = item.ServiceID;
worker.ServiceName = item.ServiceName;
list.Add(worker);
}
}
}
return(list);
}
