public void Put(int id, [FromBody] GIANGVIEN GIANGVIEN)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.GIANGVIENs.SingleOrDefault(x => x.MaGV == id);
if (s != null)
{
s.MaGV = GIANGVIEN.MaGV;
s.MaBM = GIANGVIEN.MaBM;
s.TenGV = GIANGVIEN.TenGV;
s.ChucVu = GIANGVIEN.ChucVu;
s.NgaySinh = GIANGVIEN.NgaySinh;
s.Email = GIANGVIEN.Email;
s.GioiTinh = GIANGVIEN.GioiTinh;
s.SDT = GIANGVIEN.SDT;
s.DiaChi = GIANGVIEN.DiaChi;
s.MonHocPhuTrach = GIANGVIEN.MonHocPhuTrach;
s.TrinhDoHocVan = GIANGVIEN.TrinhDoHocVan;
db.SaveChanges();
}
else
{
}
}
}
public List <GIANGVIEN> Get()
{
using (QLGVEntities db = new QLGVEntities())
{
return(db.GIANGVIENs.ToList());
}
}
// POST: api/LichLamViec
public void Post([FromBody] LICHLAMVIEC lICHLAMVIEC)
{
using (QLGVEntities db = new QLGVEntities())
{
db.LICHLAMVIECs.Add(lICHLAMVIEC);
db.SaveChanges();
}
}
// POST: api/BoMonTrungTam
public void Post([FromBody] BOMONTRUNGTAM bOMONTRUNGTAM)
{
using (QLGVEntities db = new QLGVEntities())
{
db.BOMONTRUNGTAMs.Add(bOMONTRUNGTAM);
db.SaveChanges();
}
}
public HttpResponseMessage DemGVwhere(string address)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.GIANGVIENs.Where(x => x.DiaChi.ToLower().IndexOf(address.ToLower()) >= 0).Count();
return(Request.CreateResponse(HttpStatusCode.OK, s));
}
}
public void Delete(int id)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.GIANGVIENs.SingleOrDefault(x => x.MaGV == id);
db.GIANGVIENs.Remove(s);
db.SaveChanges();
}
}
public HttpResponseMessage groupby(int idBM)
{
using (QLGVEntities db = new QLGVEntities())
{
var groupedCustomerList = db.GIANGVIENs
.GroupBy(u => u.MaBM)
.Select(grp => grp.ToList().Where(x => x.MaBM == idBM))
.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, groupedCustomerList));
}
}
// DELETE: api/BoMonTrungTam/5
public void Delete(int id)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.BOMONTRUNGTAMs.SingleOrDefault(x => x.MaBm == id);
if (s != null)
{
db.BOMONTRUNGTAMs.Remove(s);
db.SaveChanges();
}
}
}
public IEnumerable <GIANGVIEN> Get(int id)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.GIANGVIENs.Where(x => x.MaGV == id);
if (s != null)
{
return(s.ToList());
}
else
{
return(null);
}
}
}
public HttpResponseMessage DemGV(int idBM)
{
using (QLGVEntities db = new QLGVEntities())
{
var gv = db.GIANGVIENs.Where(x => x.MaBM == idBM).Count();
//var bm = db.BOMONTRUNGTAMs.Where(x => x.MaBm == idBM).Select(x => x.TenBM);
//var bmm = from s in db.BOMONTRUNGTAMs
// where s.MaBm == idBM
// select new
// {
// s.TenBM
// };
return(Request.CreateResponse(HttpStatusCode.OK, "Bộ môn " + idBM + " có " + db.GIANGVIENs.Count() + " giảng viên"));
}
}
// GET: api/BoMonTrungTam/5
public IEnumerable <BOMONTRUNGTAM> Get(int id)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.BOMONTRUNGTAMs.Where(x => x.MaBm == id);
if (s != null)
{
return(s.ToList());
}
else
{
return(null);
}
}
}
public List <GIANGVIEN> SearchAddress(string address)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.GIANGVIENs.Where(x => x.DiaChi.ToLower().IndexOf(address.ToLower()) >= 0);
if (s != null)
{
return(s.ToList());
}
else
{
return(null);
}
}
}
public List <GIANGVIEN> SearchGender(string gioitinh)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.GIANGVIENs.Where(x => x.GioiTinh.ToLower().IndexOf(gioitinh.ToLower()) >= 0);
if (s != null)
{
return(s.ToList());
}
else
{
return(null);
}
}
}
public IEnumerable <GIANGVIEN> SearchName(string name)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.GIANGVIENs.Where(x => x.TenGV.ToLower().IndexOf(name.ToLower()) >= 0);
if (s != null)
{
return(s.ToList());
}
else
{
return(null);
}
}
}
public async Task <HttpResponseMessage> Post([FromBody] GIANGVIEN GIANGVIEN)
{
try
{
using (QLGVEntities db = new QLGVEntities())
{
db.GIANGVIENs.Add(GIANGVIEN);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage joinTable()
{
using (QLGVEntities db = new QLGVEntities())
{
var rs = from gv in db.GIANGVIENs
join bm in db.BOMONTRUNGTAMs
on gv.MaBM equals bm.MaBm
select new
{
gv.TenGV,
gv.MaGV,
gv.ChucVu,
gv.DiaChi,
bm.MaBm,
bm.TenBM
};
return(Request.CreateResponse(HttpStatusCode.OK, rs.ToList()));
}
}
// PUT: api/BoMonTrungTam/5
public void Put(int id, [FromBody] BOMONTRUNGTAM bOMONTRUNGTAM)
{
using (QLGVEntities db = new QLGVEntities())
{
var s = db.BOMONTRUNGTAMs.SingleOrDefault(x => x.MaBm == id);
if (s != null)
{
s.MaBm = bOMONTRUNGTAM.MaBm;
s.TenBM = bOMONTRUNGTAM.TenBM;
s.DiaChi = bOMONTRUNGTAM.DiaChi;
s.Fax = bOMONTRUNGTAM.Fax;
s.SDT = bOMONTRUNGTAM.SDT;
s.Email = bOMONTRUNGTAM.Email;
db.SaveChanges();
}
else
{
}
}
}
// GET: api/LichLamViec
public IEnumerable <LICHLAMVIEC> Get()
{
QLGVEntities db = new QLGVEntities();
return(db.LICHLAMVIECs);
}
// GET: api/BoMonTrungTam
public IEnumerable <BOMONTRUNGTAM> Get()
{
QLGVEntities db = new QLGVEntities();
return(db.BOMONTRUNGTAMs);
}
