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(); } }