/// <summary> /// /// </summary> /// <returns></returns> public ActionResult Index() { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["LiteCommerceDB"].ConnectionString; //ICountryDAL dal = new CountryDAL(connectionString); //var data = dal.List(); //ICityDAL dal = new CityDAL(connectionString); //var data = dal.List("USA"); //ISupplierDAL dal = new SupplierDAL(connectionString); //var data = dal.List(1, 10, ""); //ICategoryDAL dal = new CategoryDAL(connectionString); //var data = dal.List(1, 10, ""); //IShipperDAL dal = new ShipperDAL(connectionString); //var data = dal.List(1, 10, ""); //IEmployeeDAL dal = new EmployeeDAL(connectionString); //var data = dal.List(1, 10, ""); //ICustomerDAL dal = new CustomerDAL(connectionString); //var data = dal.List(1, 10, ""); IEmployeeDAL dal = new EmployeeDAL(connectionString); //var data = dal.Get(1); Employee s = new Employee() { EmployeeID = 11, LastName = "Nguyen huu ", FirstName = "Thanh", BirthDate = DateTime.Today, Photo = "k cos", Notes = "hoc dot + nhiet tinh", Email = "*****@*****.**", Password = "******", }; //bool data = dal.Update(s); var data = dal.Count(""); return(Json(data, JsonRequestBehavior.AllowGet)); }
//Test URL: https://localhost:44398/Test/PaginationShipper?page=1&pageSize=10&searchValue= /// <summary> /// Hiển thị danh sách Employee(Nhaan Vien) Tìm kiếm, phân trang /// </summary> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="searchValue"></param> /// <returns></returns> public ActionResult PaginationEmployee(int page, int pageSize, string searchValue) { string connectionString = ConfigurationManager.ConnectionStrings["LiteCommerceDB"].ConnectionString; IEmployeeDAL dal = new EmployeeDAL(connectionString); //var data = dal.List(page, pageSize, searchValue); var data = dal.Count(""); return(Json(data, JsonRequestBehavior.AllowGet)); /* Employee data = new Employee() * { * LastName = "Huynh", * FirstName = "Hoa", * BirthDate = "11/11/1999", * Photo = "abc", * Notes = "deptrai", * Email = "*****@*****.**", * Password = "******" * }; * return Json(dal.Add(data), JsonRequestBehavior.AllowGet);*/ }