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