public ActionResult Register(StuUser user)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQL"].ConnectionString))
{
string cmd = "Insert into StudentRegister(UserName, Email, PhoneNum, ConfimPassWords) Values(@UserName, @Email, @PhoneNum, @ConfimPassWords)";
int i = con.Execute(cmd, user);
if (i > 0)
{
ViewBag.msg = "Finish !!";
}
else
{
ViewBag.msg = "Error !!";
ViewBag.flag = false;
}
}
return(View("RegisterResult"));
}
public ActionResult Update(int ID, StuUser reg)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQL"].ConnectionString))
{
string cmd = $"Update dbo.StudentRegister SET UserName = @UserName, Email = @Email, PhoneNum = @PhoneNum, ConfimPassWords = @ConfimPassWords Where (ID = {ID})";
int i = con.Execute(cmd, reg);
if (i > 0)
{
ViewBag.msg = "Finish !!";
}
else
{
ViewBag.msg = "Error !!";
ViewBag.flag = false;
}
}
//return View("UpdateResult");
return(View());
}
public ActionResult Delete(int ID)
{
var con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQL"].ConnectionString);
var info = new StuUser();
info.ID = ID;
string cmd = $"Delete From dbo.StudentRegister Where ID=@ID";
int i = con.Execute(cmd, info);
if (i > 0)
{
ViewBag.msg = "Finish !!";
}
else
{
ViewBag.msg = "Error !!";
ViewBag.flag = false;
}
return(RedirectToAction("Index"));
}
