public static object SaveExchangeCompany(ExchangeCompany scParam) { object data = new { }; ExchangeCompany item = new ExchangeCompany(); item.ExchangeCompanyID = scParam.ExchangeCompanyID; item.ExchangeCompanyNameEn = scParam.ExchangeCompanyNameEn; item.ExchangeCompanyNameAr = scParam.ExchangeCompanyNameAr; item.Rate = scParam.Rate; bool status = new ExchangeCompaniesManager().SaveExchangeCompany(item); if ((item.ExchangeCompanyNameEn != null && item.ExchangeCompanyNameAr != null) || status) { //HttpContext.Current.Cache.Remove("ExchangeCompanies"); data = new { Status = true, Message = Resources.AdminResources_ar.SuccessSave }; } else { data = new { Status = false, Message = Resources.AdminResources_ar.ErrorSave } }; return(data); } #endregion }
private void ShowExchangeCompanyInformation(int Id) { var result = new ExchangeCompaniesManager().GetCompanyDetails(Id); if (result != null) { //hfID.Value = result.ExchangeCompanyID.ToString(); txtEmail.Text = result.ExchangeCompanyEmail; txtNameS.Text = result.ExchangeCompanyName; txtPhone.Text = result.ExchangeCompanyPhone; txtPriority.Text = result.Priority.ToString(); txtShortdesc.Text = result.ExchangeCompanyDesc; cbActive.Checked = (bool)result.Active; } }
public static object GetExchangeCompanies() { jQueryDataTableParamModel param = new jQueryDataTableParamModel(); HttpContext Context = HttpContext.Current; param.sEcho = String.IsNullOrEmpty(Context.Request["sEcho"]) ? 0 : Convert.ToInt32(Context.Request["sEcho"]); param.sSearch = String.IsNullOrEmpty(Context.Request["sSearch"]) ? "" : Context.Request["sSearch"]; param.iDisplayStart = String.IsNullOrEmpty(Context.Request["iDisplayStart"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayStart"]); param.iDisplayLength = String.IsNullOrEmpty(Context.Request["iDisplayLength"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayLength"]); var sortColumnIndex = Convert.ToInt32(Context.Request["iSortCol_0"]); var sortDirection = Context.Request["sSortDir_0"]; // asc or desc List <ExchangeCompanies_SelectRowResult> categoryList = new List <ExchangeCompanies_SelectRowResult>(); IEnumerable <ExchangeCompanies_SelectRowResult> filtereExchangeCompanies; categoryList = new ExchangeCompaniesManager().GetExchangeCompanies(""); HttpContext.Current.Cache.Insert("ExchangeCompanies", categoryList, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10)); // check for search param if (!String.IsNullOrEmpty(param.sSearch)) { filtereExchangeCompanies = categoryList.Where(c => c.ExchangeCompanyNameEn.ToLower().Contains(param.sSearch.ToLower()) || c.ExchangeCompanyNameAr.ToLower().Contains(param.sSearch.ToLower())); } else { filtereExchangeCompanies = categoryList; } // handle asc and desc operation Func <ExchangeCompanies_SelectRowResult, string> orderingFunction = (c => sortColumnIndex == 1 ? c.ExchangeCompanyNameEn : sortColumnIndex == 2 ? c.ExchangeCompanyNameAr.ToString() : ""); if (sortDirection == "asc") { filtereExchangeCompanies = filtereExchangeCompanies.OrderBy(orderingFunction); } else { filtereExchangeCompanies = filtereExchangeCompanies.OrderByDescending(orderingFunction); } //paginate our result var result = filtereExchangeCompanies.Select(c => new { ExchangeCompanyID = c.ExchangeCompanyID, ExchangeCompanyNameEn = c.ExchangeCompanyNameEn, ExchangeCompanyNameAr = c.ExchangeCompanyNameAr, Rate = c.Rate }).Skip(param.iDisplayStart).Take(param.iDisplayLength); // Our last var data = new { sEcho = param.sEcho, iTotalRecords = categoryList.Count(), iTotalDisplayRecords = filtereExchangeCompanies.Count(), aaData = result }; return(data); }