private void editData()
{
Connector db = new Connector();
string query = String.Format("update subjects set " +
"name = '{0}', classificationID = {1} where id = {2};", subjectTB.Text, ClassificationVM.getClassification(typeCB.Text).id,
((FacultyLoads)dg.SelectedItem).subjectID);
if (db.addData(query) != -1)
{
SubjectVM.getSubject(((FacultyLoads)dg.SelectedItem).subjectID).name = subjectTB.Text;
SubjectVM.getSubject(((FacultyLoads)dg.SelectedItem).subjectID).classID = ClassificationVM.getClassification(typeCB.Text).id;
}
dg.Items.Refresh();
typeCB.Items.Refresh();
subjectTB.Items.Refresh();
}
private void addData()
{
long lastid;
string query;
Connector db = new Connector();
if (SubjectVM.getSubject(subjectTB.Text) == null)
{
query = String.Format("insert into subjects ( name, classificationID) values (" +
"'{0}', {1})", subjectTB.Text,
ClassificationVM.getClassification(typeCB.Text).id);
lastid = db.addData(query);
if (lastid != -1)
{
SubjectVM.Subjects.Add(new Subject
{
id = (int)lastid,
name = subjectTB.Text,
classID = ClassificationVM.getClassification(typeCB.Text).id
});
}
}
query = String.Format("insert into facultyloads (facultyId, subjectId) values (" +
"{0}, {1});", CurrentUser.user.id, SubjectVM.getSubject(subjectTB.Text).id);
lastid = db.addData(query);
if (lastid != -1)
{
//Console.WriteLine(query);
LoadsVM.specificLoads.Add(new FacultyLoads
{
id = (int)lastid,
facultyID = CurrentUser.user.id,
subjectID = SubjectVM.getSubject(subjectTB.Text).id
});
}
}