public List <Models.SignUpBO> getAllUsers()
{
List <Models.SignUpBO> l = new List <Models.SignUpBO>();
SqlConnection SecurityDBConnStr = Models.Connection.getConnection();
string s = "Select * from SignUp ";
SqlCommand cmd = new SqlCommand(s, SecurityDBConnStr);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
Models.SignUpBO u = new Models.SignUpBO();
try
{
da.Fill(dt);
foreach (DataRow d in dt.Rows)
{
u = new Models.SignUpBO();
u.username = d["UserName"].ToString();
u.email = (d["Email"].ToString());
u.pass = (d["Password"].ToString());
l.Add(u);
}
}
catch (Exception em)
{
return(l);
}
return(l);
}
public static Boolean AddUser(Models.SignUpBO b)
{
SqlConnection SecurityDBConnStr = Connection.getConnection();
Boolean statusFlag = false;
if (b.email.Contains("@") && b.email.Contains("."))
{
statusFlag = true;
}
if (!b.pass.Equals(b.repass))
{
return(false);
}
string s = "Insert into SignUp (UserName,Email,Password) values ('" + b.username + "','" + b.email + "','" + b.pass + "')";
try
{
if (statusFlag)
{
SqlCommand cmd = new SqlCommand(s, SecurityDBConnStr);
int r = cmd.ExecuteNonQuery();
if (r != 0)
{
return(true);
}
}
}
catch (Exception em)
{
return(false);
}
return(false);
}
public ActionResult AddUser(string n, string e, string p, string rp)
{
Models.SignUpBO s = new Models.SignUpBO();
s.username = n;
s.email = e;
s.pass = p;
s.repass = rp;
if (p != rp)
{
ViewBag.Msg = "password does not match!";
}
if (Models.LogInDAL.AddUser(s))
{
// Session["logIn"] = e.Trim();
ViewBag.Msg = "successfully signed in";
return(Redirect("~/Admin/AddUser"));
}
else
{
ViewBag.Msg = "Enter correct email";
}
return(View());
}
