public IActionResult Update(string id, [FromBody] RegisterSubject registerSubject) { var entity = context.RegisterSubjects.FirstOrDefault(e => e.RegisterId.Equals(id)); try { if (entity != null) { entity.StudentId = registerSubject.StudentId; entity.SubjectId = registerSubject.SubjectId; entity.TeacherId = registerSubject.TeacherId; entity.DateStart = registerSubject.DateStart; entity.DateEnd = registerSubject.DateEnd; context.RegisterSubjects.Update(entity); context.SaveChanges(); return(Ok("True")); } } catch (Exception) { return(Ok("False")); } return(Ok("False")); }
public IActionResult Update(string id, [FromBody] RegisterSubject _RegisterSubject) { var tEntity = context.RegisterSubject.FirstOrDefault(e => e.RegisterId.Equals(id)); if (tEntity != null) { try { tEntity.DateEnd = _RegisterSubject.DateEnd; tEntity.DateStart = _RegisterSubject.DateStart; tEntity.StudentId = _RegisterSubject.StudentId; tEntity.SubjectId = _RegisterSubject.SubjectId; tEntity.TeacherId = _RegisterSubject.SubjectId; context.RegisterSubject.Update(tEntity); context.SaveChanges(); return(Ok(true)); } catch (Exception) { return(Ok(false)); } } return(Ok(false)); }
/* CREATE */ public static void Regist_Subject(string Id_Subject, string Id_Class, string Id_Teacher) { var client = ConnectNeo4J.Connection(); var mh = new RegisterSubject { id_subject = Id_Subject, id_class = Id_Class, id_teacher = Id_Teacher }; client.Cypher.Create("(:RegisterSubject {mh})").WithParam("mh", mh).ExecuteWithoutResultsAsync().Wait(); /* relation between subject -> register */ client.Cypher.Match("(a:Subject)", "(b:RegisterSubject)"). Where((Subject a) => a.id == Id_Subject). AndWhere((RegisterSubject b) => b.id_subject == Id_Subject && b.id_class == Id_Class). Create("(a)-[:Subject_Regist]->(b)").ExecuteWithoutResults(); /* relation between teacher -> register */ client.Cypher.Match("(a:Teacher)", "(b:RegisterSubject)"). Where((Teacher a) => a.id == Id_Teacher). AndWhere((RegisterSubject b) => b.id_teacher == Id_Teacher). Create("(a)<-[:Teacher_Subject]-(b)").ExecuteWithoutResults(); /* relation between class -> register */ client.Cypher.Match("(a:Class)", "(b:RegisterSubject)"). Where((Class a) => a.id == Id_Class). AndWhere((RegisterSubject b) => b.id_class == Id_Class). Create("(a)-[:Class_Regist]->(b)").ExecuteWithoutResults(); client.Dispose(); }
public ActionResult RegisterSubject([Bind(Include = "StudentID")] Mapping map) { var registerSubject = new RegisterSubject(); registerSubject.RegStudent = db.StudentsMVC.Find(map.StudentID); registerSubject.RegSubjects = db.Subjects.ToList(); var listMap = new List <Mapping>(); listMap = db.Mappings.Where(i => i.StudentID == map.StudentID).ToList(); foreach (var itemSub in db.Subjects.ToList()) { foreach (var itemMap in listMap) { if (itemSub.SubjectID == itemMap.SubjectID) { ///// disable reg } } } if (registerSubject == null) { return(HttpNotFound()); } return(View(registerSubject)); }
public ActionResult DeleteConfirmed(int id) { RegisterSubject registerSubject = db.RegisterSubjects.Find(id); db.RegisterSubjects.Remove(registerSubject); db.SaveChanges(); return(RedirectToAction("Index")); }
/* UPDATE */ public static void Update_Regist(string Id_Subject, string Id_Class, string Id_Teacher, string Id_Student) { var client = ConnectNeo4J.Connection(); var mh = new RegisterSubject { id_subject = Id_Subject, id_class = Id_Class, id_teacher = Id_Teacher, id_student = Id_Student }; client.Cypher.Match("(a:RegisterSubject)").Where((RegisterSubject a) => a.id_subject == Id_Subject).Set("a = {mh}").WithParam("mh", mh).ExecuteWithoutResults(); client.Dispose(); }
public Host() { InitializeComponent(); m_Log = log4net.LogManager.GetLogger("Kaitrade"); m_SubscribeMD = new RegisterSubject(this.doSubscribeMD); m_RegisterTS = new RequestTS(this.doRequestTS); m_ProcessMessage = new ProcessMessage(this.doProcessMessage); m_Connect = new Connect(this.doConnect); //timer1.Interval = 0; //timer1.Start(); }
public IActionResult Create([FromBody] RegisterSubject _RegisterSubject) { try{ _RegisterSubject.RegisterId = Guid.NewGuid() + ""; context.RegisterSubject.Add(_RegisterSubject); context.SaveChanges(); return(Ok(true)); }catch { return(Ok(false)); }; }
public static ListViewItem RegisterSubjectModelToListViewItem(RegisterSubject registerSubject) { foreach (ListViewItem item in lvwRegisterSubjectState.Items) { if (item.SubItems[0].Text == registerSubject.Id_subject) { return(item); } } return(null); }
public ActionResult Edit([Bind(Include = "RegSubID,StudentID,SubjectID")] RegisterSubject registerSubject) { if (ModelState.IsValid) { db.Entry(registerSubject).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", registerSubject.StudentID); ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "SubjectName", registerSubject.SubjectID); return(View(registerSubject)); }
public ActionResult Create([Bind(Include = "RegSubID,RegStudent_StudentID,RegSubject_SubjectID")] RegisterSubject registerSubject) { if (ModelState.IsValid) { db.RegisterSubjects.Add(registerSubject); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RegStudent_StudentID = new SelectList(db.Students, "StudentID", "StudentName", registerSubject.RegStudent_StudentID); ViewBag.RegSubject_SubjectID = new SelectList(db.Subjects, "SubjectID", "SubjectName", registerSubject.RegSubject_SubjectID); return(View(registerSubject)); }
public IActionResult CreateSubject([FromBody] RegisterSubject registerSubject) { try { context.RegisterSubjects.Add(registerSubject); context.SaveChanges(); return(Ok("True")); } catch (Exception) { return(Ok("False")); } }
// GET: RegisterSubjects/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RegisterSubject registerSubject = db.RegisterSubjects.Find(id); if (registerSubject == null) { return(HttpNotFound()); } return(View(registerSubject)); }
// GET: RegisterSubjects/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RegisterSubject registerSubject = db.RegisterSubjects.Find(id); if (registerSubject == null) { return(HttpNotFound()); } ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", registerSubject.StudentID); ViewBag.SubjectID = new SelectList(db.Subjects, "SubjectID", "SubjectName", registerSubject.SubjectID); return(View(registerSubject)); }
private void btnRegister_Click(object sender, EventArgs e) { string id_user = txtCodeNum.Text; string id_subject = txtIdRegister.Text; if (id_user.Length <= 0 || id_subject.Length <= 0) { MessageBox.Show(MessageBoxText.NotSelectListView, MessageBoxText.CaptionInformation, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } RegisterSubject registerSubject = new RegisterSubject(id_user, id_subject); RegisterSubjectBUS.HandleCreateRegisterSubject(lvwRegister, lvwRegistered, registerSubject); txtIdRegister.Text = String.Empty; txtNameRegister.Text = String.Empty; }
public ActionResult RegisterSubject(int id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var registerSubject = new RegisterSubject(); registerSubject.RegStudent = db.StudentsMVC.Find(id); registerSubject.RegSubjects = db.Subjects.ToList(); if (registerSubject == null) { return(HttpNotFound()); } return(View(registerSubject)); }
public ActionResult SubjectDetailPartial(int id) { var mapView = new RegisterSubject(); mapView.RegSubject = db.Subjects.Find(id); var listStudentID = new List <int>(); var list = new List <StudentsManagement.Models.Mapping>(); list = db.Mappings.Where(i => i.SubjectID == id).ToList(); foreach (var item in list) { listStudentID.Add(item.StudentID); } foreach (var i in listStudentID) { mapView.RegStudents.Add(db.StudentsMVC.Find(i)); } return(PartialView("SubjectDetailsPartial1", mapView)); }
public static bool CreateRegisterSubject(RegisterSubject registerSubject) { try { MySqlCommand command = connectDB.CreateCommand(); command.CommandText = "createRegisterSubject"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new MySqlParameter("@id_user", registerSubject.Id_user)); command.Parameters.Add(new MySqlParameter("@id_subject", registerSubject.Id_subject)); int result = command.ExecuteNonQuery(); if (result == 1) { return(true); } } catch (Exception) { MessageBox.Show(MessageBoxText.Exception, MessageBoxText.CaptionError, MessageBoxButtons.OK, MessageBoxIcon.Error); } return(false); }
private void CQGFrm_FormClosed(object sender, FormClosedEventArgs e) { try { m_Log.Info("CQGFrm_FormClosed"); m_Adapter = null; m_CQG = null; m_ProcessMessage = null; m_RegisterSubject = null; } catch (Exception myE) { } }
public static void HandleCreateRegisterSubject(ListView lvwRegister, ListView lvwRegistered, RegisterSubject registerSubject) { bool result = RegisterSubjectDAL.CreateRegisterSubject(registerSubject); if (result) { ListViewItem item = RegisterSubjectModelToListViewItem(registerSubject); if (item != null) { lvwRegisteredSubjectState.Items.Insert(0, item.Clone() as ListViewItem); DeleteListViewRegisterWithIdSubject(registerSubject.Id_subject); RenderListViewRegisterFromState(lvwRegister); RenderListViewRegisteredFromState(lvwRegistered); } } }
private void TDAHost_FormClosed(object sender, FormClosedEventArgs e) { m_ProcessMessage = null; m_SubscribeMD = null; m_Adapter = null; }