public DataTable GetEmailConfig(string ConfigName) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@ConfigName", ConfigName) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetEmailConfig, param)); }
public List <MenuModel> GetMenu(int menuId) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@MenuId", menuId) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.GetLayoutMenu, param).ToList <MenuModel>()); }
public DataTable DropdownList(string key) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@key", key) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_DropdownList, param)); }
public EmailSaveTemplateModel GetEmailTemplate(int templateId) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@templateId", templateId) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetEmailTemplateById, param).ToList <EmailSaveTemplateModel>().FirstOrDefault()); }
public List <ZodiacReportModel> GetZodiacReport(int zodiacReportId = 0) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@ZodiacReportId", zodiacReportId) }; return(DataExecutor.ExecuteDataTable(Utilities.UtilityConstant.Procedures.Mst_GetZodiacReport, param).ToList <ZodiacReportModel>()); }
public DataTable GetUser(int userId = 0) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@UserId", userId) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetUsers, param)); }
public List <UserQueryModel> GetUserQuery(string status = null) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@status", status) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetUserQuery, param).ToList <UserQueryModel>()); }
public List <AstrologerModel> GetAstrologers(int astrologerId = 0) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@astrologerId", astrologerId) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetAstrologers, param).ToList <AstrologerModel>()); }
public List <RefLookupModel> GetReferenceLookup(string key) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@key", key) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetReferenceLookup, param).ToList <RefLookupModel>()); }
public List <DowntimeModel> GetAppDowntime(int DowntimeId = 0) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@id", DowntimeId) }; return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetAppDowntime, param).ToList <DowntimeModel>()); }
public DowntimeModel HasAppDowntime() { try { return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_HasAppDowntime).ToList <DowntimeModel>().FirstOrDefault()); } catch (Exception ex) { return(new DowntimeModel()); } }
public List <PageMenuModel> GetLayoutMenu() { List <PageMenuModel> pageMenuTemp = DataExecutor.ExecuteDataTable("GetLayoutMenu").ToList <PageMenuModel>(); List <PageMenuModel> pageMenus = new List <PageMenuModel>(); pageMenus.AddRange(pageMenuTemp.Where(x => x.ParentMenu.Equals("Parent")).OrderBy(x => x.DisplayOrder).ToList()); foreach (var parent in pageMenus) { parent.ChildMenu = new List <PageMenuModel>(); parent.ChildMenu.AddRange(pageMenuTemp.Where(x => x.ParentMenuName == parent.MenuName).OrderBy(x => x.DisplayOrder).ToList()); } return(pageMenus); }
public List <string> GetEmailsByGroup(string groupName) { List <string> emails = null; List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@groupname", groupName) }; var dtTemplate = DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetEmailGroup, param); if (dtTemplate != null && dtTemplate.Rows.Count > 0 && dtTemplate.Columns.Contains("Emails")) { emails = dtTemplate.Rows[0]["Emails"].ToString().Split(",").Select(x => x.Trim()).ToList(); } return(emails); }
public EmailTemplateModel GetEmailTemplate(EmailTemplate emailTemplate) { EmailTemplateModel emailTemplateModel = new EmailTemplateModel(); List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@mappingName", emailTemplate.ToString()) }; var dtTemplate = DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetEmailTemplateByMapping, param); if (dtTemplate != null && dtTemplate.Rows.Count > 0 && dtTemplate.Columns.Contains("EmailTemplate")) { emailTemplateModel.Template = dtTemplate.Rows[0]["EmailTemplate"].ToString(); emailTemplateModel.Subject = dtTemplate.Rows[0]["Subject"].ToString(); } return(emailTemplateModel); }
public string SetNewPassword(string code, string password) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@code", code), new KeyValuePair <string, object>("@newPassword", EncryptManager.GetHashString(password ?? string.Empty)) }; var result = DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Usp_SetNewPassword, param); if (result != null && result.Rows.Count > 0) { if (result.Columns.Count > 1) { NewPasswordMail(new List <string>() { result.Rows[0]["EmailId"].ToString() }, result.Rows[0]["Name"].ToString(), result.Rows[0]["AppName"].ToString()); } return(result.Rows[0]["Msg"].ToString()); } return(UtilityConstant.UserResponseStatus.Error); }
public LoginTokenDataModel CheckUserCredentials(CredentialModel credentialModel) { try { LoginTokenDataModel loginTokenDataModel = new LoginTokenDataModel(); if (credentialModel != null) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@username", credentialModel.UserName), new KeyValuePair <string, object>("@isExternal", credentialModel.isExternal), new KeyValuePair <string, object>("@password", EncryptManager.GetHashString(credentialModel.Password ?? string.Empty)) }; var data = DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Usp_CheckUserCredential, param); if (data != null && data.Columns.Count > 1) { LoginTokenModel loginTokenModel = new LoginTokenModel() { ExpireTime = DateTime.Now.AddMinutes(30), Message = string.Empty, SecureId = Guid.NewGuid().ToString(), UserData = data }; loginTokenDataModel.UserData = data; loginTokenDataModel.Message = "ValidUser"; loginTokenDataModel.Token = EncryptManager.Encrypt(JsonConvert.SerializeObject(loginTokenModel), AppSetting.GetAppSettingsData(UtilityConstant.AppConfigConstant.AppVariable, UtilityConstant.AppConfigConstant.SaltKey, string.Empty)); } else { loginTokenDataModel.Message = data.Rows[0][0].ToString(); } } return(loginTokenDataModel); } catch (Exception ex) { throw; } }
public EmailServiceDetails() { int _conTimeOut = 300; DataExecutor.ConnectionString = Utilities.AppSetting.GetConnectionString(string.Empty, ref _conTimeOut); DataExecutor.ConnectionTimeout = _conTimeOut; var emailConfig = DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetEmailConfig); if (emailConfig != null && emailConfig.Rows.Count > 0) { EmailConfiguration emailConfiguration = new EmailConfiguration(); List <EmailConfigList> emailConfigList = emailConfig.ToList <EmailConfigList>(); var smtpList = emailConfigList.Where(x => x.ConfigName.ToLowerInvariant().Contains("smtp") && x.DefaultConfig).FirstOrDefault(); var popList = emailConfigList.Where(x => x.ConfigName.ToLowerInvariant().Contains("pop") && x.DefaultConfig).FirstOrDefault(); if (smtpList != null) { emailConfiguration.SmtpPassword = smtpList.Password; emailConfiguration.SmtpPort = smtpList.Port; emailConfiguration.SmtpServer = smtpList.ServerName; emailConfiguration.SmtpUsername = smtpList.Username; } if (popList != null) { emailConfiguration.PopPassword = popList.Password; emailConfiguration.PopPort = popList.Port; emailConfiguration.PopServer = popList.ServerName; emailConfiguration.PopUsername = popList.Username; } emailService = new EmailService(emailConfiguration); } else { throw new Exception("Invalid Email configuration"); } }
public string PasswordResetCode(string username, string appName, string appUrl) { string code = EncryptManager.GetHashString($"{username}-{DateTime.Now.ToShortDateString()}"); string link = $"{appUrl}common/signin/newpassword?txn={code}"; List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >() { new KeyValuePair <string, object>("@username", username), new KeyValuePair <string, object>("@code", code) }; var result = DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Usp_AddResetCode, param); if (result != null && result.Rows.Count > 0) { if (result.Columns.Count > 1) { PasswordResetLinkMail(new List <string>() { result.Rows[0]["EmailId"].ToString() }, result.Rows[0]["Name"].ToString(), link, result.Rows[0]["ResetCodeExpire"].ToString(), appName); } return(result.Rows[0]["Msg"].ToString()); } return(UtilityConstant.UserResponseStatus.Error); }
public DataTable GetDashboardCount() { return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetDashboardCount)); }
public List <FeedbackModel> GetFeedback() { return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetFeedback).ToList <FeedbackModel>()); }
public ContactDetailModel GetContactDetails() { return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetContactDetails).ToList <ContactDetailModel>().FirstOrDefault()); }
public List <ZodiacModel> GetZodiacList() { return(DataExecutor.ExecuteDataTable(Utilities.UtilityConstant.Procedures.Mst_GetZodiac).ToList <ZodiacModel>()); }
public DataTable GetAppSetting() { return(DataExecutor.ExecuteDataTable(UtilityConstant.Procedures.Mst_GetAppSetting)); }