public static object SaveMaker(CarsMaker scParam) { object data = new { }; CarsMaker item = new CarsMaker(); item.MakerID = scParam.MakerID; item.MakerNameEn = scParam.MakerNameEn; item.MakerNameAr = scParam.MakerNameAr; item.Priority = 0; item.Active = true; bool status = new MakersManager().SaveCarMaker(item); if ((item.MakerID > 0 && item.MakerNameEn != null) || status) { HttpContext.Current.Cache.Remove("Makers"); data = new { Status = true, Message = Resources.AdminResources_ar.SuccessSave }; } else { data = new { Status = false, Message = Resources.AdminResources_ar.ErrorSave } }; return(data); } #endregion }
public static void FillMakers(DropDownList ddlMakers) { var result = new MakersManager().GetMakers(); ddlMakers.DataSource = result; ddlMakers.DataValueField = "MakerID"; ddlMakers.DataTextField = "MakerNameEn"; ddlMakers.DataBind(); ddlMakers.Items.Insert(0, ""); }
public static void FillMarkers(DropDownList ddlmaker_id, DropDownList ddlYear) { var result = new MakersManager().GetMakers(); if (result != null) { ddlmaker_id.DataSource = result; ddlmaker_id.DataTextField = "MakerNameEn"; ddlmaker_id.DataValueField = "MakerID"; ddlmaker_id.DataBind(); ddlmaker_id.Items.Insert(0, "-----اختر-----"); } // Fill year int _count = DateTime.UtcNow.Year + 2 - startYear; var yearsList = Enumerable.Range(startYear, _count).ToList(); ddlYear.DataSource = yearsList; ddlYear.DataBind(); ddlYear.Items.Insert(0, "-----اختر-----"); }
public static object GetMakers() { 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 <CarsMaker_SelectRowResult> categoryList = new List <CarsMaker_SelectRowResult>(); IEnumerable <CarsMaker_SelectRowResult> filtereMakers; if (HttpContext.Current.Cache["Makers"] == null) { categoryList = new MakersManager().GetCarMakers(""); HttpContext.Current.Cache.Insert("Makers", categoryList, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10)); } else { categoryList = HttpContext.Current.Cache["Makers"] as List <CarsMaker_SelectRowResult>; } // check for search param if (!String.IsNullOrEmpty(param.sSearch)) { filtereMakers = categoryList.Where(c => c.MakerNameEn.ToLower().Contains(param.sSearch.ToLower()) || c.MakerNameAr.ToLower().Contains(param.sSearch.ToLower()) || c.MakerID.ToString().Contains(param.sSearch.ToLower())); } else { filtereMakers = categoryList; } // handle asc and desc operation Func <CarsMaker_SelectRowResult, string> orderingFunction = (c => sortColumnIndex == 1 ? c.MakerNameEn : sortColumnIndex == 2 ? c.MakerNameAr : c.MakerID.ToString()); if (sortDirection == "asc") { filtereMakers = filtereMakers.OrderBy(orderingFunction); } else { filtereMakers = filtereMakers.OrderByDescending(orderingFunction); } //paginate our result var result = filtereMakers.Select(c => new { MakerID = c.MakerID, MakerNameEn = c.MakerNameEn, MakerNameAr = c.MakerNameAr }).Skip(param.iDisplayStart).Take(param.iDisplayLength); // Our last var data = new { sEcho = param.sEcho, iTotalRecords = categoryList.Count(), iTotalDisplayRecords = filtereMakers.Count(), aaData = result }; return(data); }