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