public static object SaveClientBuyer(ClientBuyer scParam) { object data = new { }; ClientBuyer item = new ClientBuyer(); item.ClientBuyerID = scParam.ClientBuyerID; item.Active = scParam.Active; item.EndDate = scParam.EndDate; bool status = new ClientBuyersManager().SaveItem(item); if ((item.ClientID > 0 && item.BuyerID > 0) || status) { //HttpContext.Current.Cache.Remove("ClientBuyers"); 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 fillClientBuyersProperties(DropDownList ddlBuyerID, DropDownList ddlClientID) { var result = new ClientBuyersManager().GetClientBuyerProperties(); if (result != null) { ddlClientID.DataSource = result.Clients; ddlClientID.DataValueField = "ClientID"; ddlClientID.DataTextField = "full_name"; ddlClientID.DataBind(); ddlClientID.Items.Insert(0, ""); ddlBuyerID.DataSource = result.Buyers; ddlBuyerID.DataValueField = "BuyerID"; ddlBuyerID.DataTextField = "BuyerName"; ddlBuyerID.DataBind(); ddlBuyerID.Items.Insert(0, ""); } }
public static object GetBuyers() { 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 var clientID = String.IsNullOrEmpty(Context.Request["clientID"]) ? 0 : Convert.ToInt32(Context.Request["clientID"]); List <ClientBuyers_SelectListResult> categoryList = new List <ClientBuyers_SelectListResult>(); IEnumerable <ClientBuyers_SelectListResult> filtereBuyers; categoryList = new ClientBuyersManager().GetClientBuyers(clientID); // check for search param if (!String.IsNullOrEmpty(param.sSearch)) { filtereBuyers = categoryList.Where(c => c.BuyerName.ToLower().Contains(param.sSearch.ToLower()) || c.AuctionName.ToLower().Contains(param.sSearch.ToLower())); } else { filtereBuyers = categoryList; } // handle asc and desc operation Func <ClientBuyers_SelectListResult, string> orderingFunction = (c => sortColumnIndex == 1 ? c.BuyerName : sortColumnIndex == 2 ? c.AuctionName.ToString() : ""); if (sortDirection == "asc") { filtereBuyers = filtereBuyers.OrderBy(orderingFunction); } else { filtereBuyers = filtereBuyers.OrderByDescending(orderingFunction); } //paginate our result var result = filtereBuyers.Select(c => new { ClientBuyerID = c.ClientBuyerID, BuyerID = c.BuyerID, Active = c.Active, ClientID = c.ClientID, BuyerName = c.BuyerName, AuctionName = c.AuctionName, full_name = c.full_name, EndDate = string.Format("{0: MM/d/yyyy}", c.EndDate), StartDate = string.Format("{0: MM/d/yyyy}", c.StartDate) }).Skip(param.iDisplayStart).Take(param.iDisplayLength); // Our last var data = new { sEcho = param.sEcho, iTotalRecords = categoryList.Count(), iTotalDisplayRecords = filtereBuyers.Count(), aaData = result }; return(data); }