public bool capNhatKetQua(int maHV, int maLH, int maKH, float?diemGiuaKy, float?diemCuoiKy, float?diemTB)
{
KetQua ketQua = new KetQua()
{
MaHocVien = maHV,
MaLopHoc = maLH,
MaKhoaHoc = maKH,
DiemGiuaKy = diemGiuaKy,
DiemCuoiKy = diemCuoiKy,
DiemTB = diemTB
};
using (var db = new TTTA_DBEntities())
{
db.Entry(ketQua).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
public bool themKetQua(int maHV, int maLH, int maKH, float?diemGiuaKy, float?diemCuoiKy, float?diemTB)
{
KetQua ketQua = new KetQua()
{
MaHocVien = maHV,
MaLopHoc = maLH,
MaKhoaHoc = maKH,
DiemGiuaKy = diemGiuaKy,
DiemCuoiKy = diemCuoiKy,
DiemTB = diemTB
};
using (var db = new TTTA_DBEntities())
{
db.KetQuas.Add(ketQua);
return(db.SaveChanges() > 0);
}
}
public bool AddOrUpdate(KetQua item, int mode)
{
if (mode == 0)
{
_db.KetQuas.Add(item);
}
else
{
var up = GetByMSSV(item.MSSV);
up.NamHoc = item.NamHoc;
up.MaHK = item.MaHK;
up.TongDiemSV = item.TongDiemSV;
up.TongDiemLT = item.TongDiemLT;
up.TongDiemCVHT = item.TongDiemCVHT;
up.XepLoai = item.XepLoai;
}
return(SaveToDatabase());
}
public bool ThemDiem(string maSV, string maMon, string dgk, string dck, string dtb, bool kq)
{
try
{
QLSVDataContext qlSV = new QLSVDataContext();
KetQua kh = new KetQua();
kh.maSV = maSV;
kh.maMon = maMon;
kh.diemGiuaKi = Convert.ToDouble(dgk);
kh.diemCuoiKi = Convert.ToDouble(dck);
kh.diemTB = Convert.ToDouble(dtb);
kh.ketQua = kq;
qlSV.KetQuas.InsertOnSubmit(kh);
qlSV.KetQuas.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public List <KetQua> LoadKQ(int makq)
{
KetQua kq = thi.KetQuas.Where(t => t.MaKetQua == makq).FirstOrDefault();
if (kq != null)
{
if (kq.DapAnDung >= 16)
{
kq.GhiChu = "ĐẬU";
}
else
{
kq.GhiChu = "RỚT";
}
thi.SubmitChanges();
}
var ketqua = thi.KetQuas.Where(t => t.MaKetQua == makq).ToList <KetQua>();
List <KetQua> kqua = ketqua.ToList <KetQua>();
return(kqua);
}
public void UpdateKQ(int makq, int mand)
{
var dung = from kq in thi.ChiTietKetQuas
where kq.MaKetQua == makq && kq.KetQua == true
select kq;
var sai = from kq in thi.ChiTietKetQuas
where kq.MaKetQua == makq && kq.KetQua == false
select kq;
KetQua ketqua = thi.KetQuas.Where(t => t.MaKetQua == makq).FirstOrDefault();
if (ketqua != null)
{
ketqua.DapAnSai = sai.Count();
ketqua.DapAnDung = dung.Count();
}
DangKi dangki = thi.DangKis.Where(t => t.MaNguoiDung == mand && t.TinhTrang == false).FirstOrDefault();
if (dangki != null)
{
dangki.TinhTrang = true;
}
thi.SubmitChanges();
}
public Boolean Gui()
{
// Chuyen doi du lieu can gui thanh mang byte
// Cu phap gui du lieu nhu sau:
// NguoiGuiID <$> NguoiNhanID <$> NoiDung <EOF>
String duLieuGui = NguoiGuiID.ToString() + "<$>"
+ NguoiNhanID.ToString() + "<$>" + NoiDung + "<EOF>";
byte[] boDem = Encoding.UTF8.GetBytes(duLieuGui);
// Gui du lieu
Socket sk = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
IPAddress ip = IPAddress.Parse(IP);
try
{
sk.Connect(ip, Cong);
if (sk.Connected)
{
sk.Send(boDem);
// Nhan du lieu tra loi
byte[] traLoi = new byte[1024];
int dem = sk.Receive(traLoi);
String tKetQua = Encoding.UTF8.GetString(traLoi, 0, dem);
while (!tKetQua.Contains("<EOF>"))
{
traLoi = new byte[1024];
dem = sk.Receive(traLoi);
tKetQua += Encoding.UTF8.GetString(traLoi, 0, dem);
}
// Cu phap ma Server gui tra cho Client:
// NguoiGuiID <$> NoiDung <EOE> NguoiGuiID <$> NoiDung <EOE> ... <EOF>
tKetQua = tKetQua.Replace("\0", "");
tKetQua = tKetQua.Substring(0, tKetQua.Length - 5);
if (tKetQua.Contains("<EOE>"))
{
// Co nhieu tin nhan
String[] spliterTinNhan = new String[] { "<EOE>" };
foreach (String tinNhan in tKetQua.Split(spliterTinNhan, StringSplitOptions.None))
{
String[] spliter = new String[] { "<$>" };
String nguoiGui = tinNhan.Split(spliter, StringSplitOptions.RemoveEmptyEntries)[0];
String noiDung = tinNhan.Split(spliter, StringSplitOptions.RemoveEmptyEntries)[1];
KetQua.Add(int.Parse(nguoiGui), noiDung);
}
}
else
{
// Co 1 tin nhan: Roi vao 3 truong hop
// 0<$>0<EOF>: Khong co gi dau ma hoi
// 0<$>1<EOF>: Toi da nhan duoc tin nhan va se chuyen cho nguoi nhan khi co the
// NguoiGuiID <$> NoiDung <EOF>: ban co 1 tin nhan
String[] spliter = new String[] { "<$>" };
String nguoiGui = tKetQua.Split(spliter, StringSplitOptions.RemoveEmptyEntries)[0];
String noiDung = tKetQua.Split(spliter, StringSplitOptions.RemoveEmptyEntries)[1];
if (nguoiGui.Equals("0"))
{
if (noiDung.Equals("1"))
{
NoiDung += "(*)"; // Tin nhan da duoc Server xu ly
}
}
else
{
KetQua.Add(int.Parse(nguoiGui), noiDung);
}
}
sk.Disconnect(false);
sk.Dispose();
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public string DocTienBangChuSep(decimal SoTien, string strTail, string seperator)
{
int lan, i;
decimal so;
string KetQua = "", tmp = "";
int[] ViTri = new int[6];
if (SoTien < 0)
{
return("Số tiền âm !");
}
if (SoTien == 0)
{
return("Không đồng !");
}
if (SoTien > 0)
{
so = SoTien;
}
else
{
so = -SoTien;
}
//Kiểm tra số quá lớn
if (SoTien > 8999999999999999)
{
SoTien = 0;
return("");
}
ViTri[5] = (int)(so / 1000000000000000);
so = so - long.Parse(ViTri[5].ToString()) * 1000000000000000;
ViTri[4] = (int)(so / 1000000000000);
so = so - long.Parse(ViTri[4].ToString()) * +1000000000000;
ViTri[3] = (int)(so / 1000000000);
so = so - long.Parse(ViTri[3].ToString()) * 1000000000;
ViTri[2] = (int)(so / 1000000);
ViTri[1] = (int)((so % 1000000) / 1000);
ViTri[0] = (int)(so % 1000);
if (ViTri[5] > 0)
{
lan = 5;
}
else if (ViTri[4] > 0)
{
lan = 4;
}
else if (ViTri[3] > 0)
{
lan = 3;
}
else if (ViTri[2] > 0)
{
lan = 2;
}
else if (ViTri[1] > 0)
{
lan = 1;
}
else
{
lan = 0;
}
for (i = lan; i >= 0; i--)
{
tmp = DocSo3ChuSo(ViTri[i]);
KetQua += tmp;
if (ViTri[i] != 0)
{
KetQua += Tien[i];
}
if ((i > 0) && (!string.IsNullOrEmpty(tmp)))
{
KetQua += seperator; //&& (!string.IsNullOrEmpty(tmp))
}
}
if (KetQua.Substring(KetQua.Length - 1, 1) == seperator)
{
KetQua = KetQua.Substring(0, KetQua.Length - 1);
}
KetQua = KetQua.Trim() + strTail;
return(KetQua.Substring(0, 1).ToUpper() + KetQua.Substring(1));
}
