public IEnumerable <CommonFlag> Binddetails(Formdataget Login) { List <CommonFlag> common = new List <CommonFlag>(); CommonFlag Flag = new CommonFlag(); int Isallowattempt = 5; List <Logindetails> dataList = new List <Logindetails>(); try { var Result = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <Logindetails>().Execute("@QueryType", "@UserName", "@Appid", "GetUser", Login.UserName, Login.APPID); 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())); if (strDbPassword.Trim() != Dbsecurity.Decrypt(Login.Password)) { if (Convert.ToBoolean(Logindata.Cast <Logindetails>().ToList().Select(x => x.IsAccountBlocked).First().ToString()) == true) { Flag.Flag = "0"; Flag.FlagValue = "Account is blocked please contact to admin!!"; common.Add(Flag); } else if (Convert.ToInt32(Logindata.Cast <Logindetails>().ToList().Select(x => x.IswrongAttempt).First().ToString()) >= Isallowattempt) { QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities(); var Updateaccountblockflag = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <Logindetails>().Execute("@QueryType", "@UserName", "@Appid", "@IsAccountblock", "GetUser", Login.UserName, Login.APPID, Convert.ToString(1)); Flag.Flag = "0"; Flag.FlagValue = "Account is blocked please contact to admin!!"; common.Add(Flag); } else if (Convert.ToInt32(Logindata.Cast <Logindetails>().ToList().Select(x => x.IswrongAttempt).First().ToString()) != Isallowattempt) { QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities(); var Updateleftattemptflag = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <Logindetails>().Execute("@QueryType", "@UserName", "@Appid", "@Iswrongattempt", "GetUser", Login.UserName, Login.APPID, Convert.ToString(1)); int attempt = Convert.ToInt32(Updateleftattemptflag.FirstOrDefault().Cast <Logindetails>().ToList().Select(x => x.IswrongAttempt).First().ToString()); if (attempt == Isallowattempt) { QuickCheck_AngularEntities dbcontext1 = new QuickCheck_AngularEntities(); var Updateaccountblockflag = dbcontext1.MultipleResults("[dbo].[sp_UserLogin]").With <Logindetails>().Execute("@QueryType", "@UserName", "@Appid", "@IsAccountblock", "GetUser", Login.UserName, Login.APPID, Convert.ToString(1)); Flag.Flag = "0"; Flag.FlagValue = "Account is blocked please contact to admin!!"; common.Add(Flag); } else { int leftAttempt = Isallowattempt - attempt; Flag.Flag = "0"; Flag.FlagValue = "Login Failed! Left attempt is '" + leftAttempt + "'!!"; common.Add(Flag); } } else if (Convert.ToInt32(Logindata.Cast <Logindetails>().ToList().Select(x => x.IswrongAttempt).First().ToString()) != Isallowattempt) { Flag.Flag = "0"; Flag.FlagValue = "Account is blocked please contact to admin!!"; common.Add(Flag); } } else { if (Convert.ToBoolean(Logindata.Cast <Logindetails>().ToList().Select(x => x.IsAccountBlocked).First().ToString()) == true) { Flag.Flag = "0"; Flag.FlagValue = "Account is blocked please contact to admin!!"; common.Add(Flag); } else { Random generator = new Random(); QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities(); var SaveLoginSessionTrxn = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <SaveLoginSessionTrxn>().Execute("@QueryType", "@UserId", "@TokenID", "@IPAddress", "@MacAddress", "@IsLogin", "@Iscorrectattempt", "@Appid", "SaveLoginSessionTrxn", Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString()), Convert.ToString(generator.Next(1, 1000000)), Convert.ToString(GetMacIP.GetIpAddress()), Convert.ToString(GetMacIP.GetMacAddress()), Convert.ToString(1), Convert.ToString(1), Login.APPID); 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 = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsRefrenceCheck).First().ToString())); Flag.IsOverPrintMandate = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsOverPrintMandate).First().ToString())); Flag.IsBulkMandate = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsBulkMandate).First().ToString())); Flag.IsMandate = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsMandate).First().ToString())); //NewCode Flag.IsMandateEdit = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsMandateEdit).First().ToString())); Flag.IsRefrenceEdit = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsRefrenceEdit).First().ToString())); Flag.IsEmandate = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsEmandate).First().ToString())); Flag.IsPhysical = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsPhysical).First().ToString())); Flag.IsZipShoreABPS = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsZipShoreABPS).First().ToString())); Flag.UserId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString())); Flag.ReferenceId = Dbsecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.ReferenceId).First().ToString()); Flag.UserName = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserName).First().ToString())); Flag.Password = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.Password).First().ToString())); Flag.UserCode = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserCode).First().ToString())); Flag.UserType = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString())); Flag.BranchId = Dbsecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.BranchId).First().ToString()); Flag.BranchName = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.BranchName).First().ToString())); Flag.IsDefaultPswdChange = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDefaultPswdChange).First().ToString())); Flag.LastLogin = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.LastLogin).First().ToString())); Flag.IsActive = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsActive).First().ToString())); Flag.IsDeleted = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDeleted).First().ToString())); Flag.CreatedBy = Dbsecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.CreatedBy).First().ToString()); Flag.CreatedOn = Dbsecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.CreatedOn).First().ToString()); Flag.AppId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.AppId).First().ToString())); #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 = "Login Failed!!"; common.Add(Flag); } } return(common); } catch (Exception ex) { throw ex; } }
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> Binddetails(Formdataget Login) { List <CommonFlag> common = new List <CommonFlag>(); CommonFlag Flag = new CommonFlag(); List <Logindetails> dataList = new List <Logindetails>(); try { var Result = dbcontext.MultipleResults("[dbo].[FAMS_Login]").With <Logindetails>().Execute("@QueryType", "@Emailid", "UserAccess", Login.UserName); foreach (var Logindata in Result) { dataList = Logindata.Cast <Logindetails>().ToList(); if (dataList.Count > 0) { if (Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.EmailId).First().ToString()) == "0") { Flag.Flag = "0"; Flag.FlagValue = "User is InActive!!"; common.Add(Flag); } else if (Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.EmailId).First().ToString()) == "-1") { Flag.Flag = "0"; Flag.FlagValue = "Invalid User!!"; common.Add(Flag); } else { string strDbPassword = Dbsecurity.Decrypt(Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.Password).First().ToString())); if (strDbPassword.Trim() != Dbsecurity.Decrypt(Login.Password)) { Flag.Flag = "0"; Flag.FlagValue = "Wrong Password!!"; common.Add(Flag); } else { #region Session creation if (Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString()) == "1") { Flag.UserId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString())); //Flag.EmailId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.EmailId).First().ToString())); Flag.EmailId = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.EmailId).First().ToString()); Flag.UserName = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserName).First().ToString())); Flag.WareHouseId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.WareHouseId).First().ToString())); //Flag.AccountNo = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.AccountNo).First().ToString())); Flag.AccountNo = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.AccountNo).First().ToString()); Flag.IsDefaultPswdChange = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDefaultPswdChange).First().ToString())); Flag.UserType = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString())); Flag.Flag = "1"; Flag.FlagValue = "ReportsDashboard"; } // Iace.User.User.SaveUserToSession(dataList); else if (Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString()) == "2") { Flag.UserId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString())); //Flag.EmailId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.EmailId).First().ToString())); Flag.EmailId = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.EmailId).First().ToString()); Flag.UserName = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserName).First().ToString())); Flag.WareHouseId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.WareHouseId).First().ToString())); //Flag.AccountNo = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.AccountNo).First().ToString())); Flag.AccountNo = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.AccountNo).First().ToString()); Flag.IsDefaultPswdChange = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDefaultPswdChange).First().ToString())); Flag.UserType = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString())); Flag.Flag = "1"; Flag.FlagValue = "ReportsDashboard"; } else if (Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString()) == "3") { Flag.UserId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString())); //Flag.EmailId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.EmailId).First().ToString())); Flag.EmailId = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.EmailId).First().ToString()); Flag.UserName = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserName).First().ToString())); Flag.WareHouseId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.WareHouseId).First().ToString())); //Flag.AccountNo = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.AccountNo).First().ToString())); Flag.AccountNo = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.AccountNo).First().ToString()); Flag.IsDefaultPswdChange = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDefaultPswdChange).First().ToString())); Flag.UserType = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString())); Flag.Flag = "1"; Flag.FlagValue = "Dashboard"; } else if (Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString()) == "4") { Flag.UserId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString())); Flag.EmailId = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.EmailId).First().ToString()); //Flag.EmailId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.EmailId).First().ToString())); Flag.UserName = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserName).First().ToString())); Flag.WareHouseId = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.WareHouseId).First().ToString())); //Flag.AccountNo = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast<Logindetails>().ToList().Select(x => x.AccountNo).First().ToString())); Flag.AccountNo = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.AccountNo).First().ToString()); Flag.IsDefaultPswdChange = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDefaultPswdChange).First().ToString())); Flag.UserType = Dbsecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString())); Flag.Flag = "1"; Flag.FlagValue = "Dashboard"; } else { Flag.Flag = "0"; Flag.FlagValue = "Incorrect"; } #endregion Flag.Password = Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.Password).First().ToString()); common.Add(Flag); } } } else { Flag.Flag = "0"; Flag.FlagValue = "Login Failed!!"; common.Add(Flag); } } return(common); } catch (Exception ex) { throw ex; } }