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