public List <SearchAdvancePackageResultVM> SearchAdvancePackage(SearchAdvancePackageParametersVM model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter {
                    ParameterName = "@Name", Value = model.Name
                },
                new SqlParameter {
                    ParameterName = "@Description", Value = model.Description
                },
                new SqlParameter {
                    ParameterName = "@Price", Value = model.Price
                },
                new SqlParameter {
                    ParameterName = "@CalculationRatioId", Value = model.CalculationRatioId
                }
            };

            var dt = DALHelper.GetDataTableWithExtendedTimeOut("SearchAdvancePackage", parameters);

            var packages = new List <SearchAdvancePackageResultVM>();

            packages = DALHelper.CreateListFromTable <SearchAdvancePackageResultVM>(dt);

            return(packages);
        }
Exemple #2
0
        public ActionResult SearchAdvancePackage(SearchAdvancePackageParametersVM model)
        {
            try
            {
                var packages = packageRepository.SearchAdvancePackage(model);

                return(Json(new
                {
                    IsSuccess = true,
                    data = packages
                }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception e)
            {
                Utility.Utility.LogError(e, "SearchAdvancePackage");
                return(Json(new { IsSuccess = false, errorMessage = e.Message }));
            }
        }