public JsonResult getColumnDetails(int UserId, string SystemChapterName) { var result = new Teckraft.Data.ListQueryResult <UserWiseColumnName>(); var list = new List <UserWiseColumnName>(); using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == SystemChapterName); if (chap != null) { var lq = dbcontext.UserWiseColumnNames.FirstOrDefault(it => it.ChapterId == chap.Id && it.UserId == UserId); if (lq != null) { // lq.ChapterId = chap.Id; list.Add(mapper.Map(lq)); } } // var lq = dbcontext.(SystemChapterName, RoleName, Email); //foreach (var t in lq) //{ // list.Add(new HodNames // { // SAPDivisionName = t.SAPDivisionName, // SAPDivisionCode = t.SAPDivisionCode, // HodEmail = t.HodEmail, // }); //} } result.Items = list; // return Json(result, JsonRequestBehavior.AllowGet); return(Json(result, JsonRequestBehavior.AllowGet)); }
public DbActionResult <IssueManagementAnchorComment> Post(IssueManagementAnchorComment items) { var result = new DbActionResult <IssueManagementAnchorComment>(); bool EFlag = false; string EmailTo = ""; try { var data = items; string[] emailRegex = { "-", "<", ">", ";", "'" }; for (var i = 0; i < emailRegex.Length; i++) { if (data.ID_Comments != null) { data.ID_Comments = data.ID_Comments.Replace(emailRegex[i], " "); } } using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.id_System_Name && it.EmailFlag == true); if (chap != null) { data.id_System_Name = chap.ChapterNameFromSystem; EFlag = chap.EmailFlag.Value; EmailTo = chap.EmailTo; } } data.RCB = _userservice.GetCurrentUser(); data = IssueService.Add(data); // if (EFlag == true) // { // if (data.EmailFlag == true && EmailTo != null) //{ //var tmplt1 = templateService.GetTemplateforComments(data); // emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "", ""); // emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "*****@*****.**", ""); // } //} result.Success = true; result.Message = "Comments added successfully "; } catch (Exception ex) { result.Success = false; result.Message = "Unable to Save Record!"; result.Exception = ex; } return(result); }
public static Core.Domian.Settings.User GetBasisUser() { using ( var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { var rec = dbcontext.UserDetails.FirstOrDefault(it => it.UserId == 10723); return(new Core.Domian.Settings.User() { Id = rec.UserId, Title = rec.Title, Email = rec.Email, UserName = rec.UserName }); } }
public ListQueryResult <webpages_Roles> Get(string q) { ListQuery <webpages_Roles> query = new ListQuery <webpages_Roles>(); if (!string.IsNullOrEmpty(q)) { JavaScriptSerializer js = new JavaScriptSerializer(); query = js.Deserialize <ListQuery <webpages_Roles> >(q); } var list = new List <webpages_Roles>(); using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { if (query.Parameters != null) { if (query.Parameters.Count > 0) { foreach (var item in query.Parameters) { if (item.Name == "ExistingRole") { var role = item.Value; var dbquery = dbcontext.webpages_Roles.Where(it => it.RoleId > 0 && it.RoleName != role); foreach (var dbitem in dbquery.ToList()) { list.Add(mapper.Map(dbitem)); } } else { var dbquery = dbcontext.webpages_Roles.Where(it => it.RoleId > 0); foreach (var dbitem in dbquery.ToList()) { list.Add(mapper.Map(dbitem)); } } } } } } return(new ListQueryResult <webpages_Roles>() { Items = list }); }
public ListQueryResult <StatusMaster> Get(string q) { var result = new ListQueryResult <Teckraft.Core.Domian.Settings.StatusMaster>(); using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { var dbquery = dbcontext.StatusMasters.Where(it => it.Id > 0); foreach (var item in dbquery.OrderByDescending(it => it.StatusDesc)) { if (result.Items == null) { result.Items = new List <Teckraft.Core.Domian.Settings.StatusMaster>(); } result.Items.Add(_StatusMapper.Map(item)); } } return(result); }
public JsonResult getHodwiseCount(string SystemChapName, string RoleName, string Email) { var result = new Teckraft.Data.ListQueryResult <HODWiseCount>(); var list = new List <HODWiseCount>(); using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { var lq = dbcontext.spHodCount(SystemChapName, RoleName, Email).AsQueryable(); foreach (var t in lq) { list.Add(new HODWiseCount { SAPDivisionName = t.SAPDivisionName, count = t.count, }); } } result.Items = list; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult LogOff() { var test = User.Identity.Name; Teckraft.Data.Sql.InitiativeHubFinalEntities DbContext = new Teckraft.Data.Sql.InitiativeHubFinalEntities(); var userprofile = DbContext.UserProfiles.FirstOrDefault(it => it.UserName.ToLower() == test.ToLower()); var curSession = DbContext.CurrentUserSessions.FirstOrDefault(it => it.UserId == userprofile.UserId); if (curSession != null) { DbContext.CurrentUserSessions.Remove(curSession); } DbContext.SaveChanges(); Response.Cookies["ASP.NET_SessionId"].Value = string.Empty; Response.Cookies["ASP.NET_SessionId"].Expires = DateTime.Now.AddDays(-2); //Delete the cookie //return Redirect("http://localhost:8052/account/LogOff?wa=wsignout1.0"); WebSecurity.Logout(); Session.Abandon(); return(RedirectToAction("Login", "Account")); }
public ListQueryResult<Core.Domian.Settings.IssueManagementCommentLog> GetByQuery(ListQuery<Core.Domian.Settings.IssueManagementCommentLog> query) { var result = new ListQueryResult<Teckraft.Core.Domian.Settings.IssueManagementCommentLog>(); var list = new List<Teckraft.Core.Domian.Settings.IssueManagementCommentLog>(); using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { var linqquery = dbcontext.IssueManagementCommentLogs.Where(it => it.Id > 0); if (query.Parameters.Count > 0) { foreach (var item in query.Parameters) { if (item.Name == "RequestNo") { var val = item.Value; linqquery = linqquery.Where(k => k.ID_Request == val); } else if (item.Name == "ChapterName") { var val = item.Value; linqquery = linqquery.Where(j => j.id_System_Name == val); } else if (item.Name == "PendingWithEmail") { var val = (item.Value); linqquery = linqquery.Where(it => (it.ID_Pending_With_Email == val)); } } linqquery = linqquery.OrderByDescending(it => it.RCT); foreach (var dbitem in linqquery) { list.Add(mappingProvider.Map(dbitem)); } } } result.Items = list; return result; }
public JsonResult getHodName(string SystemChapterName, string RoleName, string Email) { var result = new Teckraft.Data.ListQueryResult <HodNames>(); var list = new List <HodNames>(); using (Teckraft.Data.Sql.InitiativeHubFinalEntities dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { //var lq = dbcontext.spHodName(SystemChapterName); var lq = dbcontext.spHodName(SystemChapterName, RoleName, Email); foreach (var t in lq) { list.Add(new HodNames { SAPDivisionName = t.SAPDivisionName, SAPDivisionCode = t.SAPDivisionCode, HodEmail = t.HodEmail, }); } } result.Items = list; return(Json(result, JsonRequestBehavior.AllowGet)); }
public DbActionResult <UserWiseColumnName> Post(UserWiseColumnName items) { var result = new DbActionResult <UserWiseColumnName>(); try { var data = items; using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { // foreach (var i in data) { var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.chapterName); if (chap != null) { data.ChapterId = chap.Id; } var existingList = dbcontext.UserWiseColumnNames.FirstOrDefault(it => it.UserId == data.UserId && it.ChapterId == data.ChapterId); if (existingList != null) { //dbcontext.UserWiseColumnNames.Remove(existingList); existingList.ChapterId = data.ChapterId; existingList.UserId = data.UserId; existingList.chapternamedisplay = data.chapternamedisplay; existingList.chapterOwner = data.chapterOwner; existingList.ID_Category = data.ID_Category; existingList.id_comments = data.id_comments; existingList.id_data_load_date = data.id_data_load_date; existingList.id_dept = data.id_dept; existingList.ID_Issue_Detail1 = data.ID_Issue_Detail1; existingList.id_location = data.id_location; existingList.ID_Logged_Date = data.ID_Logged_Date; existingList.id_pending_with_email = data.id_pending_with_email; existingList.id_pending_with_name = data.id_pending_with_name; existingList.id_reported_by_email = data.id_reported_by_email; existingList.id_reported_by_name = data.id_reported_by_name; existingList.id_request = data.id_request; existingList.id_status = data.id_status; existingList.ID_Target_Date = data.ID_Target_Date; existingList.id_tat_status = data.id_tat_status; existingList.pendingSince = data.pendingSince; existingList.title = data.title; existingList.UserId = _userservice.GetCurrentUser().Id; existingList.RUB = _userservice.GetCurrentUser().Id; existingList.RUT = DateTime.Now; dbcontext.SaveChanges(); } else { dbcontext.UserWiseColumnNames.Add(new Teckraft.Data.Sql.UserWiseColumnName() { ChapterId = data.ChapterId, UserId = _userservice.GetCurrentUser().Id, chapternamedisplay = data.chapternamedisplay, chapterOwner = data.chapterOwner, ID_Category = data.ID_Category, id_comments = data.id_comments, id_data_load_date = data.id_data_load_date, id_dept = data.id_dept, ID_Issue_Detail1 = data.ID_Issue_Detail1, id_location = data.id_location, ID_Logged_Date = data.ID_Logged_Date, id_pending_with_email = data.id_pending_with_email, id_pending_with_name = data.id_pending_with_name, id_reported_by_email = data.id_reported_by_email, id_reported_by_name = data.id_reported_by_name, id_request = data.id_request, id_status = data.id_status, ID_Target_Date = data.ID_Target_Date, id_tat_status = data.id_tat_status, pendingSince = data.pendingSince, title = data.title, RCT = DateTime.Now, RCB = _userservice.GetCurrentUser().Id, }); } dbcontext.SaveChanges(); result.Success = true; result.Message = "Comments added successfully "; } } catch (Exception ex) { result.Success = false; result.Message = "Unable to Save Record!"; result.Exception = ex; } return(result); }
public DbActionResult <IssueManagementCommentLog> Post(IssueManagementCommentLog items) { var result = new DbActionResult <IssueManagementCommentLog>(); bool EFlag = false; string EmailTo = ""; string AncEmail = ""; string EmailCC = ""; string AnchorName = ""; try { var data = items; string[] emailRegex = { "-", "<", ">", ";", "'" }; for (var i = 0; i < emailRegex.Length; i++) { if (data.ID_Comments != null) { data.ID_Comments = data.ID_Comments.Replace(emailRegex[i], " "); } } var csc = new CSC(); using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { //var chap = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.id_System_Name && it.EmailFlag == true); //if (chap != null) //{ // data.id_System_Name = chap.ChapterNameFromSystem; // EFlag = chap.EmailFlag.Value; // EmailTo = chap.EmailTo; //} var chap1 = dbcontext.ChapterMasters.FirstOrDefault(it => it.ChapterNameFromSystem == data.id_System_Name); if (chap1 != null) { if (chap1.ChapterNameFromSystem == "Dealer Feedback" || chap1.ChapterNameFromSystem == "WSS Service Cell" || chap1.ChapterNameFromSystem == "MyPidilite" || chap1.ChapterNameFromSystem == "Customer Service Cell") { var em = dbcontext.ChapterMasters.FirstOrDefault(o => o.ChapterNameFromSystem == data.id_System_Name); EmailCC = em.EmailCC; AncEmail = em.EmailTo; } else { string AncData = dbcontext.ChapterOwnerMappings.FirstOrDefault(it => it.ChapterId == chap1.Id).ChapterOwner.ToString(); AncEmail = dbcontext.UserDetails.FirstOrDefault(p => p.UserName == AncData).Email.ToString(); } //for getting Anchor Name var q = (from pd in dbcontext.ChapterOwnerMappings join od in dbcontext.UserDetails on pd.ChapterOwner equals od.UserName where pd.ChapterId == chap1.Id select new { od.Title, }).FirstOrDefault(); if (q != null) { AnchorName = q.Title; } } if (items.id_System_Name == "Customer Service Cell") { var cs = dbcontext.GetCSCDataBYRequestNo(items.ID_Request).FirstOrDefault(); csc.ContactEmail = cs.ContactEmail; csc.ContactNo = cs.contactNo; } } data.RCB = _userservice.GetCurrentUser(); data = IssueService.Add(data); //if (EFlag == true) { // if (data.EmailFlag == true && EmailTo != null) { // var tmplt1 = templateService.GetTemplateforComments(data); // // emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "", ""); // emailService.SendEmail(tmplt1, "*****@*****.**", EmailTo, "*****@*****.**", ""); // } //} var tmplt1 = templateService.GetTemplateforAnchor(data, AnchorName, csc); //emailService.SendEmail(tmplt1, "[email protected] ", "*****@*****.**","", ""); if (tmplt1.Subject != "") { //emailService.SendEmail(tmplt1, "[email protected] ", "*****@*****.**", "", ""); emailService.SendEmail(tmplt1, "[email protected] ", AncEmail, EmailCC, ""); } result.Success = true; result.Message = "Comments added successfully"; } catch (Exception ex) { result.Success = false; result.Message = "Unable to Save Record!"; result.Exception = ex; } return(result); }
public JsonResult getChapterDetails(string ResponsibleEmail, string Owner) { var result = new Teckraft.Data.ListQueryResult <ChapterMaster>(); var list = new List <ChapterMaster>(); string constrSSO = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; string newUserName = ""; using (SqlConnection con1 = new SqlConnection(constrSSO)) { using (SqlCommand cmd1 = new SqlCommand()) { // SqlCommand cmd1 = new SqlCommand("spGetChaptersforResponsiblePerson", con1); cmd1.CommandText = "spGetChaptersforResponsiblePerson"; cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@ResponsibleEmail", ResponsibleEmail); cmd1.Parameters.AddWithValue("@Owner", Owner); con1.Open(); cmd1.Connection = con1; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd1; da.Fill(dt); string TempChapterName = ""; int countChapter = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { TempChapterName = row["ChapterNameFromSystem"].ToString(); using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { if (TempChapterName == "MyPidilite" || TempChapterName == "WSS Service Cell") { var getChapterName = dbcontext.spGetChaptersNameforResponsiblePerson(ResponsibleEmail, Owner, TempChapterName).ToList(); countChapter = getChapterName.Count(); } } // DateTime dt1 = DateTime.ParseExact((row["id_data_load_date"].ToString()), "yyyy-MM-dd", null); if ((TempChapterName != "MyPidilite" && TempChapterName != "WSS Service Cell") || countChapter > 0) { list.Add(new ChapterMaster { ChapterNameDisplay = row["chapternamedisplay"].ToString(), ChapterOwner = row["ChapterOwner"].ToString(), RunDate = row["id_data_load_date"].ToString(), ChapterNameFromSystem = row["ChapterNameFromSystem"].ToString(), EditFlag = bool.Parse(row["editflag"].ToString()), IssueCount = int.Parse(row["issueCount"].ToString()), }); } } } else { using (var dbcontext = new Teckraft.Data.Sql.InitiativeHubFinalEntities()) { var getChapterName = dbcontext.spGetChaptersNameforResponsiblePerson(ResponsibleEmail, Owner, TempChapterName).ToList(); foreach (var i in getChapterName) { list.Add(new ChapterMaster { ChapterNameDisplay = i.chapternamedisplay.ToString(), ChapterOwner = i.ChapterOwner.ToString(), RunDate = i.id_data_load_date.ToString(), ChapterNameFromSystem = i.chapternamefromsystem.ToString(), EditFlag = bool.Parse(i.editflag.ToString()), IssueCount = int.Parse(i.issueCount.ToString()), }); } } } con1.Close(); } } result.Items = list; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GenerateOTP(string UserName) { //if( string[] emailRegex = { "-", "<", ">", ";", "'" }; for (var i = 0; i < emailRegex.Length; i++) { if (UserName != null) { UserName = UserName.Replace(emailRegex[i], " "); } } Teckraft.Web.Models.DbActionResult <string> result = new Teckraft.Web.Models.DbActionResult <string>(); Teckraft.Data.Sql.InitiativeHubFinalEntities DbContext = new Teckraft.Data.Sql.InitiativeHubFinalEntities(); var UserExist = DbContext.UserProfiles.FirstOrDefault(it => it.UserName.ToLower() == UserName.ToLower()); if (UserExist != null && WebSecurity.IsConfirmed(UserName)) { var User = DbContext.UserDetails.FirstOrDefault(it => it.UserName.ToLower() == UserName.ToLower()); if (string.IsNullOrEmpty(User.MobileNo) && string.IsNullOrEmpty(User.Email)) { result.Message = "User's Email address and Mobile number are not updated"; result.Success = false; } else { TestOTPWebService.WebServiceSoapClient pilcrsOTP = new TestOTPWebService.WebServiceSoapClient(); var res = false; if (string.IsNullOrEmpty(User.MobileNo)) { User.MobileNo = "2222222222"; } if (!(string.IsNullOrEmpty(User.MobileNo))) { try { res = pilcrsOTP.Password(Encryptdata(UserName), Encryptdata(User.MobileNo), Encryptdata("SSOEMP"), Encryptdata("SSOEMP"), Encryptdata("0")); result.Message = "An OTP message has been sent to your number or email"; result.Success = true; } catch (Exception ex) { result.Message = "Error sending OTP please try later"; } } if (!(string.IsNullOrEmpty(User.Email))) { try { //Models.OTP.OTPEntities dbcontext = new Models.OTP.OTPEntities(); //var otp = dbcontext.OTPs.OrderByDescending(it => it.Time).FirstOrDefault(it => it.UserName == User.UserName && it.ApplnCode == "ASF"); //if (otp != null) //{ // System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient(); // client.Send("*****@*****.**", User.Email, "OTP for Pidilite ASF System", "Dear user\n Your OTP for Pidilite ASF System is " + otp.Password + "\nRegards\nASF System Team"); // result.Message = "An OTP message has been sent to your number or email"; //} } catch (Exception ex) { result.Message = "Error sending OTP please try later"; } } } } else { result.Message = "Invalid Username"; result.Success = false; } return(Json(result)); }
public ActionResult Login(LoginModel model, string returnUrl) { ViewBag.multipleLogin = "******"; if (Settings.EnableOTP) { TestOTPWebService.WebServiceSoapClient objOTP = new TestOTPWebService.WebServiceSoapClient(); string uname = model.UserName; string pass = model.Password; string[] emailRegex = { "-", "<", ">", ";", "'" }; for (var i = 0; i < emailRegex.Length; i++) { if (model.UserName != null) { model.UserName = model.UserName.Replace(emailRegex[i], " "); } if (model.Password != null) { model.Password = model.Password.Replace(emailRegex[i], " "); } } string appName = "SSOEMP"; string appCode = "SSOEMP"; var result = objOTP.Login(Encryptdata(uname), Encryptdata(pass), Encryptdata(appName), Encryptdata(appCode)); if (WebSecurity.IsAccountLockedOut(model.UserName, 5, 100)) { ModelState.AddModelError("", "Account is locked due to multiple failed login attempts."); } else if (WebSecurity.IsConfirmed(model.UserName) == false) { ModelState.AddModelError("", "Account disabled"); } else if (ModelState.IsValid && result) { FormsAuthentication.SetAuthCookie(model.UserName, false); var usr = WebSecurity.GetUserId(model.UserName); Teckraft.Data.Sql.InitiativeHubFinalEntities DbContext = new Teckraft.Data.Sql.InitiativeHubFinalEntities(); var dt = DateTime.Now.AddMinutes(-22); foreach (var item in DbContext.CurrentUserSessions.Where(it => it.UserId == usr && it.RCT < dt)) { DbContext.CurrentUserSessions.Remove(item); } DbContext.SaveChanges(); var curSession = DbContext.CurrentUserSessions.FirstOrDefault(it => it.UserId == usr); if (curSession != null && !model.ForcefullLogout) { ViewBag.multipleLogin = "******"; ModelState.AddModelError("", "Mutiple login not allowed"); WebSecurity.Logout(); } else { if (curSession != null) { System.Web.HttpContext.Current.Application[curSession.SessionId] = null; DbContext.CurrentUserSessions.Remove(curSession); } DbContext.CurrentUserSessions.Add(new Teckraft.Data.Sql.CurrentUserSession() { UserId = usr, RCT = DateTime.Now, SessionId = Session.SessionID }); DbContext.SaveChanges(); Session["sessionid"] = Session.SessionID; System.Web.HttpContext.Current.Application[Session.SessionID.ToString()] = Session.SessionID; return(RedirectToLocal(returnUrl)); } } else { if (WebSecurity.UserExists(model.UserName) && !WebSecurity.IsConfirmed(model.UserName)) { ModelState.AddModelError("", "Your account has been blocked. Please contact SSO admin."); } else { ModelState.AddModelError("", "The user name or password provided is incorrect."); } } } else { string[] emailRegex = { "-", "<", ">", ";", "'" }; for (var i = 0; i < emailRegex.Length; i++) { if (model.UserName != null) { model.UserName = model.UserName.Replace(emailRegex[i], " "); } if (model.Password != null) { model.Password = model.Password.Replace(emailRegex[i], " "); } } if (WebSecurity.IsAccountLockedOut(model.UserName, 5, 100)) { ModelState.AddModelError("", "Account is locked due to multiple failed login attempts."); } else if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe)) { if (String.IsNullOrEmpty(returnUrl)) { // returnUrl = "/"; } FormsAuthentication.SetAuthCookie(model.UserName, false); var usr = WebSecurity.GetUserId(model.UserName); Teckraft.Data.Sql.InitiativeHubFinalEntities DbContext = new Teckraft.Data.Sql.InitiativeHubFinalEntities(); var dt = DateTime.Now.AddMinutes(-22); foreach (var item in DbContext.CurrentUserSessions.Where(it => it.UserId == usr && it.RCT < dt)) { DbContext.CurrentUserSessions.Remove(item); } DbContext.SaveChanges(); var curSession = DbContext.CurrentUserSessions.FirstOrDefault(it => it.UserId == usr); if (curSession != null && !model.ForcefullLogout) { ModelState.AddModelError("", "Mutiple login not allowed"); ViewBag.multipleLogin = "******"; WebSecurity.Logout(); } else { if (curSession != null) { System.Web.HttpContext.Current.Application[curSession.SessionId] = null; DbContext.CurrentUserSessions.Remove(curSession); } DbContext.CurrentUserSessions.Add(new Teckraft.Data.Sql.CurrentUserSession() { UserId = usr, RCT = DateTime.Now, SessionId = Session.SessionID }); DbContext.SaveChanges(); Session["sessionid"] = Session.SessionID; System.Web.HttpContext.Current.Application[Session.SessionID.ToString()] = Session.SessionID; Session["ASP.NET_SessionId"] = Session.SessionID; Response.Cookies["ASP.NET_SessionId"].Value = Session.SessionID; Response.Cookies["LogOutState"].Value = "false"; return(RedirectToLocal(returnUrl)); } } else { if (WebSecurity.UserExists(model.UserName) && !WebSecurity.IsConfirmed(model.UserName)) { ModelState.AddModelError("", "Your account has been blocked. Please contact SSO admin."); } else { ModelState.AddModelError("", "The user name or password provided is incorrect."); } } } // If we got this far, something failed, redisplay form return(View(model)); }
public ActionResult Loginnew(string UserName) { //string decUserName = Decryptdata(UserName); LoginModel model = new LoginModel(); //model.UserName = decUserName; model.UserName = UserName; // model.Password = Password; string returnUrl = null; ViewBag.multipleLogin = "******"; //if (Settings.EnableOTP) //{ // string constrSSO = ConfigurationManager.ConnectionStrings["OTPConnectionString"].ConnectionString; // string Password = ""; // using (SqlConnection con1 = new SqlConnection(constrSSO)) // { // using (SqlCommand cmd1 = new SqlCommand()) // { // cmd1.CommandText = "GetPassword"; // cmd1.CommandType = CommandType.StoredProcedure; // cmd1.Parameters.AddWithValue("@UserName", UserName); // cmd1.Parameters.AddWithValue("@ApplnName", "SSOEMP"); // cmd1.Parameters.AddWithValue("@ApplnCode", "SSOEMP"); // con1.Open(); // cmd1.Connection = con1; // DataTable dt = new DataTable(); // SqlDataAdapter da = new SqlDataAdapter(); // da.SelectCommand = cmd1; // da.Fill(dt); // foreach (DataRow row in dt.Rows) // { // Password = row["password"].ToString(); // } // } // } // if (Password != "") // { // model.Password = Password; // } // TestOTPWebService.WebServiceSoapClient objOTP = new TestOTPWebService.WebServiceSoapClient(); // string uname = model.UserName; // string pass = model.Password; // string[] emailRegex = { "-", "<", ">", ";", "'" }; // for (var i = 0; i < emailRegex.Length; i++) // { // if (model.UserName != null) // model.UserName = model.UserName.Replace(emailRegex[i], " "); // if (model.Password != null) // model.Password = model.Password.Replace(emailRegex[i], " "); // } // string appName = "SSOEMP"; // string appCode = "SSOEMP"; // var result = objOTP.Login(Encryptdata(uname), Encryptdata(pass), Encryptdata(appName), Encryptdata(appCode)); // if (WebSecurity.IsAccountLockedOut(model.UserName, 5, 100)) // { // ModelState.AddModelError("", "Account is locked due to multiple failed login attempts."); // } // else if (WebSecurity.IsConfirmed(model.UserName) == false) // { // ModelState.AddModelError("", "Account disabled"); // } // else if (ModelState.IsValid && result) // { // FormsAuthentication.SetAuthCookie(model.UserName, false); // var usr = WebSecurity.GetUserId(model.UserName); // Teckraft.Data.Sql.InitiativeHubFinalEntities DbContext = new Teckraft.Data.Sql.InitiativeHubFinalEntities(); // var dt = DateTime.Now.AddMinutes(-22); // foreach (var item in DbContext.CurrentUserSessions.Where(it => it.UserId == usr && it.RCT < dt)) // { // DbContext.CurrentUserSessions.Remove(item); // } // DbContext.SaveChanges(); // var curSession = DbContext.CurrentUserSessions.FirstOrDefault(it => it.UserId == usr); // if (curSession != null && !model.ForcefullLogout) // { // ViewBag.multipleLogin = "******"; // ModelState.AddModelError("", "Mutiple login not allowed"); // WebSecurity.Logout(); // } // else // { // if (curSession != null) // { // System.Web.HttpContext.Current.Application[curSession.SessionId] = null; // DbContext.CurrentUserSessions.Remove(curSession); // } // DbContext.CurrentUserSessions.Add(new Teckraft.Data.Sql.CurrentUserSession() { UserId = usr, RCT = DateTime.Now, SessionId = Session.SessionID }); // DbContext.SaveChanges(); // Session["sessionid"] = Session.SessionID; // System.Web.HttpContext.Current.Application[Session.SessionID.ToString()] = Session.SessionID; // return RedirectToLocal(returnUrl); // } // } // else // { // if (WebSecurity.UserExists(model.UserName) && !WebSecurity.IsConfirmed(model.UserName)) // { // ModelState.AddModelError("", "Your account has been blocked. Please contact SSO admin."); // } // else // ModelState.AddModelError("", "The user name or password provided is incorrect."); // } //} // else // { model.Password = "******"; string[] emailRegex = { "-", "<", ">", ";", "'" }; for (var i = 0; i < emailRegex.Length; i++) { if (model.UserName != null) { model.UserName = model.UserName.Replace(emailRegex[i], " "); } if (model.Password != null) { model.Password = model.Password.Replace(emailRegex[i], " "); } } if (WebSecurity.IsAccountLockedOut(model.UserName, 5, 100)) { ModelState.AddModelError("", "Account is locked due to multiple failed login attempts."); } else if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe)) { if (String.IsNullOrEmpty(returnUrl)) { // returnUrl = "/"; } FormsAuthentication.SetAuthCookie(model.UserName, false); var usr = WebSecurity.GetUserId(model.UserName); Teckraft.Data.Sql.InitiativeHubFinalEntities DbContext = new Teckraft.Data.Sql.InitiativeHubFinalEntities(); var dt = DateTime.Now.AddMinutes(-22); foreach (var item in DbContext.CurrentUserSessions.Where(it => it.UserId == usr && it.RCT < dt)) { DbContext.CurrentUserSessions.Remove(item); } DbContext.SaveChanges(); var curSession = DbContext.CurrentUserSessions.FirstOrDefault(it => it.UserId == usr); //if (curSession != null && !model.ForcefullLogout) //{ // ModelState.AddModelError("", "Mutiple login not allowed"); // ViewBag.multipleLogin = "******"; // WebSecurity.Logout(); //} //else //{ if (curSession != null) { System.Web.HttpContext.Current.Application[curSession.SessionId] = null; DbContext.CurrentUserSessions.Remove(curSession); } DbContext.CurrentUserSessions.Add(new Teckraft.Data.Sql.CurrentUserSession() { UserId = usr, RCT = DateTime.Now, SessionId = Session.SessionID }); DbContext.SaveChanges(); Session["sessionid"] = Session.SessionID; System.Web.HttpContext.Current.Application[Session.SessionID.ToString()] = Session.SessionID; Session["ASP.NET_SessionId"] = Session.SessionID; Response.Cookies["ASP.NET_SessionId"].Value = Session.SessionID; Response.Cookies["LogOutState"].Value = "false"; return(RedirectToLocal(returnUrl)); //} } else { if (WebSecurity.UserExists(model.UserName) && !WebSecurity.IsConfirmed(model.UserName)) { ModelState.AddModelError("", "Your account has been blocked. Please contact SSO admin."); } else { ModelState.AddModelError("", "The user name or password provided is incorrect."); } } //} // If we got this far, something failed, redisplay form return(View(model)); }