public AUTHOR Read(int Aid)
{
using (var db = new LibraryDBEntities1())
{
return(db.AUTHORs.Include(a => a.BOOKs).FirstOrDefault(a => a.Aid == Aid));
}
}
static public void save(LibraryDBEntities1 db)
{
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
FileStream fs = File.Open("c:\\error\\ErrorList", FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs);
foreach (var eVError in ex.EntityValidationErrors)
{
foreach (var vError in eVError.ValidationErrors)
{
sw.WriteLine("Property: " + vError.PropertyName + "Error: " + vError.ErrorMessage);
}
}
sw.Close();
sw = null;
}
catch (Exception ex)
{
FileStream fs = File.Open("c:\\error\\ErrorList", FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine("Error: " + ex.Message);
sw.Close();
sw = null;
}
}
public void Delete(BOOK bookObj)
{
using (var db = new LibraryDBEntities1())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
_bookObj = db.BOOKs.Find(bookObj.ISBN);
foreach (var item in _bookObj.AUTHORs.ToList())
{
_bookObj.AUTHORs.Remove(item);
}
db.BOOKs.Remove(_bookObj);
Shared.save(db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
public ViewResult Login()
{
var context = new LibraryDBEntities1();
var model = context.Logins.ToList();
return(View(model));
}
public List <BOOK> List(string searchString)
{
using (var db = new LibraryDBEntities1())
{
var query = db.BOOKs.Where(b => b.Title.Contains(searchString) || b.ISBN.Contains(searchString));
return(query.ToList());
}
}
public List <BOOK> List()
{
using (var db = new LibraryDBEntities1())
{
var query = db.BOOKs.OrderBy(x => x.Title);
return(query.ToList());
}
}
public BOOK Read(string bookISBN)
{
using (var db = new LibraryDBEntities1())
{
db.BOOKs.Load();
return(db.BOOKs.Include(x => x.AUTHORs).ToList().Find(b => b.ISBN == bookISBN));;
}
}
public void Update(AUTHOR authorObj)
{
using (var db = new LibraryDBEntities1())
{
db.AUTHORs.Attach(authorObj);
db.Entry(authorObj).State = EntityState.Modified;
Shared.save(db);
}
}
public List <AUTHOR> List(string searchString)
{
using (var db = new LibraryDBEntities1())
{
db.AUTHORs.Load();
var query = db.AUTHORs.Where(a => a.FirstName.Contains(searchString) || a.LastName.Contains(searchString));
return(query.ToList());
}
}
public List <AUTHOR> List()
{
using (var db = new LibraryDBEntities1())
{
db.AUTHORs.Load();
var query = db.AUTHORs.OrderBy(x => x.Aid);
return(query.ToList());
}
}
public void Update(BOOK bookObj)
{
using (var db = new LibraryDBEntities1())
{
db.BOOKs.Attach(bookObj);
db.Entry(bookObj).State = EntityState.Modified;
Shared.save(db);
}
}
/*
* public void RemoveProjectReference(int depid, int projid)
* {
* using (var db = new dbprojectEntities())
* {
* _departmentObj = db.departments.ToList().Find(d => d.depid == depid);
* if(_departmentObj.projects1.ToList().Exists(x => x.projid == projid)) //Check that there is a row in the intermediate table
* {
* project projectObject = db.projects.ToList().Find(p => p.projid == projid);
* _departmentObj.projects1.Remove(projectObject);
* db.SaveChanges();
* }
* }
* }*/
public void removeBookReference(int aId, string removeISBN)
{
using (var db = new LibraryDBEntities1())
{
_authorObj = db.AUTHORs.Include(x => x.BOOKs).ToList().Find(a => a.Aid == aId);
if (_authorObj.BOOKs.ToList().Exists(b => b.ISBN == removeISBN))
{
BOOK bookObj = db.BOOKs.ToList().Find(b => b.ISBN == removeISBN);
_authorObj.BOOKs.Remove(bookObj);
Shared.save(db);
}
}
}
public ActionResult GetListEmployee(string Load)
{
try
{
//Server Side Parameter
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
//string searchValue = Request["search[value]"]?.Trim() ?? string.Empty;
string searchValue, sortColumnName, sortDirection;
searchValue = Request["search[value]"].Trim() ?? string.Empty;
sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"];
sortDirection = Request["order[0][dir]"];
//chuyển biến dữ liệu kiểu đối tượng
// List<Employee> empList = new List<Employee>();
//ở công ty
//using (LibraryDBEntities db = new LibraryDBEntities())
//Ở nhà
using (LibraryDBEntities1 db = new LibraryDBEntities1())
{
var totalrows = db.Employees.Count();
IQueryable <Employee> data;
var totalrowsafterfiltering = 0;
if (string.IsNullOrEmpty(searchValue))
{
data = db.Employees;
totalrowsafterfiltering = totalrows;
}
else
{
data = db.Employees.
Where(x => x.Name.Contains(searchValue) || x.Position.Contains(searchValue) || x.Office.Contains(searchValue) || x.Age.ToString().Contains(searchValue) || x.Salary.ToString().Contains(searchValue));
totalrowsafterfiltering = data.Count();
}
var employees = data.OrderBy(sortColumnName + " " + sortDirection).Skip(start).Take(length).ToList();
return(Json(new { data = employees, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
Logger.Savefile("" + e);
}
return(Json("0", JsonRequestBehavior.AllowGet));
}
public void Delete(AUTHOR authorObj)
{
using (var db = new LibraryDBEntities1())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
_authorObj = db.AUTHORs.Find(authorObj.Aid);
db.AUTHORs.Remove(_authorObj);
Shared.save(db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
public int Add(AUTHOR authorObj)
{
int newAid = 0;
using (var db = new LibraryDBEntities1())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try {
db.AUTHORs.Load();
newAid = authorObj.Aid = (db.AUTHORs.ToList().Max(x => x.Aid) + 1);
db.AUTHORs.Add(authorObj);
Shared.save(db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
return(newAid);
}
public string Add(BOOK bookObj)
{
string newBookISBN = "";
using (var db = new LibraryDBEntities1())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
db.BOOKs.Load();
newBookISBN = bookObj.ISBN = (db.BOOKs.ToList().Max(b => b.ISBN) + 1);
db.BOOKs.Add(bookObj);
Shared.save(db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
return(newBookISBN);
}
