public void SetUp()
{
student = new StudentAddressInfo()
{
studentAddress = "Boring Road",
city = "Patna",
state = "Bihar",
};
}
public void UpdateStudentAddressInfoIntoDatabase(StudentAddressInfo student)
{
try
{
studentAddressDataAccess.UpdateStudentAddressInfoIntoDatabase(student);
}
catch (Exception exception)
{
throw exception;
}
}
public StudentAddressInfo DisplayStudentAddressInfoByIdFromDatabase(int id)
{
try {
StudentAddressInfo studentAddress = DisplayStudentAddressInfoFromDatabase().FirstOrDefault(x => x.studentAddressId == id);
return(studentAddress);
}
catch (Exception exception)
{
throw exception;
}
}
public ActionResult AddressInfo()
{
try {
StudentAddressInfo student = new StudentAddressInfo();
if (Session["studentAddressId"] != null)
{
student = studentAddressBusinessAccess.DisplayStudentAddressInfoByIdFromDatabase((int)Session["studentAddressId"]);
return(View("AddressInfo", student));
}
return(View("AddressInfo", student));
}
catch (Exception exception)
{
return(View("Error"));
}
}
public void UpdateStudentAddressInfoIntoDatabase(StudentAddressInfo student)
{
try
{
using (connection)
{
SqlCommand sqlCommand = new SqlCommand("UpdateStudentAddressInfoStoredProcedure", connection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@studentAddressId", student.studentAddressId);
sqlCommand.Parameters.AddWithValue("@studentAddress", student.studentAddress);
sqlCommand.Parameters.AddWithValue("@city", student.city);
sqlCommand.Parameters.AddWithValue("@state", student.state);
sqlCommand.Parameters.AddWithValue("@studentId", Session["studentId"]);
connection.Open();
sqlCommand.ExecuteNonQuery();
}
}
catch (Exception exception)
{
throw exception;
}
}
public ActionResult AddressInfo(StudentAddressInfo studentAddressInfo)
{
try {
if (ModelState.IsValid)
{
if (Session["studentAddressId"] != null)
{
studentAddressBusinessAccess.UpdateStudentAddressInfoIntoDatabase(studentAddressInfo);
}
else
{
studentAddressBusinessAccess.InsertStudentAddressInfoIntoDatabase(studentAddressInfo);
}
return(RedirectToAction("QualificationInfo", "Qualification"));
}
return(View("AddressInfo"));
}
catch (Exception exception)
{
return(View("Error"));
}
}
public void InsertStudentAddressInfoIntoDatabase(StudentAddressInfo student)
{
try
{
using (connection)
{
SqlCommand sqlCommand = new SqlCommand("InsertStudentAddressInfoStoredProcedure", connection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@studentAddress", student.studentAddress);
sqlCommand.Parameters.AddWithValue("@city", student.city);
sqlCommand.Parameters.AddWithValue("@state", student.state);
sqlCommand.Parameters.AddWithValue("@studentId", Session["studentId"]);
SqlCommand command = new SqlCommand("SELECT MAX(studentAddressId) FROM dbo.StudentAddressInfo", connection);
connection.Open();
sqlCommand.ExecuteNonQuery();
Session["studentAddressId"] = (Int32)command.ExecuteScalar();
}
}
catch (Exception exception)
{
throw exception;
}
}
