public void Autenticateuser() { try { // ds = cc.getLoginDetails(txtUserId.Text.ToString(), cc.DESEncrypt(txtPassword.Text.ToString())); CTdll.UserLogin ul = new CTdll.UserLogin(); sc = ul.getLoggedIn(txtUserId.Text.ToString(), cc.DESEncrypt(txtPassword.Text.ToString()), ConfigurationManager.AppSettings["ConnectionString"], "Login"); Session["SC"] = sc; if (sc != null) { Session["User"] = Convert.ToString(sc.UserId); //Session["MobileNoN"] = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo"]); Session["UserFirstNameN"] = Convert.ToString(sc.UserFName); Session["UserLastNameN"] = Convert.ToString(sc.UserLName); Session["UserMiddleName"] = Convert.ToString(sc.UserMName); Session["CityNameN"] = Convert.ToString(sc.CityName); Session["City"] = Convert.ToString(sc.CityId); Session["Mobile"] = Convert.ToString(sc.Mobile); Session["lastLogin"] = Convert.ToString(sc.LastLogin); if (Convert.ToString(sc.UserId).Trim() == "") { lblMsg.Text = "Invalid User"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Name or Password is Incorrect ...Please try again')", true); } else { Response.Redirect("html/UserInfo.aspx"); } } else { lblMsg.Text = "Invalid User"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Name or Password is Incorrect ...Please try again')", true); } } catch (Exception ex) { string msg = ex.Message; lblMsg.Text = "Invalid User"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Name or Password is Incorrect...Please try again')", true); } }
public void Autenticateuser() { try { // ds = cc.getLoginDetails(txtUserId.Text.ToString(), cc.DESEncrypt(txtPassword.Text.ToString())); CTdll.UserLogin ul = new CTdll.UserLogin(); sc = ul.getLoggedIn(txtUserId.Text.ToString(), cc.DESEncrypt(txtPassword.Text.ToString()), ConfigurationManager.AppSettings["ConnectionString"], "Login"); Session["SC"] = sc; if (sc != null) { if (txtUserId.Text.Length == 10) { Session["User"] = Convert.ToString(sc.UserId); //Session["MobileNoN"] = Convert.ToString(ds.Tables[0].Rows[0]["MobileNo"]); Session["UserFirstNameN"] = Convert.ToString(sc.UserFName); Session["UserLastNameN"] = Convert.ToString(sc.UserLName); Session["UserMiddleName"] = Convert.ToString(sc.UserMName); Session["CityNameN"] = Convert.ToString(sc.CityName); Session["City"] = Convert.ToString(sc.CityId); Session["Mobile"] = Convert.ToString(sc.Mobile); Session["lastLogin"] = Convert.ToString(sc.LastLogin); Session["MobileNo"] = txtUserId.Text.ToString(); if (Convert.ToString(sc.UserId).Trim() == "") { lblMsg.Text = "Invalid User"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Name or Password is Incorrect ...Please try again')", true); } else { string sql = "select id from [DBCome2myct].[come2mycity].[DemoOnline] where userid='" + sc.UserId + "'"; string id = cc.ExecuteScalar(sql); if (id == "" || id == null) { sql = "insert into [DBCome2myct].[come2mycity].[DemoOnline](userid,status)values('" + sc.UserId + "','Active')"; int a = cc.ExecuteNonQuery(sql); } else { sql = "update [DBCome2myct].[come2mycity].[DemoOnline] set status='Active' where userid='" + sc.UserId + "'"; int a = cc.ExecuteNonQuery(sql); } string hostipadd = HttpContext.Current.Request.UserHostAddress; UserRegistrationBLL userRegBLL = new UserRegistrationBLL(); userRegBLL.usrUserId = Convert.ToString(Session["User"]); //userRegBLL.IPAddress = hostipadd; Response.Redirect("html/HomePage.aspx", false); ///changes done by pooja } } else { lblMsg.Text = "10 digit Mobile no"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please enter the 10 disit mobile No....!')", true); } } else { lblMsg.Text = "Invalid User"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Name or Password is Incorrect ...Please try again')", true); } } catch (Exception ex) { string msg = ex.Message; lblMsg.Text = "Invalid User"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User Name or Password is Incorrect...Please try again')", true); } }