public ActionResult RegisterStu()
{
string connectionString = @"Data Source=msi;Initial Catalog=SEFASSIGNMENT;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
sqlConnection.Open();
System.Data.SqlClient.SqlCommand sqlCommand = new System.Data.SqlClient.SqlCommand("SELECT COUNT(*) FROM Student");
sqlCommand.Connection = sqlConnection;
int count = Convert.ToInt32(sqlCommand.ExecuteScalar()) + 1;
string newID = "STU" + count.ToString("000");
Student existStu = db.Students.Find(newID);
while (existStu != null)
{
count++;
newID = "STU" + count.ToString("000");
existStu = db.Students.Find(newID);
}
var model = new RegisterStu
{
Stu_ID = newID
};
return(View(model));
}
public ActionResult RegisterStu(string action, RegisterStu f)
{
if (!ModelState.IsValid)
{
return(View());
}
else
{
Class classid = db.Classes.Find(f.Class_ID);
if (f.Stu_Pass != f.Stu_Pass_Confirm)
{
ModelState.AddModelError("Stu_Pass_Confirm", "The password you entered does not match the above password");
}
else if (f.Stu_Pass.Length < 8)
{
ModelState.AddModelError("Stu_Pass", "Your password must more than 8 characters.");
}
else if (classid == null)
{
ModelState.AddModelError("Class_ID", "This class ID does not exists.");
}
else
{
Student stu = new Student();
stu.Stu_ID = f.Stu_ID;
stu.Stu_Name = f.Stu_Name;
stu.Stu_Pass = f.Stu_Pass;
stu.Stu_Email = f.Stu_Email;
stu.Stu_PhoneNo = f.Stu_PhoneNo;
stu.Class_ID = f.Class_ID.ToUpper();
db.Students.Add(stu);
db.SaveChanges();
return(RedirectToAction("Login"));
}
}
return(View());
}
