public int update(string mahv, string makt, string malop, int maphong, DateTime ngaythi, int diemthi, int ketqua) { try { using (QLTTEntities qltt = new QLTTEntities()) { THI t = qltt.THIs .Where(p => p.MAHV == mahv) .Where(p => p.MAKT == makt) .Where(p => p.MALOP == malop) .Where(p => p.MAPHONG == maphong) .FirstOrDefault(); if (t != null) { t.NGAYTHI = ngaythi; t.DIEMTHI = diemthi; t.KETQUA = ketqua; qltt.SaveChanges(); return(1); } return(0); } } catch { return(0); } }
public int insert(string mahv, string makt, string malop, int maphong, DateTime ngaythi, int diemthi, int ketqua) { try { using (QLTTEntities qltt = new QLTTEntities()) { THI t = new THI() { MAHV = mahv, MAKT = makt, MALOP = malop, MAPHONG = maphong, NGAYTHI = ngaythi, DIEMTHI = diemthi, KETQUA = ketqua }; qltt.THIs.Add(t); qltt.SaveChanges(); return(1); } } catch { return(0); } }
private void LuuKQ() { THI kq = new THI(); kq.MaDeThi = int.Parse(cb_dethi.SelectedValue.ToString()); kq.MaHocVien = tb_id.Text; kq.MaLopHoc = cb_lop.SelectedValue.ToString(); kq.KetQua = diem; kq.NgayThi = DateTime.Parse(ngaythi); data.THIs.InsertOnSubmit(kq); data.SubmitChanges(); }
public int deleteMaHV(string code) { using (QLTTEntities qltt = new QLTTEntities()) { THI t = qltt.THIs.Where(p => p.MAHV == code).FirstOrDefault(); if (t != null) { qltt.THIs.Remove(t); qltt.SaveChanges(); return(1); } } return(0); }
public int delete(string mahv, string makt, string malop, int maphong) { using (QLTTEntities qltt = new QLTTEntities()) { THI t = qltt.THIs.Where(p => p.MAHV == mahv) .Where(p => p.MAKT == makt) .Where(p => p.MALOP == malop) .Where(p => p.MAPHONG == maphong) .FirstOrDefault(); if (t != null) { qltt.THIs.Remove(t); qltt.SaveChanges(); return(1); } } return(0); }
public DataTable get(string code) { using (QLTTEntities qltt = new QLTTEntities()) { THI t = qltt.THIs.Where(p => p.MAKT == code).FirstOrDefault(); if (t != null) { DataTable rtnTable = new DataTable(); rtnTable.Columns.Add("MAHV", typeof(string)); rtnTable.Columns.Add("MAKT", typeof(string)); rtnTable.Columns.Add("MALOP", typeof(string)); rtnTable.Columns.Add("MAPHONG", typeof(int)); rtnTable.Columns.Add("NGAYTHI", typeof(DateTime)); rtnTable.Columns.Add("DIEMTHI", typeof(int)); rtnTable.Columns.Add("KETQUA", typeof(int)); rtnTable.Rows.Add(t.MAHV, t.MAKT, t.MALOP, t.MAPHONG, t.NGAYTHI, t.DIEMTHI, t.KETQUA); return(rtnTable); } } return(null); }
// Use this for initialization void Start() { cName.text = character._characterName; race.text = character._characterRace.ToString(); HP.text = "" + character.GetCurrentHealth() + " / " + character.GetMaxHealth(); STR = character.GetAbilityScore(AbilityID.Strength); DEX = character.GetAbilityScore(AbilityID.Dexterity); CON = character.GetAbilityScore(AbilityID.Constitution); INT = character.GetAbilityScore(AbilityID.Intelligence); WIS = character.GetAbilityScore(AbilityID.Wisdom); CHA = character.GetAbilityScore(AbilityID.Charisma); ATH = character.GetSkill(SkillID.Athletics); ACR = character.GetSkill(SkillID.Acrobatics); STE = character.GetSkill(SkillID.Stealth); THI = character.GetSkill(SkillID.Thievery); END = character.GetSkill(SkillID.Endurance); ARC = character.GetSkill(SkillID.Arcana); HIS = character.GetSkill(SkillID.History); REL = character.GetSkill(SkillID.Religion); DUN = character.GetSkill(SkillID.Dungeoneering); HEA = character.GetSkill(SkillID.Heal); INS = character.GetSkill(SkillID.Insight); NAT = character.GetSkill(SkillID.Nature); PER = character.GetSkill(SkillID.Perception); BLU = character.GetSkill(SkillID.Bluff); DIP = character.GetSkill(SkillID.Diplomacy); INTI = character.GetSkill(SkillID.Intimidate); STRE = character.GetSkill(SkillID.Streetwise); tSTR.text = STR + " +" + character.GetModifier(AbilityID.Strength); tDEX.text = DEX + " +" + character.GetModifier(AbilityID.Dexterity); tCON.text = CON + " +" + character.GetModifier(AbilityID.Constitution); tINT.text = INT + " +" + character.GetModifier(AbilityID.Intelligence); tWIS.text = WIS + " +" + character.GetModifier(AbilityID.Wisdom); tCHA.text = CHA + " +" + character.GetModifier(AbilityID.Charisma); tAC.text = character.GetDefence(DefenceID.ArmorClass).ToString(); tFO.text = character.GetDefence(DefenceID.Fortitude).ToString(); tRE.text = character.GetDefence(DefenceID.Reflex).ToString(); tWI.text = character.GetDefence(DefenceID.Will).ToString(); tATH.text = ATH.ToString(); tACR.text = ACR.ToString(); tSTE.text = STE.ToString(); tTHI.text = THI.ToString(); tEND.text = END.ToString(); tARC.text = ARC.ToString(); tHIS.text = HIS.ToString(); tREL.text = REL.ToString(); tDUN.text = DUN.ToString(); tHEA.text = HEA.ToString(); tINS.text = INS.ToString(); tNAT.text = NAT.ToString(); tPER.text = PER.ToString(); tBLU.text = BLU.ToString(); tDIP.text = DIP.ToString(); tINTI.text = INTI.ToString(); tSTRE.text = STRE.ToString(); }