public List <Tblnhanvien> get_nhanvien_all() { using (sql_NCKHContext db = new sql_NCKHContext()) { return(db.Tblnhanviens.ToList()); } }
public alter edit_nhomtg(int id, [FromBody] Tblnhomtg ntg) { alter result = new alter(); try { using (sql_NCKHContext db = new sql_NCKHContext()) { Tblnhomtg d = db.Tblnhomtgs.SingleOrDefault(x => x.Id == id); if (d == null) { result.ketqua = false; result.thongbao = "Không tồn tại tác giả"; return(result); } if (ntg.Idnv != null) { Tblnhomtg nhomtg = db.Tblnhomtgs.SingleOrDefault(x => x.Iddetai == ntg.Iddetai && x.Idnv == ntg.Idnv && x.Chucvu == ntg.Chucvu); if (nhomtg == null) { d.Idnv = ntg.Idnv; d.Hoten = db.Tblnhanviens.SingleOrDefault(x => x.Id == ntg.Idnv).Hoten; d.Chucvu = ntg.Chucvu; db.SaveChanges(); result.ketqua = true; result.thongbao = "Sửa thành công"; } else { result.ketqua = false; result.thongbao = "Tác giả đã tồn tại trong đề tài!! Không nên để trống họ tên"; } } else { Tblnhomtg nhomtg = db.Tblnhomtgs.SingleOrDefault(x => x.Iddetai == ntg.Iddetai && x.Hoten == ntg.Hoten && x.Chucvu == ntg.Chucvu); if (nhomtg == null) { d.Hoten = ntg.Hoten; d.Chucvu = ntg.Chucvu; db.SaveChanges(); result.ketqua = true; result.thongbao = "Sửa thành công"; } else { result.ketqua = false; result.thongbao = "Tác giả đã tồn tại trong đề tài!! Không nên để trống họ tên"; } } return(result); } } catch (Exception ex) { result.ketqua = false; result.thongbao = ex.Message; return(result); } }
public List <Tblnhanvien> get_nhanvien_all_idnv(int id) { using (sql_NCKHContext db = new sql_NCKHContext()) { return(db.Tblnhanviens.Where(x => x.Id != id).ToList()); } }
public List <Tblloainhiemvu> get_loainhiemvu_all() { using (sql_NCKHContext db = new sql_NCKHContext()) { return(db.Tblloainhiemvus.ToList()); } }
public bool create_nhanvien([FromBody] Tblnhanvien nv) { try { using (sql_NCKHContext db = new sql_NCKHContext()) { if (nv.Hinhanh != null) { var arrData = nv.Hinhanh.Split(';'); if (arrData.Length == 3) { var savePath = $@"assets/images/emloye/{arrData[0]}"; nv.Hinhanh = $"{arrData[0]}"; SaveFileFromBase64String(savePath, arrData[2]); } } db.Tblnhanviens.Add(nv); db.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public List <Tblhoatdongnckh> get_hoatdongnckh_id(int id) { using (sql_NCKHContext db = new sql_NCKHContext()) { return(db.Tblhoatdongnckhs.ToList()); } }
public bool create_tintuc([FromBody] Tbltintuc tt) { try { using (sql_NCKHContext db = new sql_NCKHContext()) { if (tt.Hinhanh != null) { var arrData = tt.Hinhanh.Split(';'); if (arrData.Length == 3) { var savePath = $@"assets/images/news/{arrData[0]}"; tt.Hinhanh = $"{arrData[0]}"; SaveFileFromBase64String(savePath, arrData[2]); } } tt.Luotem = 0; db.Tbltintucs.Add(tt); db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public datatable <User> get_user_pagesize(int pagesize, int pageindex, string search) { datatable <User> dv = new datatable <User>(); List <User> ds = new List <User>(); int role_ = 0; using (sql_NCKHContext db = new sql_NCKHContext()) { int index = (pageindex - 1) * pagesize; if (!string.IsNullOrEmpty(search)) { if (search.ToUpper() == "CÁN BỘ") { role_ = 3; } if (search.ToUpper() == "ADMIN") { role_ = 1; } if (search.ToUpper() == "NHÂN VIÊN") { role_ = 2; } ds = db.Users.Where(x => x.Taikhoan.IndexOf(search) >= 0 || x.Idrole == role_).Skip(index).Take(pagesize).ToList(); dv.total = db.Users.Where(x => x.Taikhoan.IndexOf(search) >= 0 || x.Idrole == role_).Count(); } else { ds = db.Users.Skip(index).Take(pagesize).ToList(); dv.total = db.Users.Count(); } dv.result = ds; } return(dv); }
public bool create_user([FromBody] User us) { try { if (us.Hinhanh != null) { var arrData = us.Hinhanh.Split(';'); if (arrData.Length == 3) { var savePath = $@"assets/images/user/{arrData[0]}"; us.Hinhanh = $"{arrData[0]}"; SaveFileFromBase64String(savePath, arrData[2]); } } using (sql_NCKHContext db = new sql_NCKHContext()) { us.Trangthai = 1; db.Users.Add(us); db.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public nguoidung get_user_login(string username, string password) { try { nguoidung nd = new nguoidung(); using (sql_NCKHContext db = new sql_NCKHContext()) { nguoidung user = db.Users.Join(db.Roles, u => u.Idrole, r => r.Id, (u, r) => new nguoidung { Id = u.Id, Taikhoan = u.Taikhoan, Matkhau = u.Matkhau, Token = u.Token, Role = r.Id, Hinhanh = u.Hinhanh, Idnv = u.Idnhanvien }).SingleOrDefault(x => x.Taikhoan.IndexOf(username) >= 0 && x.Matkhau.IndexOf(password) >= 0); return(user); } } catch (Exception) { return(null); } }
public bool edit_congtac(int id, [FromBody] Tblcongtac dv) { try { using (sql_NCKHContext db = new sql_NCKHContext()) { Tblcongtac d = db.Tblcongtacs.SingleOrDefault(x => x.Id == id); if (string.IsNullOrEmpty(d.ToString())) { return(false); } d.Noict = dv.Noict; d.Ngaybad = dv.Ngaybad; d.Ngaykt = dv.Ngaykt; d.Chucvu = dv.Chucvu; d.Chucdanh = dv.Chucdanh; db.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public bool create_hoso([FromBody] Tblhoso dv) { try { using (sql_NCKHContext db = new sql_NCKHContext()) { if (dv.Minhchung != null) { var arrData = dv.Minhchung.Split(';'); if (arrData.Length == 3) { var savePath = $@"assets/file/{arrData[0]}"; dv.Minhchung = $"{arrData[0]}"; SaveFileFromBase64String(savePath, arrData[2]); } } db.Tblhosos.Add(dv); db.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public DateTime tinhthoigiannt(Tbldetai dt, DateTime tg) { double? c = 0; double? n = 0; double? s = 1; double? d = 0; DateTime a = new DateTime(); using (sql_NCKHContext db = new sql_NCKHContext()) { if (!string.IsNullOrEmpty(dt.Thoigiankt.ToString())) { c = db.Tblloainhiemvus.SingleOrDefault(x => x.Id == dt.Idloainv).C; n = Convert.ToDateTime(dt.Thoigiankt).Year - tg.Year; s = 900 * c * n; s = s + db.Tblhoatdongnckhs.SingleOrDefault(x => x.Id == dt.Idhdnckh).Dinhmuc; List <Tblsohuudetai> ds = db.Tblsohuudetais.Where(x => x.Iddetai == dt.Id).ToList(); foreach (Tblsohuudetai ss in ds) { s = s + db.Tblsohuus.SingleOrDefault(x => x.Id == ss.Idsohuu).Dm; } if (float.TryParse(s.ToString(), out float x)) { string[] b = s.ToString().Split('.'); int m = int.Parse(b[0]); d = (s - m) * 60; s = m; } TimeSpan span = new TimeSpan(Convert.ToInt32(s), Convert.ToInt32(d), 0); } } return(a); }
public List <Tbllinhvuc> get_linhvuc_all() { using (sql_NCKHContext db = new sql_NCKHContext()) { return(db.Tbllinhvucs.ToList()); } }
public Tblsohuudetai get_sohuudetai_id(int id) { Tblsohuudetai dv = new Tblsohuudetai(); using (sql_NCKHContext db = new sql_NCKHContext()) { dv = db.Tblsohuudetais.SingleOrDefault(x => x.Id == id); } return dv; }
public Tbllylich get_lylich_id(int id) { Tbllylich ll = new Tbllylich(); using (sql_NCKHContext db = new sql_NCKHContext()) { ll = db.Tbllyliches.SingleOrDefault(x => x.Id == id); } return(ll); }
public Tbllinhvuc get_linhvuc_id(int id) { Tbllinhvuc dv = new Tbllinhvuc(); using (sql_NCKHContext db = new sql_NCKHContext()) { dv = db.Tbllinhvucs.SingleOrDefault(x => x.Id == id); } return(dv); }
public Tblhoso get_hoso_id(int id) { Tblhoso dv = new Tblhoso(); using (sql_NCKHContext db = new sql_NCKHContext()) { dv = db.Tblhosos.SingleOrDefault(x => x.Id == id); } return(dv); }
public List <Tblphanhoi> get_phanhoi_pagesize(int iddetai) { datatable <Tblphanhoi> dv = new datatable <Tblphanhoi>(); List <Tblphanhoi> ds = new List <Tblphanhoi>(); using (sql_NCKHContext db = new sql_NCKHContext()) { return(db.Tblphanhois.Where(x => x.Iddetai == iddetai).ToList()); } }
public List <Tblhoso> get_hoso_iddetai(int iddetai) { datatable <Tblhoso> dv = new datatable <Tblhoso>(); List <Tblhoso> ds = new List <Tblhoso>(); using (sql_NCKHContext db = new sql_NCKHContext()) { return(db.Tblhosos.Where(x => x.Iddetai == iddetai).ToList()); } }
public List <Tblsohuu> get_sohuu_all() { List <Tblsohuu> ds = new List <Tblsohuu>(); using (sql_NCKHContext db = new sql_NCKHContext()) { ds = db.Tblsohuus.ToList(); } return(ds); }
public Tblsohuu get_sohuu_id(int id) { Tblsohuu sh = new Tblsohuu(); using (sql_NCKHContext db = new sql_NCKHContext()) { sh = db.Tblsohuus.SingleOrDefault(x => x.Id == id); } return(sh); }
public Tbldonvi get_donvi_id(int id) { Tbldonvi dv = new Tbldonvi(); using (sql_NCKHContext db = new sql_NCKHContext()) { dv = db.Tbldonvis.SingleOrDefault(x => x.Id == id); } return(dv); }
public Tbltintuc get_tintuc_id(int id) { Tbltintuc ltt = new Tbltintuc(); using (sql_NCKHContext db = new sql_NCKHContext()) { ltt = db.Tbltintucs.SingleOrDefault(x => x.Id == id); } return(ltt); }
public List <Tblloaitt> get_loaitintuc_all() { List <Tblloaitt> ds = new List <Tblloaitt>(); using (sql_NCKHContext db = new sql_NCKHContext()) { ds = db.Tblloaitts.ToList(); } return(ds); }
public List <Tblboiduong> get_boiduongc_idnv(int idnv) { List <Tblboiduong> ds = new List <Tblboiduong>(); using (sql_NCKHContext db = new sql_NCKHContext()) { ds = db.Tblboiduongs.Where(x => x.Idnv == idnv).ToList(); } return(ds); }
public Tblphongban get_phongban_id(int id) { Tblphongban dv = new Tblphongban(); using (sql_NCKHContext db = new sql_NCKHContext()) { dv = db.Tblphongbans.SingleOrDefault(x => x.Id == id); } return(dv); }
public Tblloaitt get_loaitintuc_id(int id) { Tblloaitt ltt = new Tblloaitt(); using (sql_NCKHContext db = new sql_NCKHContext()) { ltt = db.Tblloaitts.SingleOrDefault(x => x.Id == id); } return(ltt); }
public Tblloainhiemvu get_loainhiemvu_id(int id) { Tblloainhiemvu dv = new Tblloainhiemvu(); using (sql_NCKHContext db = new sql_NCKHContext()) { dv = db.Tblloainhiemvus.SingleOrDefault(x => x.Id == id); } return(dv); }
public User get_user_id(int id) { User dv = new User(); using (sql_NCKHContext db = new sql_NCKHContext()) { dv = db.Users.SingleOrDefault(x => x.Id == id); } return(dv); }