public ActionResult Save(SaveTeacherModel teacher) { ViewBag.departments = saveTeacherManager.DepartmentDropDownlist(); ViewBag.designations = saveTeacherManager.DesignationDropDownList(); ViewBag.message = saveTeacherManager.Save(teacher); return(View()); }
public string Save(SaveTeacherModel teacher) { int rowEffect = saveTeacherGateway.Save(teacher); if (rowEffect > 0) { return("Save Success"); } else { return("Save Faild"); } }
public int Save(SaveTeacherModel teacher) { query = "INSERT INTO TeacherTable VALUES(@Name,@Address,@Email,@ContactNo,@DesignationId,@DepartmentID,@Credit,0)"; Command = new SqlCommand(query, Connection); Command.Parameters.AddWithValue("@Address", teacher.Address); Command.Parameters.AddWithValue("@Name", teacher.Name); Command.Parameters.AddWithValue("@Credit", teacher.Credit); Command.Parameters.AddWithValue("@ContactNo", teacher.ContactNo); Command.Parameters.AddWithValue("@DepartmentID", teacher.DepartmentId); Command.Parameters.AddWithValue("@DesignationId", teacher.DesignationId); Command.Parameters.AddWithValue("@Email", teacher.Email); Connection.Open(); int rowEffect = Command.ExecuteNonQuery(); Connection.Close(); return(rowEffect); }