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