public bool changeName(string id, string name)
{
try
{
Account acname = db.Accounts.Where(ac => ac.id == id).SingleOrDefault();
acname.name = name;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Updatelecturer(string id, string content)
{
try
{
Program lec = db.Programs.Where(st => st.id == id).Single();
lec.ProgramLecturer = content;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool AddObj(string ids, string content)
{
try
{
SyllabusObjective addobj = new SyllabusObjective();
addobj.id = createID();
addobj.idSyllabus = ids;
addobj.ObjSContent = content;
db.SyllabusObjectives.InsertOnSubmit(addobj);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateDocument(string id, string content)
{
try
{
Syllabus sysdocument = db.Syllabus.Where(info => info.id == id).Single();
sysdocument.CourseDocument = content;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool AddProOut(string idp, string no, int type, string content)
{
try
{
ProgramOutcome poc = new ProgramOutcome();
poc.id = createID();
poc.idProgram = idp;
poc.OutcomeNo = no;
poc.OutcomeType = type;
poc.OutcomeContent = content;
db.ProgramOutcomes.InsertOnSubmit(poc);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool AddOut(string ids, string no, string content)
{
try
{
SyllabusOutcome outadd = new SyllabusOutcome();
currentID = createID();
outadd.id = currentID;
outadd.idSyllabus = ids;
outadd.OutcomeNo = no;
outadd.OutcomeContent = content;
mapz.AddMap(ids, currentID, "");
db.SyllabusOutcomes.InsertOnSubmit(outadd);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//add Account
public bool AddAccount(string user, string name, bool isadmin, bool active)
{
try
{
Account accAdd = new Account();
accAdd.id = createID();
accAdd.email = user;
accAdd.password = en.EncodeSHA1(dic.defaultPass());
accAdd.name = name;
accAdd.isAdmin = isadmin;
accAdd.Active = active;
db.Accounts.InsertOnSubmit(accAdd);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateMethod(string idmap, string method, string p1, string p2, string p3, int per1, int per2, int per3, int des)
{
try
{
Mapping manup = db.Mappings.Where(ma => ma.id == idmap).Single();
manup.Methods = method;
manup.FirstPart = p1;
manup.SecondPart = p2;
manup.ThirdPart = p3;
manup.FirstPercent = per1;
manup.SecondPercent = per2;
manup.ThirdPercent = per3;
manup.desity = des;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Bạn chắc chắn muốn hoàn thành việc xây dựng chương trình đào tạo chứ?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
foreach (Syllabus item in db.Syllabus.Where(s => s.idProgram == idpath).ToList())
{
item.isLockEdit = true;
db.SubmitChanges();
}
MessageBox.Show("Cập nhập thành công, bạn không thể xóa môn học.");
}
}
public bool AddSche(string idS, DateTime date, int number, string content, string acitve, string doc, bool mid)
{
try
{
SyllabusSchedule addsche = new SyllabusSchedule();
addsche.id = createScheID();
addsche.idSyllabus = idS;
addsche.Day = date;
addsche.NumberPeriods = number;
addsche.LectureContent = content;
addsche.Activites = acitve;
addsche.Doc = doc;
addsche.mid = mid;
db.SyllabusSchedules.InsertOnSubmit(addsche);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool successUpdate(string user, string pass)
{
try
{
Account acc = db.Accounts.Where(ac => ac.email == user).SingleOrDefault();
acc.password = pass;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool CreateProgram(string idAcc, string namepro)
{
try
{
Program pr = new Program();
pr.id = createID();
pr.name = namepro;
pr.idAccount = idAcc;
db.Programs.InsertOnSubmit(pr);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}