public async Task <IActionResult> PutPreviousSchoolInfo(int id, PreviousSchoolInfo previousSchoolInfo)
{
if (id != previousSchoolInfo.Id)
{
return(BadRequest());
}
_context.Entry(previousSchoolInfo).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PreviousSchoolInfoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <PreviousSchoolInfo> > PostPreviousSchoolInfo(PreviousSchoolInfo previousSchoolInfo)
{
_context.PreviousSchoolInfos.Add(previousSchoolInfo);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPreviousSchoolInfo", new { id = previousSchoolInfo.Id }, previousSchoolInfo));
}
public ActionResult Index(FormCollection form)
{
// ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";
String firstname = "";
String lastname = "";
String email = "";
String password = "";
firstname = form["fname"].ToString();
lastname = form["lname"].ToString();
email = form["email"].ToString();
password = form["password"].ToString();
String cs = ConfigurationManager.ConnectionStrings["CEASYS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
try
{
con.Open(); // Does the connection with database
// ViewBag.Message = "Connection is sucessful";
var insertCommand = "INSERT INTO Student_Profile(FirstName, LastName, Email,Password) Values('" + firstname + "','" + lastname + "','" + email + "','" + password + "')";
//insertCommand.Parameters.Add("@FirstName", SqlDbType.VarChar, 50).Value = firstName;
//cmd.Parameters.Add("@Lastname", SqlDbType.VarChar, 50).Value = lastName;
//cmd.Parameters.Add("@Username", SqlDbType.VarChar, 50).Value = userName;
//cmd.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = password;
//cmd.Parameters.Add("@Age", SqlDbType.Int).Value = age;
//cmd.Parameters.Add("@Gender", SqlDbType.VarChar, 50).Value = gender;
//cmd.Parameters.Add("@Contact", SqlDbType.VarChar, 50).Value = contact;
using (SqlCommand cmd = new SqlCommand(insertCommand, con))
{
cmd.ExecuteNonQuery();
var studentdata = context.Student_Profile.Where(s => s.Email == email).Select(s => s).FirstOrDefault();
var addressInfo = new AddressStudent();
addressInfo.StudentId = studentdata.StudentId;
var citizenshipInfo = new CitizenShipInfo();
citizenshipInfo.StudentId = studentdata.StudentId;
var academicinfo = new AcademicInfo();
academicinfo.StudentId = studentdata.StudentId;
var preSchholInfo = new PreviousSchoolInfo();
preSchholInfo.StudentId = studentdata.StudentId;
var greExam = new ExamInfo();
var toeflExam = new ExamInfo();
var IeltsExam = new ExamInfo();
greExam.StudentId = toeflExam.StudentId = IeltsExam.StudentId = studentdata.StudentId;
var workInfo = new WorkInfo();
workInfo.StudentId = studentdata.StudentId;
context.Entry(addressInfo).State = System.Data.EntityState.Added;
context.Entry(citizenshipInfo).State = System.Data.EntityState.Added;
context.Entry(academicinfo).State = System.Data.EntityState.Added;
context.Entry(preSchholInfo).State = System.Data.EntityState.Added; //
context.Entry(greExam).State = System.Data.EntityState.Added;
context.Entry(toeflExam).State = System.Data.EntityState.Added;
context.Entry(IeltsExam).State = System.Data.EntityState.Added;
context.Entry(workInfo).State = System.Data.EntityState.Added;//
context.SaveChanges();
TempData["RegisterMsg"] = "Registration has been completed!!";
}
} // end try
catch (Exception e) // catches the exception message
{
TempData["RegisterMsg"] = "Email Already registered.Please try with different email";
} // end catch
finally
{
con.Close(); //Closes the connection to database
}
}
return(RedirectToAction("Index"));
}
