Пример #1
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public ActionResult Index()
        {
            string connectionString = ConfigurationManager.ConnectionStrings["LiteCommerceDB"].ConnectionString;

            //ICountryDAL dal = new DataLayers.SQLServer.CountryDAL(connectionString);
            //var data = dal.List();

            //ICityDAL dal = new DataLayers.SQLServer.CityDAL(connectionString);
            //var data = dal.List("USA");

            Employee employee = new Employee()
            {
                EmployeeID = 11,
                LastName   = "Nhật",
                FirstName  = "Khanh",
                BirthDate  = DateTime.Today,
                Notes      = "Hello",
                Photo      = "Hihi",
                Email      = "*****@*****.**",
            };
            IEmployeeDAL dal  = new DataLayers.SQLServer.EmployeeDAL(connectionString);
            var          data = dal.Add(employee);

            return(Json(data, JsonRequestBehavior.AllowGet));
        }
Пример #2
0
        public ActionResult Pagination(int page, int pageSize, string searchValue)
        {
            string connectionString = ConfigurationManager.ConnectionStrings["LiteCommerceDB"].ConnectionString;

            IEmployeeDAL dal  = new DataLayers.SQLServer.EmployeeDAL(connectionString);
            var          data = dal.List(page, pageSize, searchValue);

            return(Json(data, JsonRequestBehavior.AllowGet));
        }