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); } }