public static bool EditSmtpSetting(tb_smtp_settings smtp_setting)
{
using (var context = new JobAppDBEntities())
{
var smtpSetting = context.tb_smtp_settings.Find(smtp_setting.smtp_setting_id);
if (smtpSetting == null)
{
smtp_setting.last_modified_on = DateTime.UtcNow;
smtp_setting.active = true;
smtp_setting.status = true;
context.tb_smtp_settings.Add(smtp_setting);
}
else
{
smtpSetting.username = smtp_setting.username;
smtpSetting.port = smtp_setting.port;
smtpSetting.last_modified_by = smtp_setting.last_modified_by;
smtpSetting.last_modified_on = DateTime.UtcNow;
smtpSetting.password = smtp_setting.password;
smtpSetting.from_address = smtp_setting.from_address;
smtpSetting.address = smtp_setting.address;
}
context.SaveChanges();
ID = smtp_setting.smtp_setting_id;
return(true);
}
}
public static bool IsFirstLogin(string userName)
{
using (var ctx = new JobAppDBEntities())
{
var User = ctx.tb_registered_users.Where(o => o.username == userName || o.email_address == userName).FirstOrDefault();
if (User != null)
{
var Login = ctx.tb_login_details.Where(o => o.registered_user_id == User.registered_user_id).FirstOrDefault();
if (Login != null)
{
if (Login.last_login == null)
{
return(true);
}
}
else
{
return(true);
}
}
return(false);
}
}
/// <summary>
/// Gets the email template.
/// </summary>
/// <param name="type">The type.</param>
/// <returns></returns>
public static EmailTemplateModel GetEmailTemplate(string type)
{
using (var context = new JobAppDBEntities())
{
var content = context.tb_email_templates.FirstOrDefault(e => e.@for == type);
if (content == null)
{
return new EmailTemplateModel()
{
For = (ThinkTankJobApp.Models.EmailTemplateModel.EmailTemplateType)Enum.Parse(typeof(ThinkTankJobApp.Models.EmailTemplateModel.EmailTemplateType), type, true),
Content = "",
SmsContent = "",
Subject = ""
}
}
;
return(new EmailTemplateModel()
{
Subject = content.subject,
Content = content.content,
SmsContent = content.sms_content,
For = (ThinkTankJobApp.Models.EmailTemplateModel.EmailTemplateType)Enum.Parse(typeof(ThinkTankJobApp.Models.EmailTemplateModel.EmailTemplateType), content.@for, true),
Id = content.email_template_id
});
}
}
public static void AddException(tb_logs tb_log)
{
try
{
using (var context = new JobAppDBEntities())
{
if (tb_log.log_id == 0)
{
context.tb_logs.Add(tb_log);
}
else
{
var log = context.tb_logs.Find(tb_log.log_id);
if (log != null)
{
log.function_name = tb_log.function_name;
log.stack_trace = tb_log.stack_trace;
log.trace_data = string.IsNullOrEmpty(tb_log.trace_data) ? (tb_log.description ?? "") : tb_log.trace_data;
log.error_code = tb_log.error_code;
log.error_description = tb_log.error_description;
log.created_on = DateTime.UtcNow;
log.status = "F";
}
}
context.SaveChanges();
}
}
catch (Exception)
{
}
}
/// <summary>
/// Gets the SMTP for.
/// </summary>
/// <param name="smtpType">Type of the SMTP.</param>
/// <returns></returns>
public static SmtpSettingModel GetSmtpFor(int smtpType)
{
using (var context = new JobAppDBEntities())
{
var smtpSetting = context.tb_smtp_settings.FirstOrDefault(o => o.smtp_type == smtpType);
if (smtpSetting == null)
{
return new SmtpSettingModel()
{
Type = smtpType
}
}
;
return(new SmtpSettingModel()
{
UserName = smtpSetting.username,
UseAnonymous = smtpSetting.use_anonymous,
Type = smtpSetting.smtp_type,
SMTPSettingId = smtpSetting.smtp_setting_id,
Port = smtpSetting.port,
Password = smtpSetting.password,
IsActive = smtpSetting.active,
FromAddress = smtpSetting.from_address,
Address = smtpSetting.address
});
}
}
public static RegisteredUser GetUserDetailsFromToken(string regToken)
{
using (var context = new JobAppDBEntities())
{
try
{
var result = from a in context.tb_registered_users_registration_tokens
join b in context.tb_registered_users on a.registered_user_id equals b.registered_user_id
select new RegisteredUser()
{
token = a.registration_link,
RegistereduserId = b.registered_user_id,
Email_address = b.email_address,
Username = b.username,
First_name = b.first_name,
Last_name = b.last_name,
Middle_name = b.middle_name
};
return(result.Where(o => o.token == regToken).FirstOrDefault());
}
catch (Exception ex)
{
return(new RegisteredUser());
}
}
}
public static JobList GetAllJobs(long userId)
{
JobList list = new JobList();
using (var ctx = new JobAppDBEntities())
{
list.Jobs = ctx.JobDetails.Select(x => new JobDetailsModel()
{
Employee_id = x.employee_id,
Job_details_id = x.job_details_id,
Job_description = x.job_description,
Job_city = x.job_city,
Job_date = x.job_date,
Job_organization = x.job_organization,
Job_title = x.job_title,
Job_type = x.job_type,
Jo_date_modified = x.jo_date_modified,
Job_applied_date = x.job_applied_date,
Job_img = x.job_img,
Applied = ctx.tb_multiple_jobs.Where(y => y.registered_user_id == userId && y.jobs_details_id == x.job_details_id).Select(c => new MultipleJobsModel()
{
Multiple_jobs_id = c.multiple_jobs_id,
Applied_date = c.applied_date,
Registered_user_id = c.registered_user_id,
Jobs_details_id = c.jobs_details_id,
Employee_id = c.employee_id
}).FirstOrDefault()
}).ToList();
}
if (list.Jobs.Count > 0)
{
return(list);
}
return(new JobList());
}
public static string LoginCheckPoint(string user_name, string ip_address, string ip_country)
{
using (var ctx = new JobAppDBEntities())
{
var response = ctx.proc_LoginCheckPoint(user_name, ip_address, ip_country);
return(response.FirstOrDefault());
}
}
public static string LoginFailedCheck(string user_name)
{
using (var ctx = new JobAppDBEntities())
{
var response = ctx.proc_LoginFailed(user_name);
return(response.FirstOrDefault());
}
}
public static string ResetPassword(string password, string token, string used_on_ip)
{
using (var ctx = new JobAppDBEntities())
{
var res = ctx.proc_ResetPassword(token, password, used_on_ip).FirstOrDefault();
return(res);
}
}
public static string ActivateRegistration(string token, string used_on_ip)
{
using (var ctx = new JobAppDBEntities())
{
var res = ctx.proc_registrationConfirmation(token, used_on_ip).FirstOrDefault();
return(res);
}
}
public static tb_email_logs LogEmail(tb_email_logs data)
{
using (var context = new JobAppDBEntities())
{
data.log_entered_date = DateTime.UtcNow;
var log = context.tb_email_logs.Add(data);
context.SaveChanges();
return(log);
}
}
public static bool CheckUsername(string username)
{
using (var ctx = new JobAppDBEntities())
{
var tb = ctx.tb_registered_users.Where(x => x.username == username).FirstOrDefault();
if (tb == null)
{
return(false);
}
return(true);
}
}
public static string GetNameOfUser(string username)
{
using (var ctx = new JobAppDBEntities())
{
var res = ctx.tb_registered_users.Where(x => x.username == username || x.email_address == username).FirstOrDefault();
if (res != null)
{
return(res.first_name + " " + res.last_name);
}
return("");
}
}
public static long GetRegTokenUserId(string token)
{
using (var ctx = new JobAppDBEntities())
{
var tb = ctx.tb_registered_users_registration_tokens.Where(x => x.registration_link == token && x.used_on == null).FirstOrDefault();
if (tb != null)
{
return(tb.registered_user_id);
}
return(-1);
}
}
public static long GetResetTokenUserId(string token)
{
using (var ctx = new JobAppDBEntities())
{
var tb = ctx.tb_registered_users_resetpasswordtokens.Where(x => x.password_token == token).FirstOrDefault();
if (tb != null)
{
return(tb.registered_user_id);
}
return(-1);
}
}
/// <summary>
/// Updates the email log.
/// </summary>
/// <param name="data">The data.</param>
public static void UpdateEmailLog(tb_email_logs data)
{
using (var context = new JobAppDBEntities())
{
var log = context.tb_email_logs.Find(data.email_log_id);
if (log == null)
{
return;
}
log.error = data.error;
log.content = data.content;
context.SaveChanges();
}
}
public static long ApplicationStatus(tb_multiple_jobs jobs)
{
using (var ctx = new JobAppDBEntities())
{
var tb = ctx.tb_multiple_jobs.Where(x => x.registered_user_id == jobs.registered_user_id && x.multiple_jobs_id == jobs.multiple_jobs_id && x.jobs_details_id == jobs.jobs_details_id).FirstOrDefault();
if (tb == null)
{
jobs.applied_date = DateTime.Now;
ctx.tb_multiple_jobs.Add(jobs);
ctx.SaveChanges();
return(jobs.multiple_jobs_id);
}
}
return(-1);
}
public static bool GetUsersNameCheck(this string user)
{
using (var ctx = new JobAppDBEntities())
{
var User = ctx.tb_registered_users.FirstOrDefault(o => (o.username == user || o.email_address == user));
if (User == null)
{
return(false);
}
return(true);
}
}
public static long GetUseridfromUsername(string username)
{
using (var ctx = new JobAppDBEntities())
{
if (username != "" && username != null)
{
var tb = ctx.tb_registered_users.Where(x => x.username == username || x.email_address == username).FirstOrDefault();
if (tb != null)
{
return(tb.registered_user_id);
}
}
return(-1);
}
}
public static bool GetEmployer(string username)
{
using (var ctx = new JobAppDBEntities())
{
if (username != "" && username != null)
{
var tb = ctx.tb_registered_users.Where(x => x.username == username || x.email_address == username).FirstOrDefault().isEmployer;
if (tb.Value == true)
{
return(tb.Value);
}
}
return(false);
}
}
public static string ResetPasswordToken(long userid, string resettoken, string ipOrigin)
{
using (var context = new JobAppDBEntities())
{
try
{
var user_id = context.tb_registered_users.Where(p => p.registered_user_id == userid).Select(p => p.registered_user_id).FirstOrDefault();
var token = context.proc_UpdatePasswordRegToken("I", user_id, resettoken, ipOrigin, null);
return(token.FirstOrDefault());
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}
public static Response Login(LoginModel login)
{
using (var ctx = new JobAppDBEntities())
{
var response = new Response();
var Usercount = ctx.tb_registered_users.AsNoTracking().Count(c => ((c.username == login.Username || c.email_address == login.Username) && c.password == login.Password));
if (Usercount == 1)
{
var active = login_checkRegisteruser(login.Username, "active");
if (active == true)
{
var lockuser = login_checkRegisteruser(login.Username, "block");
if (lockuser == true)
{
Usercount = 0;
response.IsValid = false;
response.ErrorMessage = "|U|Your Account is Blocked. Please reset your account to Login.|";
return(response);
}
else
{
Usercount = 0;
response.IsValid = true;
response.ErrorMessage = "|S|Login Successfully.|";
return(response);
}
}
else
{
Usercount = 0;
response.IsValid = false;
response.ErrorMessage = "|A|Your Account is Inactive. Please activate you account to login.|";
return(response);
}
}
else
{
response.IsValid = false;
response.ErrorMessage = "|R|Your password is Invalid Password.|";
return(response);
}
}
}
public static long RegisterUser(tb_registered_users user)
{
using (var ctx = new JobAppDBEntities())
{
try
{
var tb = ctx.tb_registered_users.Where(x => x.username == user.username).FirstOrDefault();
if (tb == null)
{
user.registred_on = DateTime.Now;
user.is_active = false;
ctx.tb_registered_users.Add(user);
ctx.SaveChanges();
return(user.registered_user_id);
}
else
{
tb.first_name = user.first_name;
tb.middle_name = user.middle_name;
tb.last_name = user.last_name;
tb.title = user.title;
tb.mobile_number = user.mobile_number;
tb.mobile_country_code = user.mobile_country_code;
tb.username = user.username;
tb.password = user.password;
tb.Country = user.Country;
tb.Province = user.Province;
tb.City = user.City;
tb.dob = user.dob;
tb.registration_ip = user.registration_ip;
tb.gender = user.gender;
tb.Address = user.Address;
//tb.ServiceId = user.ServiceId;
tb.isEmployer = user.isEmployer;
tb.is_active = false;
ctx.SaveChanges();
return(tb.registered_user_id);
}
}
catch (Exception ex)
{
return(-1);
}
}
}
public static EmailTemplate SelectEmailContent(string EmailCode)
{
using (var content = new JobAppDBEntities())
{
var response = content.proc_GetEmailTemplate(EmailCode);
var data = response.FirstOrDefault();
if (data == null)
{
return(new EmailTemplate());
}
return(new EmailTemplate()
{
email_template_id = data.email_template_id,
subject = data.subject,
content = data.content
});
}
}
public static long AddLog(tb_logs log)
{
try
{
using (var context = new JobAppDBEntities())
{
log.transaction_ref_id = log.transaction_ref_id ?? DateTime.UtcNow.Ticks.ToString();
log.created_on = DateTime.UtcNow;
log.status = "S";
var header = context.tb_logs.Add(log);
context.SaveChanges();
return(header.log_id);
}
}
catch (Exception)
{
return(-1);
}
}
public static bool login_checkRegisteruser(string Username, string type)
{
using (var ctx = new JobAppDBEntities())
{
if (type == "active")
{
var active = ctx.tb_registered_users.Where(a => a.username == Username && a.email_address == Username).FirstOrDefault().is_active;
if (active == true)
{
return(true);
}
else
{
return(false);
}
}
else
{
var RegLockedUser = from a in ctx.tb_registered_users
join b in ctx.tb_login_details on a.registered_user_id equals b.registered_user_id
select new
{
a.registered_user_id,
a.username,
b.login_locked,
a.email_address
};
var lockedUser =
RegLockedUser.Where(
o =>
o.login_locked == true &&
(o.username == Username || o.email_address == Username)).FirstOrDefault();
if (lockedUser != null)
{
return(true);
}
else
{
return(false);
}
}
}
}
public static SmtpSettingModel GetSmtp()
{
using (var context = new JobAppDBEntities())
{
var smtps = context.tb_smtp_settings.Select(p => new SmtpSettingModel()
{
UserName = p.username,
UseAnonymous = p.use_anonymous,
Type = p.smtp_type,
SMTPSettingId = p.smtp_setting_id,
Port = p.port,
Password = p.password,
IsActive = p.active,
FromAddress = p.from_address,
Address = p.address
}).FirstOrDefault(p => p.SMTPSettingId == p.SMTPSettingId);
return(smtps);
}
}
public static bool RegisterToken(string token, string origin_ip, long userid)
{
using (var ctx = new JobAppDBEntities())
{
var uservalid = ctx.tb_registered_users.Where(x => x.registered_user_id == userid).FirstOrDefault();
if (uservalid != null)
{
var tb = new tb_registered_users_registration_tokens();
tb.expired_on = DateTime.UtcNow.AddHours(24);
tb.registration_link = token;
tb.origin_ip = origin_ip;
tb.created_on = DateTime.UtcNow;
tb.registered_user_id = userid;
ctx.tb_registered_users_registration_tokens.Add(tb);
ctx.SaveChanges();
return(true);
}
return(false);
}
}
public static RegisteredUser GetUserInfo(string UserName)
{
RegisteredUser user = new RegisteredUser();
using (var context = new JobAppDBEntities())
{
var content = context.tb_registered_users.Where(m => m.username == UserName || m.email_address == UserName).FirstOrDefault();
if (content != null)
{
user.Email_address = content.email_address;
user.Username = content.username;
user.RegistereduserId = content.registered_user_id;
user.First_name = content.first_name;
user.Last_name = content.last_name;
user.Middle_name = content.middle_name;
}
return(user);
}
}
