public bool ChangeStatus(long id) { var nv = db.tbl_TinTuc.Find(id); nv.Active = !nv.Active; db.SaveChanges(); return(nv.Active); }
public JsonResult SaveData(string strEmployee) { JavaScriptSerializer serializer = new JavaScriptSerializer(); tbl_NhanVien employee = serializer.Deserialize <tbl_NhanVien>(strEmployee); bool status = false; string message = string.Empty; //add new employee if id = 0 if (employee.Id == 0) { db.tbl_NhanVien.Add(employee); try { db.SaveChanges(); status = true; } catch (Exception ex) { status = false; message = ex.Message; } } else { //update existing DB //save db var entity = db.tbl_NhanVien.Find(employee.Id); entity.tenNV = employee.tenNV; entity.NgaySinh = employee.NgaySinh; entity.Status = employee.Status; entity.gioitinh = employee.gioitinh; entity.ChucVu = employee.ChucVu; entity.Id_Quyen = employee.Id_Quyen; entity.UserName = employee.UserName; entity.Password = employee.Password; entity.Status = employee.Status; entity.Luong = employee.Luong; try { db.SaveChanges(); status = true; } catch (Exception ex) { status = false; message = ex.Message; } } return(Json(new { status = status, message = message })); }
public long InsertForFacebook(tbl_NguoiDung entity) { var user = db.tbl_NguoiDung.SingleOrDefault(x => x.TaiKhoan == entity.TaiKhoan); if (user == null) { db.tbl_NguoiDung.Add(entity); db.SaveChanges(); return(entity.Id); } else { return(user.Id); } }
public void Update_LuotNghe(long id) { tbl_BaiHat obj = new tbl_BaiHat(); obj = db.tbl_BaiHat.SingleOrDefault(e => e.Id == id); if (obj.LuotNghe == null) { obj.LuotNghe = 1; } else { obj.LuotNghe = obj.LuotNghe + 1; } db.SaveChanges(); }
public long Insert(tbl_Video entity) { db.tbl_Video.Add(entity); db.SaveChanges(); return(entity.Id); }
public long Insert(tbl_NhanVien entity) { db.tbl_NhanVien.Add(entity); db.SaveChanges(); return(entity.Id); }