public DataTable Forget_password(login_bal obj) { cmd = new SqlCommand("Proc_login_user_Add", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@email_id", obj.Email_id); cmd.Parameters.AddWithValue("@oper", obj.Oper); try { adp = new SqlDataAdapter(cmd); dt = new DataTable(); adp.Fill(dt); return dt; } catch (Exception ex) { string s = ex.Message.ToString(); // MessageBox.Show(s); return dt; } finally { con.Close(); } }
public DataSet ConfirmPassword(login_bal objReg) { DataSet ds = new DataSet(); using (DBManager objDBManager = new DBManager(ConfigurationManager.ConnectionStrings["conn"].ToString())) { objDBManager.Open(); objDBManager.CreateParameters(3); objDBManager.AddParameters(0, "@TYPE", objReg.TYPE); objDBManager.AddParameters(1, "@PASSWORD", objReg.PASSWORD); objDBManager.AddParameters(2, "@ID", objReg.EMPID); ds = objDBManager.ExecuteDataSet(CommandType.StoredProcedure, "SP_CHG_PASS"); } return(ds); }
public DataSet VerifyLogin(login_bal objReg) { DataSet ds = new DataSet(); using (DBManager objDBManager = new DBManager(ConfigurationManager.ConnectionStrings["conn"].ToString())) { objDBManager.Open(); objDBManager.CreateParameters(3); objDBManager.AddParameters(0, "@EMAIL", objReg.UserName); objDBManager.AddParameters(1, "@PWD", objReg.PASSWORD); objDBManager.AddParameters(2, "@TYPE", objReg.TYPE); ds = objDBManager.ExecuteDataSet(CommandType.StoredProcedure, "USP_USER_LOGIN"); } return(ds); }
public string _Logout(login_bal utl) { string re = ""; re = _cs.ExecuteCmd_WithOutput(_cs.ReturnCommand("USP_USER_LOGOUT", "@ID^@DESC", utl.EMPID + "^" + utl.Desc, '^'), "@OUT"); if (re == "1") { re = "Success"; } else { re = "Error"; } return(re); }
public string ForgotPwd(login_bal objReg) { int intAffectedRows = 0; string strout = ""; using (DBManager objDBManager = new DBManager(ConfigurationManager.ConnectionStrings["conn"].ToString())) { objDBManager.Open(); objDBManager.CreateParameters(3); objDBManager.AddParameters(0, "@EmpEmail", objReg.EMAIL); objDBManager.AddParameters(1, "@EmpPassword", objReg.PASSWORD); objDBManager.AddParameters(2, "@msg", "", ParameterDirection.Output); intAffectedRows = objDBManager.ExecuteNonQuery(CommandType.StoredProcedure, "EMPFORGOTPASSWORD"); strout = objDBManager.Parameters[2].Value.ToString(); } return(strout); }
public string Create_new_user(login_bal obj) { cmd = new SqlCommand("Proc_login_user_Add", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@login_name", obj.User_name); cmd.Parameters.AddWithValue("@password", obj.Password); cmd.Parameters.AddWithValue("@email_id", obj.Email_id ); cmd.Parameters.AddWithValue("@oper", obj.Oper); try { con.Open(); int i = cmd.ExecuteNonQuery(); return i.ToString(); } catch(Exception ex) { return (ex.Message.ToString()); } finally { con.Close(); } }
public int user_login(login_bal obj) { int i = 0; cmd = new SqlCommand("Proc_login_user_Add", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@login_name", obj.User_name ); cmd.Parameters.AddWithValue("@password", obj.Password); cmd.Parameters.AddWithValue("@oper", obj.Oper); try { con.Open(); rd = cmd.ExecuteReader(); while (rd.Read()) { i = 1; } } finally { con.Close(); } return i; }