public Boolean CreateClass(TeacherClass obj)
{
if (obj != null)
{
DBConnect objDB = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "Create new class";
objCommand.Parameters.AddWithValue("@Name", obj.Name);
objCommand.Parameters.AddWithValue("@Subject", obj.Subject);
objCommand.Parameters.AddWithValue("@Username", obj.Username);
objCommand.Parameters.AddWithValue("@User_Type", obj.User_Type);
int retVal = objDB.DoUpdateUsingCmdObj(objCommand);
if (retVal > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public IHttpActionResult PutTeacherClass(int id, TeacherClass teacherClass)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != teacherClass.ID)
{
return(BadRequest());
}
db.Entry(teacherClass).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TeacherClassExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult EditLevelTeach(IEnumerable <SubjectClass> subclass, string id)
{
var ListOfteachclass = db.TeacherClasses.Where(x => x.TeachId == id);
foreach (var item in ListOfteachclass)
{
if (!item.Thevideos.Any())
{
db.TeacherClasses.Remove(item);
}
}
db.SaveChanges();
foreach (var item in subclass)
{
if (!ListOfteachclass.Any(x => x.ClassID == item.Class.LevelID))
{
if (item.IsSelected)
{
TeacherClass tecclss = new TeacherClass();
tecclss.ClassID = item.Class.LevelID;
tecclss.TeachId = id;
db.TeacherClasses.Add(tecclss);
}
}
}
db.SaveChanges();
//var listOfVideosToTeach = db.Thevideos.Where(x => x.TeaClassID ==)
return(RedirectToAction("IndexTeach"));
}
public async Task <IActionResult> PutTeacherClass(int id, TeacherClass teacherClass)
{
if (id != teacherClass.TId)
{
return(BadRequest());
}
_context.Entry(teacherClass).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeacherClassExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteConfirmed(int id)
{
TeacherClass teacherClass = db.TeacherClasses.Find(id);
db.TeacherClasses.Remove(teacherClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool InsertTeacherClass_Hieu(TeacherClass tc)
{
SqlCommand cmd = new SqlCommand("insert into Teacher_Class(ClassID, TeacherID)" +
"values (@classID, @teacherID)");
cmd.Parameters.AddWithValue("@classID", tc.ClassID);
cmd.Parameters.AddWithValue("@teacherID", tc.TeacherID);
return(DAO.UpdateTable(cmd));
}
public IHttpActionResult GetTeacherClass(int id)
{
TeacherClass teacherClass = db.TeacherClasses.Find(id);
if (teacherClass == null)
{
return(NotFound());
}
return(Ok(teacherClass));
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (teacherData.dataGridTeacher.SelectedRows.Count > 0)
{
MessageBox.Show(TeacherClass.deleteStudent(this.teacherData.dataGridTeacher.CurrentRow.Cells[0].Value.ToString()));
}
else
{
MessageBox.Show("Veuillez sélectionner une ligne pour l'étudiant", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool UpdateTeacherClass_Hieu(TeacherClass tc)
{
SqlCommand cmd = new SqlCommand(@"UPDATE [dbo].[Teacher_Class]
SET[ClassID] = @classID
,[TeacherID] = @teacherID WHERE ID = @ID");
cmd.Parameters.AddWithValue("@ID", tc.ID);
cmd.Parameters.AddWithValue("@teacherID", tc.TeacherID);
cmd.Parameters.AddWithValue("@classID", tc.ClassID);
return(DAO.UpdateTable(cmd));
}
public int Insert(TeacherClass teacherToSave)
{
using (var connection = _dbConnectionFactory.GetConnection())
{
const string sql = @"INSERT INTO [AngularApp.Sql].dbo.[Classes.Teachers](ClassId,TeacherId)
VALUES
(@ClassId,@TeacherId);
SELECT CAST(SCOPE_IDENTITY() as int);" ;
return(connection.Query <int>(sql, teacherToSave).First());
}
}
public ActionResult Edit([Bind(Include = "ID,TeacherID,ClassID")] TeacherClass teacherClass)
{
if (ModelState.IsValid)
{
db.Entry(teacherClass).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ClassID = new SelectList(db.Classes, "ID", "Name", teacherClass.ClassID);
ViewBag.TeacherID = new SelectList(db.Teachers, "ID", "LastName", teacherClass.TeacherID);
return(View(teacherClass));
}
public IHttpActionResult PostTeacherClass(TeacherClass teacherClass)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.TeacherClasses.Add(teacherClass);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = teacherClass.ID }, teacherClass));
}
public IHttpActionResult DeleteTeacherClass(int id)
{
TeacherClass teacherClass = db.TeacherClasses.Find(id);
if (teacherClass == null)
{
return(NotFound());
}
db.TeacherClasses.Remove(teacherClass);
db.SaveChanges();
return(Ok(teacherClass));
}
// GET: TeacherClasses/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TeacherClass teacherClass = db.TeacherClasses.Find(id);
if (teacherClass == null)
{
return(HttpNotFound());
}
return(View(teacherClass));
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (
this.txtFirstName.Text != "" &&
this.txtLastName.Text != "" &&
this.txtEmail.Text != "" &&
this.txtProfession.Text != ""
)
{
MessageBox.Show(TeacherClass.updateTeacher(this.idProfessor.Text, this.txtFirstName.Text, this.txtLastName.Text, this.txtEmail.Text, this.txtProfession.Text), "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Tous les champs doivent être remplis", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public ActionResult AddLevelTeach(IEnumerable <SubjectClass> subclass, string id)
{
foreach (var item in subclass)
{
if (item.IsSelected)
{
TeacherClass tot = new TeacherClass();
tot.ClassID = item.Class.LevelID;
tot.TeachId = id;
db.TeacherClasses.Add(tot);
db.SaveChanges();
}
}
return(RedirectToAction("IndexTeach"));
}
// GET: TeacherClasses/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TeacherClass teacherClass = db.TeacherClasses.Find(id);
if (teacherClass == null)
{
return(HttpNotFound());
}
ViewBag.ClassID = new SelectList(db.Classes, "ID", "Name", teacherClass.ClassID);
ViewBag.TeacherID = new SelectList(db.Teachers, "ID", "LastName", teacherClass.TeacherID);
return(View(teacherClass));
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count <= 0)
{
MessageBox.Show("Please select a row!");
return;
}
var confirmResult = MessageBox.Show("Are you sure to delete this teacher?", "Confirm Delete!!", MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
Teacher t = classDAO.GetTeacherByName_Hieu(txtTeacher.Text);
TeacherClass tc = classDAO.GetTeacherClassID_Hieu(int.Parse(txtClassID.Text), t.TeacherID);
int id = tc.ID;
classDAO.deleteTeacherClass_Hieu(id);
MessageBox.Show("Delete Complete!");
loadData();
}
}
public TeacherClass GetTeacherClassID_Hieu(int classID, int teacherID)
{
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand cmd = new SqlCommand("select ID from Teacher_Class where ClassID = @classID and TeacherID = @teacherID", conn);
cmd.Parameters.AddWithValue("@classID", classID);
cmd.Parameters.AddWithValue("@teacherID", teacherID);
TeacherClass tc = new TeacherClass();
using (SqlDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
tc.ID = (int)reader["ID"];
}
conn.Close();
}
return(tc);
}
private void btnSave_Click(object sender, EventArgs e)
{
Class c = new Class();
TeacherClass tc = new TeacherClass();
c.ClassName = txtClassName.Text;
Teacher t = classDAO.GetTeacherByName_Hieu(txtTeacher.Text);
if (flag.Equals("add"))
{
bool isDoneC = classDAO.InsertClass_Hieu(c);
if (isDoneC)
{
Class c1 = classDAO.GetClassByName_Hieu(c.ClassName);
tc.ClassID = c1.ClassID;
tc.TeacherID = t.TeacherID;
bool isDoneTC = classDAO.InsertTeacherClass_Hieu(tc);
if (isDoneTC)
{
MessageBox.Show("Insert Complete!");
setEnable(false);
}
}
}
if (flag.Equals("edit"))
{
c.ClassID = int.Parse(txtClassID.Text);
tc.ID = int.Parse(txtID.Text);
tc.ClassID = c.ClassID;
tc.TeacherID = t.TeacherID;
bool isDoneC = classDAO.UpdateClass_Hieu(c);
bool isDoneTC = classDAO.UpdateTeacherClass_Hieu(tc);
if (isDoneC && isDoneTC)
{
MessageBox.Show("Update Complete!");
setEnable(false);
}
}
loadData();
}
// GET: Teacher/Show/{id}
public ActionResult Show(int id)
{
TeacherDataController controller = new TeacherDataController();
Teacher newTeacher = controller.FindTeacher(id);
Classes NewSearchClass = new Classes
{
employeeNumber = Convert.ToString(newTeacher.employeeNumber)
};
ClassesDataController class_controller = new ClassesDataController();
IEnumerable <Classes> filterClasses = class_controller.FilterClasses(NewSearchClass);
TeacherClass newTeacherClass = new TeacherClass
{
classes = filterClasses,
teacher = newTeacher
};
return(View(newTeacherClass));
}
public async Task <ActionResult <TeacherClass> > PostTeacherClass(TeacherClass teacherClass)
{
_context.TeacherClasses.Add(teacherClass);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (TeacherClassExists(teacherClass.TId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetTeacherClass", new { id = teacherClass.TId }, teacherClass));
}
public int Insert(TeacherClass teacherToSave)
{
return(_teacherClassRepository.Insert(teacherToSave));
}
public IHttpActionResult Save(TeacherClass teacherClass)
{
var results = _teacherClassService.Insert(teacherClass);
return(Ok(results));
}
