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