public IEnumerable <CommonFlag> Binddetails(string Username, string Password) { List <Logindetails> dataList = new List <Logindetails>(); try { var Result = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <Logindetails>().Execute("@QueryType", "@UserName", "GetUser", Username); foreach (var Logindata in Result) { dataList = Logindata.Cast <Logindetails>().ToList(); if (dataList.Count > 0) { string strDbPassword = DbSecurity.Decrypt(Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.Password).First().ToString()), Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.PasswordKey).First().ToString())); if (strDbPassword.Trim() != Password) { Flag.Flag = "0"; Flag.FlagValue = "Wrong Username or Password!!"; common.Add(Flag); } else { Random generator = new Random(); QuickCheckEmandate_AngularEntities dbcontext = new QuickCheckEmandate_AngularEntities(); var SaveLoginSessionTrxn = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <SaveLoginSessionTrxn>().Execute("@QueryType", "@UserId", "@TokenID", "@IPAddress", "@MacAddress", "@IsLogin", "SaveLoginSessionTrxn", Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString()), Convert.ToString(generator.Next(1, 1000000)), Convert.ToString(GetIpAddress()), Convert.ToString(GetMacAddress()), Convert.ToString(1)); foreach (var Existlogin in SaveLoginSessionTrxn) { // if (Existlogin.Cast<SaveLoginSessionTrxn>().ToList().Select(x => x.SessionActive).First().ToString() == "0") // { #region Session creation // Iace.User.User.SaveUserToSession(dataList); Flag.IsRefrenceCheck = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsRefrenceCheck).First().ToString()))).Replace("%", "_"); Flag.IsOverPrintMandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsOverPrintMandate).First().ToString()))).Replace("%", "_"); Flag.IsBulkMandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsBulkMandate).First().ToString()))).Replace("%", "_"); Flag.IsMandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsMandate).First().ToString()))).Replace("%", "_"); //NewCode Flag.IsMandateEdit = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsMandateEdit).First().ToString()))).Replace("%", "_"); Flag.IsRefrenceEdit = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsRefrenceEdit).First().ToString()))).Replace("%", "_"); Flag.IsEmandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsEmandate).First().ToString()))).Replace("%", "_"); Flag.IsPhysical = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsPhysical).First().ToString()))).Replace("%", "_"); Flag.IsZipShoreABPS = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsZipShoreABPS).First().ToString()))).Replace("%", "_"); Flag.UserId = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString()))).Replace("%", "_"); Flag.ReferenceId = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.ReferenceId).First().ToString())).Replace("%", "_"); Flag.UserName = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserName).First().ToString()))).Replace("%", "_"); Flag.Password = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.Password).First().ToString()))).Replace("%", "_"); Flag.PasswordKey = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.PasswordKey).First().ToString()))).Replace("%", "_"); Flag.UserCode = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserCode).First().ToString()))).Replace("%", "_"); Flag.UserType = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString()))).Replace("%", "_"); Flag.BranchId = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.BranchId).First().ToString())).Replace("%", "_"); Flag.BranchName = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.BranchName).First().ToString()))).Replace("%", "_"); Flag.IsDefaultPswdChange = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDefaultPswdChange).First().ToString()))).Replace("%", "_"); Flag.LastLogin = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.LastLogin).First().ToString()))).Replace("%", "_"); Flag.IsActive = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsActive).First().ToString()))).Replace("%", "_"); Flag.IsDeleted = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDeleted).First().ToString()))).Replace("%", "_"); Flag.CreatedBy = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.CreatedBy).First().ToString())).Replace("%", "_"); Flag.CreatedOn = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.CreatedOn).First().ToString())).Replace("%", "_"); #endregion Flag.Flag = "1"; common.Add(Flag); //} //else { // Flag.Flag = "0"; // Flag.FlagValue = "User already logged on. Either Try logging in after closing the current session or Try after some time!!"; // common.Add(Flag); //} } } } else { Flag.Flag = "0"; Flag.FlagValue = "Invalid User!!"; common.Add(Flag); } } return(common); } catch (Exception ex) { throw ex; } }
public IEnumerable <CommonFlag> SendMail(string Username) { try { List <Value> dataList = new List <Value>(); List <UserDetails> dataList1 = new List <UserDetails>(); var Result = dbcontext.MultipleResults("[dbo].[Sp_UserLogin]").With <Value>().With <UserDetails>().Execute("@QueryType", "@EmailId", "ChkEmail", Username); dataList = Result.FirstOrDefault().Cast <Value>().ToList(); dataList1 = Result.LastOrDefault().Cast <UserDetails>().ToList(); if (dataList.Cast <Value>().ToList().Select(x => x.value).First().ToString() == "1") { if (dataList1.Count > 0) { using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter hw = new HtmlTextWriter(sw)) { StringBuilder sb = new StringBuilder(); string WebAppUrl = ConfigurationManager.AppSettings["WebAppUrl"].ToString(); string SMTPHost = ConfigurationManager.AppSettings["Amazon_SMTPHost"].ToString(); string UserId = ConfigurationManager.AppSettings["Amazon_UserId"].ToString(); string MailPassword = ConfigurationManager.AppSettings["Amazon_MailPassword"].ToString(); string SMTPPort = ConfigurationManager.AppSettings["Amazon_SMTPPort"].ToString(); string SMTPEnableSsl = ConfigurationManager.AppSettings["Amazon_SMTPEnableSsl"].ToString(); string FromMailId = ConfigurationManager.AppSettings["Amazon_FromMailId"].ToString(); string Teamtext = ConfigurationManager.AppSettings["Team"].ToString(); sb.Append("Dear " + dataList1.Cast <UserDetails>().ToList().Select(x => x.UserName).First().ToString() + ",<br> <br>"); sb.Append("Please click on the below button to set a new Password . <br> <br>"); string User = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList1.Cast <UserDetails>().ToList().Select(x => x.UserId).First().ToString())).Replace("%", "_"); sb.Append("<a href=' " + WebAppUrl + "ChangePassword/" + User + "' target='_blank'>"); sb.Append("<input style='background-color: #3965a9;color: #fff;padding: 3px 10px 3px 10px;' type='button' value='Change Password' /></a> </div>"); SmtpClient smtpClient = new SmtpClient(); MailMessage mailmsg = new MailMessage(); MailAddress mailaddress = new MailAddress(FromMailId); mailmsg.To.Add(Username); mailmsg.From = mailaddress; mailmsg.Subject = "Recover Password"; mailmsg.IsBodyHtml = true; mailmsg.Body = sb.ToString(); smtpClient.Host = SMTPHost; smtpClient.Port = Convert.ToInt32(SMTPPort); smtpClient.EnableSsl = Convert.ToBoolean(SMTPEnableSsl); smtpClient.UseDefaultCredentials = true; smtpClient.Credentials = new System.Net.NetworkCredential(UserId, MailPassword); smtpClient.Send(mailmsg); QuickCheckEmandate_AngularEntities dbcontext = new QuickCheckEmandate_AngularEntities(); dbcontext.MultipleResults("[dbo].[Sp_SendEmail]").With <Value>().Execute("@QueryType", "@MandateId", "@EmailCount", "@SmsCount", "SendMail", Convert.ToString(0), "1", "0"); Flag.Flag = "1"; common.Add(Flag); } } } } } catch (Exception) { Flag.Flag = "1"; common.Add(Flag); } return(common); }