public ResponseOut UpdateUserProfile(UserViewModel model, int user_id)
{
using (PortalEntities _context = new PortalEntities())
{
ResponseOut responseOut = new ResponseOut();
try
{
portal_user _user = _context.portal_user.Find(user_id);
_user.firstname = model.firstname;
_user.lastname = model.lastname;
_user.updated_date = DateTime.Now;
_user.email = model.email;
_user.contact = model.contact;
_user.fk_country_id = model.fk_country_id;
_user.fk_city_id = model.fk_city_id;
_user.fk_state_id = model.fk_state_id;
_user.profile_pic = model.profile_pic;
_user.about_us = model.about_us;
_user.is_active = model.is_active;
_user.is_paid_user = model.is_paid_user;
int return_code = _context.SaveChanges();
if (return_code == 1)
{
responseOut.status = ActionStatus.Success;
responseOut.message = ActionMessage.ProfileUpdatedSuccess;
}
}
catch (Exception ex)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.ApplicationException;
}
return(responseOut);
}
}
public ResponseOut RegisterUser(RegisterUserViewModel user)
{
using (PortalEntities _context = new PortalEntities())
{
ResponseOut responseOut = new ResponseOut();
try
{
var check_user_name = _context.portal_user.Where(x => x.user_name.ToLower() == user.username.ToLower()).Any();
var check_email = _context.portal_user.AsEnumerable().Where(x => (user.email != null && user.email != "" && x.email != null) && x.email.ToLower() == user.email.ToLower()).Any();
var hash = Guid.NewGuid().ToString();
if (check_user_name)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.UsernameAlreadyExist;
return(responseOut);
}
if (check_email)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.EmailAlreadyExist;
return(responseOut);
}
portal_user _user = new portal_user();
_user.firstname = user.fullname;
_user.created_date = DateTime.Now;
_user.email = user.email;
_user.contact = user.contact;
_user.password = Utilities.MD5Hash(user.password);
_user.user_name = user.username;
_user.is_active = true;
_user.user_hash = hash;
_context.portal_user.Add(_user);
int return_code = _context.SaveChanges();
if (return_code == 1)
{
portal_user_role_mapping _role_map = new portal_user_role_mapping();
_role_map.fk_role_id = user.user_type;
_role_map.fk_user_id = _user.pk_user_id;
_context.portal_user_role_mapping.Add(_role_map);
_context.SaveChanges();
responseOut.status = ActionStatus.Success;
responseOut.message = ActionMessage.ProfileCreatedSuccess;
}
responseOut.trnId = _user.pk_user_id;
responseOut.hash = _user.user_hash;
responseOut.email = _user.email;
}
catch (Exception ex)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.ApplicationException;
}
return(responseOut);
}
}
public ResponseOut AddUpdateCandidateProfile(CandidateProfile model)
{
ResponseOut responseOut = new ResponseOut();
using (PortalEntities _context = new PortalEntities())
{
try
{
portal_user_candidate_info candidate_Info = new portal_user_candidate_info();
var is_Candidate_exist = _context.portal_user_candidate_info.Where(x => x.fk_user_id == model.fk_user_id).Any();
if (is_Candidate_exist)
{
candidate_Info = _context.portal_user_candidate_info.Where(x => x.fk_user_id == model.fk_user_id).FirstOrDefault();
}
portal_user portal_User = _context.portal_user.Where(x => x.pk_user_id == model.fk_user_id).FirstOrDefault();
candidate_Info.availability = model.availability;
candidate_Info.fk_user_id = model.fk_user_id;
candidate_Info.resume = model.resume;
candidate_Info.technologies = model.selected_technologies_name;
candidate_Info.preferred_city = model.city_listing;
candidate_Info.preferred_country = model.country_listing;
candidate_Info.preferred_state = model.state_listing;
candidate_Info.head_line = model.head_line;
if (!is_Candidate_exist)
{
_context.portal_user_candidate_info.Add(candidate_Info);
}
portal_User.fk_country_id = model.candidate_fk_country_id;
portal_User.fk_state_id = model.candidate_fk_state_id;
portal_User.fk_city_id = model.candidate_fk_city_id;
portal_User.profile_pic = model.profile_pic;
portal_User.firstname = model.first_name;
portal_User.lastname = model.last_name;
portal_User.email = model.email;
portal_User.contact = model.contact;
int result = _context.SaveChanges();
if (result > 0)
{
responseOut.status = ActionStatus.Success;
responseOut.message = ActionMessage.RequirementPost;
}
}
catch (EntityException ex)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.ApplicationException;
}
catch (Exception ex)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.ApplicationException;
}
}
return(responseOut);
}
public ResponseOut ResetUserPassword(PasswordResetViewModel model, int user_id)
{
ResponseOut _responseOut = new ResponseOut();
string old_encrypt_password = Utilities.MD5Hash(model.old_password);
string new_encrypt_password = Utilities.MD5Hash(model.new_password);
using (PortalEntities _context = new PortalEntities())
{
try
{
portal_user _user = _context.portal_user.Find(user_id);
if (_user.password == old_encrypt_password)
{
_user.password = new_encrypt_password;
int return_code = _context.SaveChanges();
if (return_code > 0)
{
_responseOut.status = ActionStatus.Success;
_responseOut.message = ActionMessage.PasswordUpdated;
}
}
else
{
_responseOut.status = ActionStatus.Fail;
_responseOut.message = ActionMessage.PasswordOldMismatch;
}
}
catch (Exception ex)
{
_responseOut.status = ActionStatus.Fail;
_responseOut.message = ActionMessage.ApplicationException;
}
return(_responseOut);
}
}
public ResponseOut AddUserProfile(UserViewModel model)
{
using (PortalEntities _context = new PortalEntities())
{
ResponseOut responseOut = new ResponseOut();
try
{
var check_user_name = _context.portal_user.AsEnumerable().Where(x => x.user_name.ToLower() == model.user_name.ToLower()).Any();
var check_email = _context.portal_user.AsEnumerable().Where(x => (model.email != null && model.email != "") && x.email.ToLower() == model.email.ToLower()).Any();
if (check_user_name)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.UsernameAlreadyExist;
return(responseOut);
}
if (check_email)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.EmailAlreadyExist;
return(responseOut);
}
portal_user _user = new portal_user();
_user.firstname = model.firstname;
_user.lastname = model.lastname;
_user.updated_date = DateTime.Now;
_user.user_hash = Guid.NewGuid().ToString();
_user.email = model.email;
_user.contact = model.contact;
_user.password = Utilities.MD5Hash(model.password);
_user.user_name = model.user_name;
if (model.fk_country_id != 0)
{
_user.fk_country_id = model.fk_country_id;
}
else
{
_user.fk_country_id = null;
}
_user.fk_city_id = model.fk_city_id;
_user.fk_state_id = model.fk_state_id;
_user.profile_pic = model.profile_pic;
_user.about_us = model.about_us;
_user.is_active = model.is_active;
_context.portal_user.Add(_user);
int return_code = _context.SaveChanges();
if (return_code == 1)
{
portal_user_role_mapping _role_map = new portal_user_role_mapping();
_role_map.fk_role_id = model.fk_user_type;
_role_map.fk_user_id = _user.pk_user_id;
_context.portal_user_role_mapping.Add(_role_map);
_context.SaveChanges();
responseOut.status = ActionStatus.Success;
responseOut.message = ActionMessage.ProfileCreatedSuccess;
}
responseOut.trnId = _user.pk_user_id;
responseOut.email = _user.email;
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
catch (Exception ex)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.ApplicationException;
}
return(responseOut);
}
}
