public string Save(Teacher teacher)
{
if (!(IsEmailAddressValid(teacher.Email)))
{
return "Please! Enter a valid email address";
}
if (IsEmailAddressExits(teacher.Email))
{
return "Email address must be unique";
}
if (teacherGateway.Insert(teacher) > 0)
{
return "Saved Sucessfully";
}
return "Failed to save";
}
public Teacher GetTeacherByEmailAddress(string email)
{
try
{
string query = "SELECT * FROM t_Teacher WHERE Email=@email";
CommandObj.CommandText = query;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@email", email);
Teacher teacher = null;
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
if(reader.Read())
{
teacher = new Teacher
{
Id = Convert.ToInt32(reader["Id"].ToString()),
Name = reader["Name"].ToString(),
Address = reader["Address"].ToString(),
Email = reader["Email"].ToString(),
Contact = reader["Contact"].ToString(),
DesignationId = Convert.ToInt32(reader["DesignationId"].ToString()),
DepartmentId = Convert.ToInt32(reader["DepartmentId"].ToString()),
CreditTobeTaken = Convert.ToDouble(reader["CreditToBeTaken"].ToString())
};
}
reader.Close();
return teacher;
}
catch (Exception exception)
{
throw new Exception("Unable to collect Teachers", exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
public int Insert(Teacher teacher)
{
try
{
CommandObj.CommandText = "spAddTeacher";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@Name", teacher.Name);
CommandObj.Parameters.AddWithValue("@Address", teacher.Address);
CommandObj.Parameters.AddWithValue("@Email", teacher.Email.ToLower());
CommandObj.Parameters.AddWithValue("@Contact", teacher.Contact);
CommandObj.Parameters.AddWithValue("@DesignationId", teacher.DesignationId);
CommandObj.Parameters.AddWithValue("@DepartmentId", teacher.DepartmentId);
CommandObj.Parameters.AddWithValue("@CreditTobeTaken", teacher.CreditTobeTaken);
CommandObj.Parameters.AddWithValue("@RemainingCredit", 0);
ConnectionObj.Open();
return CommandObj.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception("Could Not save teacher",exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
public ActionResult Save(Teacher teacher)
{
try
{
message = teacherManager.Save(teacher);
IEnumerable<Designation> desinationList = designationManager.GetAll;
IEnumerable<Department> departments = departmentManager.GetAll();
ViewBag.Designations = desinationList;
ViewBag.Departments = departments;
ViewBag.Message = message;
return View();
//return RedirectToAction("Index");
}
catch(Exception exception)
{
message = exception.Message;
if (exception.InnerException != null)
{
message += "<br/>System Error:" + exception.InnerException.Message;
}
ViewBag.Message = message;
return View();
}
}
