public ServiceResult <DAGIAC> KhoiTao(string chuoiDaGiac)
{
var result = new ServiceResult <DAGIAC>();
string[] M = chuoiDaGiac.Split('|');
//"(2,3)(3,2)(3,4)"
if (M.Length <= 2)
{
result.IsSuccess = false;
result.ErrorMessage = "Da giac khong hop le";
return(result);
}
DAGIAC dg = new DAGIAC();
foreach (string s in M)
{
DIEM a = new DIEM(s);
dg.dsDinh.Add(a);
}
result.IsSuccess = true;
result.Data = dg;
return(result);
}
private void vSaveRegisterCoures(int vCheck)
{
dtoDkHoc = new DANG_KI_HOC();
boDangKiHoc = new BO_DANG_KI_HOC();
dtoDiem = new DIEM();
boDiem = new BO_DIEM();
dtoDkHoc.DKH_Code = txtDKHCode.Text;
dtoDkHoc.DKH_BienLai = txtSoBienLai.Text;
dtoDkHoc.DKH_Diem = null;
dtoDkHoc.DKH_LanThi = null;
dtoDkHoc.DKH_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString());
dtoDkHoc.DKH_HOVID = gHocVienID;
if (vCheck == 1)
{
//Lưu vào bảng đăng kí học
boDangKiHoc.insert(dtoDkHoc);
dtoDiem.DIE_CHCID = int.Parse(lookCcID.GetColumnValue("CHC_ID").ToString());
dtoDiem.DIE_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString());
dtoDiem.DIE_HOVID = gHocVienID;
dtoDiem.DIE_Diem = null;
dtoDiem.DIE_LanThi = 1;
dtoDiem.DIE_NgayNhapDiem = null;
for (int ii = 0; ii < listSubject.ItemCount; ii++)
{
if (listSubject.GetItemChecked(ii))
{
// Luu vao table Diem
dtoDiem.DIE_MONID = int.Parse(listSubject.GetItemValue(ii).ToString());
boDiem.insert(dtoDiem);
}
}
}
}
public static String Chuoi_diem(DIEM M)
{
String kq;
kq = "(" + M.x + "," + M.y + ")";
return(kq);
}
public static String Chuoi(DIEM M)
{
String kq;
kq = "(" + Math.Round(M.x, 2) + "," + Math.Round(M.y, 2) + ")";
return(kq);
}
public double TinhKhoangCachDiem(int x1, int y1, int x2, int y2)
{
var A = new DIEM(x1, y1);
var B = new DIEM(x2, y2);
return(A.KhoangCach2Diem(B));
}
public static String Chuoi_diem(DIEM d)
{
String kq;
kq = "(" + Math.Round(d.x, 2) + "," + Math.Round(d.y, 2) + ")";
return(kq);
}
public static Double Khoang_cach(PHUONG_TRINH_DUONG_THANG D, DIEM I)
{
Double kq;
kq = Math.Abs(D.a * I.x + D.b * I.y + D.c) / (D.a * D.a + D.b * D.b);
return(kq);
}
public static String XuatChuoi(DIEM M)
{
String kq;
kq = "(" + M.x + ChuoiPhanCach + M.y + ")";
return(kq);
}
//Lấy thông tin theo id
public CAUHOI GetCH(DIEM diemClient)
{
DBGameDataContext db = new DBGameDataContext();
int id;
while (true)
{
if (diemClient.IDLoai.Trim().Equals("1"))
{
id = rand(minDe, maxDe);
}
else if (diemClient.IDLoai.Trim().Equals("2"))
{
id = rand(minVua, maxVua);
}
else
{
id = rand(minKho, maxKho);
}
if (hash.Any(x => x.Key == (diemClient.IDUser + id)))
{
continue;
}
hash.Add(diemClient.IDUser + id, diemClient.IDUser);
break;
}
CAUHOI ch = db.CAUHOIs.FirstOrDefault(x => x.IDCH == id && x.IDLoai == diemClient.IDLoai);
return(ch);
}
public string RemoveCH(DIEM diemClient)
{
DBGameDataContext db = new DBGameDataContext();
var chrm = hash.Where(x => x.Value == diemClient.IDUser).ToList(); //Get list câu hỏi của User có ID đó.
foreach (var item in chrm)
{
hash.Remove(item.Key);
}
DIEM diem = db.DIEMs.FirstOrDefault(x => x.IDUser == diemClient.IDUser && x.IDLoai == diemClient.IDLoai);
if (diem == null)
{
diem = new DIEM();
diem.IDUser = diemClient.IDUser;
diem.IDLoai = diemClient.IDLoai;
diem.DIEM1 = diemClient.DIEM1;
db.DIEMs.InsertOnSubmit(diem);
db.SubmitChanges();
}
else if (diem.DIEM1 < diemClient.DIEM1)
{
diem.DIEM1 = diemClient.DIEM1;
db.SubmitChanges();
}
return(diem.DIEM1 + "");
}
public static void ReviewScrore(DT_QL_SV5TOT_5Entities2 db, DIEM diemSV)
{
var hocKy = db.HOCKY_XETDIEM.FirstOrDefault(x => x.MaHocKy == diemSV.MaHocKy);
var tgianXet = db.THOIGIAN_XET.FirstOrDefault(x => x.MaThoiGian == hocKy.MaThoiGianXetDiem);
//db.DIEMs.Add(diemSV);
//Điểm được add vào phải trong thời gian xét
if (tgianXet.TrangThai == true)
{
var sinhVien = db.SINH_VIEN.FirstOrDefault(x => x.Mssv == diemSV.Mssv);
var LoaiDiem = db.LOAI_DIEM.FirstOrDefault(x => x.MaLoaiDiem == diemSV.MaLoaiDiem);
var ListMaHocky = db.HOCKY_XETDIEM
.Where(x => x.MaThoiGianXetDiem == tgianXet.MaThoiGian)
.Select(x => x.MaHocKy).ToList();
var QDdiemToiThieu_Truong = db.QUYDINH_DIEM
.Where(x => x.MaLoaiDiem == diemSV.MaLoaiDiem &&
x.MaDonVi == "HSVT" &&
x.Mathoigian == tgianXet.MaThoiGian)
.FirstOrDefault();
var QDdiemToiThieu_Donvi = db.QUYDINH_DIEM
.Where(x => x.MaLoaiDiem == diemSV.MaLoaiDiem &&
x.MaDonVi == sinhVien.DonVi &&
x.Mathoigian == tgianXet.MaThoiGian)
.FirstOrDefault();
if (LoaiDiem.TenLoaiDiem == "Điểm Kỹ năng mềm")
{
AddTieuChuanDiemKNM(db, diemSV, QDdiemToiThieu_Truong, QDdiemToiThieu_Donvi, tgianXet.MaThoiGian);
db.SaveChanges();
return;
}
//Nếu sinh viên chưa có điểm ở kỳ trước đó thì chỉ cần insert ko cần xét đạt tiêu chuẩn hay ko --> đến khi có điểm của cả 2 kỳ mới xét
if (db.DIEMs.Where(x => x.Mssv == diemSV.Mssv &&
x.MaLoaiDiem == diemSV.MaLoaiDiem && ListMaHocky.Contains((int)x.MaHocKy)).ToList().Count() == 1)
{
var DiemHocKyTruoc = db.DIEMs.Where(x => x.MaLoaiDiem == diemSV.MaLoaiDiem && x.Mssv == diemSV.Mssv)
.Select(x => x.Diem1).FirstOrDefault();
if (LoaiDiem.TenLoaiDiem == "Điểm rèn luyện")
{
AddTieuChuanDiemRenLuyen(db, diemSV, QDdiemToiThieu_Truong, QDdiemToiThieu_Donvi, (int)DiemHocKyTruoc, tgianXet.MaThoiGian);
}
else
{
AddTieuChuanDiemKhac(db, diemSV, QDdiemToiThieu_Truong, QDdiemToiThieu_Donvi, (int)DiemHocKyTruoc, tgianXet.MaThoiGian);
}
}
db.SaveChanges();
}
else
{
throw new Exception("Điểm được thêm phải nằm trong thời gian xét");
}
}
public static DIEM Xac_dinh_trung_diem_2_diem(DIEM M, DIEM N)
{
DIEM kq;
kq.x = (N.x + M.x) / 2;
kq.y = (N.y + M.y) / 2;
return(kq);
}
public ActionResult DeleteConfirmed(int id)
{
DIEM dIEM = db.Diems.Find(id);
db.Diems.Remove(dIEM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Ghi(DIEM p)
{
StreamWriter file = new StreamWriter(filePath);
file.Write($"{p.X},{p.Y}");
file.Close();
}
public bool Ghi(int x, int y)
{
DIEM p = new DIEM(x, y);
var luuTruDIEM = new LT_DIEM();
luuTruDIEM.Ghi(p);
return(true);
}
public static Double Khoang_cach(DIEM M, DIEM N)
{
Double kq;
Double Dx = M.x - N.x;
Double Dy = M.y - N.y;
kq = Math.Sqrt(Dx * Dx + Dy * Dy);
return(kq);
}
public static Double Khoang_cach(DIEM A, DIEM B)
{
Double kq;
Double x_AB = A.x - B.x;
Double y_AB = A.y - B.y;
kq = Math.Sqrt(x_AB * x_AB + y_AB * y_AB);
return(kq);
}
public ActionResult Edit([Bind(Include = "bangdiem,MaHS,MaMon,DiemMieng,DiemMotTiet")] DIEM dIEM)
{
if (ModelState.IsValid)
{
db.Entry(dIEM).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dIEM));
}
public bool KiemTraTinhHopLe(DIEM A, DIEM B, DIEM C)
{
double a, b, c;
a = B.KhoangCach2Diem(C);
b = C.KhoangCach2Diem(A);
c = A.KhoangCach2Diem(B);
return(a + b > c && a + c > b && b + c > a);
}
public ActionResult AddPointStudents(DIEM diem)
{
ADMIN tk = (ADMIN)Session["TaikhoanSV"];
ViewBag.Taikhoan = tk.Name;
ViewBag.MaMH = new SelectList(data.MONHOCs.ToList().OrderBy(n => n.TenMH), "MaMH", "TenMH");
data.DIEMs.InsertOnSubmit(diem);
data.SubmitChanges();
return(RedirectToAction("AddPointStudents"));
}
public void update_LanThi_Into_DIEM(int DIE_MONID,
int DIE_LanThi
)
{
DAL_DIEM daoDiem = new DAL_DIEM();
DIEM diem = new DIEM();
diem.DIE_ID = DIE_MONID;
diem.DIE_LanThi = DIE_LanThi;
daoDiem.update_LanThi_Into_DIEM(diem);
}
public int GetDiem(DIEM usClient)
{
DBGameDataContext db = new DBGameDataContext();
DIEM diem = db.DIEMs.FirstOrDefault(x => x.IDUser.Equals(usClient.IDUser) && x.IDLoai == usClient.IDLoai);
if (diem == null)
{
return(0);
}
return(Int16.Parse(diem.DIEM1.ToString()));
}
public ActionResult Create([Bind(Include = "bangdiem,MaHS,MaMon,DiemMieng,DiemMotTiet")] DIEM dIEM)
{
if (ModelState.IsValid)
{
db.Diems.Add(dIEM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dIEM));
}
public bool Insert(DIEM model)
{
DIEM dbEntry = context.DIEMs.Find(model.ID);
if (dbEntry != null)
{
return(false);
}
context.DIEMs.Add(model);
context.SaveChanges();
return(true);
}
public ActionResult Edit([Bind(Include = "bangdiem,MaHS,MaMon,DiemMieng,DiemMotTiet,Tong")] DIEM dIEM)
{
if (ModelState.IsValid)
{
db.Entry(dIEM).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaHS = new SelectList(db.HOCSINHS, "MaHS", "TenHS", dIEM.MaHS);
ViewBag.MaMon = new SelectList(db.MONHOCS, "MaMon", "TenMon", dIEM.MaMon);
return(View(dIEM));
}
public bool Delete(DIEM model)
{
DIEM dbEntry = context.DIEMs.Find(model.ID);
if (dbEntry == null)
{
return(false);
}
context.DIEMs.Remove(dbEntry);
context.SaveChanges();
return(true);
}
public static Boolean Thang_hang(DIEM M, DIEM N, DIEM P)
{
Boolean kq;
Double x_MN = N.x - M.x;
Double y_MN = N.y - M.y;
Double x_MP = P.x - M.x;
Double y_MP = P.y - M.y;
kq = (x_MN * y_MP - y_MN * x_MP) == 0;
return(kq);
}
public ActionResult Edit([Bind(Include = "MaDiem,DiemTBHK,DiemTK,HocKy,HanhKiem,NamHoc,HocLuc,MaHS")] DIEM diem)
{
var diemdg = db.HOCSINHs.ToList();
SelectList listHS = new SelectList(diemdg, "MaHS", "HoTenHS");
ViewBag.CatagoryHS = listHS;
if (ModelState.IsValid)
{
db.Entry(diem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(diem));
}
public ActionResult Create([Bind(Include = "DiemTBHK,DiemTK,HocKy,HanhKiem,NamHoc,HocLuc,MaHS")] DIEM diem)
{
var diemHS = db.HOCSINHs.ToList();
SelectList listHS = new SelectList(diemHS, "MaHS", "HoTenHS");
ViewBag.CatagoryHS = listHS;
if (ModelState.IsValid)
{
db.DIEMs.Add(diem);
db.SaveChanges();
return(RedirectToAction("index"));
}
return(View(diem));
}
public ActionResult Details(int?ID)
{
if (ID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DIEM diem = db.DIEMs.Find(ID);
if (diem == null)
{
return(HttpNotFound());
}
return(View(diem));
}
