public ActionResult PartnersSpec_remove(string id) //// { var parameters = AjaxModel.GetAjaxParameters(HttpContext); var mng = new PartnersManager(); try { if (mng.GetPartnersSpec(int.Parse(id)).ps_specsPartners.Count > 0) { return(Json(new { result = false, mng = "Статус связан с партнером, сначало требуется снять данный статус со всех партнеров" }, JsonRequestBehavior.AllowGet)); } else { mng.DeletePartnersSpec(int.Parse(id)); return(Json(new { result = true, mng = "Оперция успешна" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { RDL.Debug.LogError(ex); return(Json(new { result = false, mng = "Ошибка" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { var mng = new PartnersManager(); ViewBag.statusName = mng.GetPartnerStatuses(); ViewBag.specsName = mng.GetPartnersSpec(); return(View()); }
public ActionResult PartnersSpec_getItems() { var parameters = AjaxModel.GetParameters(HttpContext); var mng = new PartnersManager(); var items = mng.GetPartnersSpec(); var res = items.Select(item => new ps_statuses { id = item.id, name = item.name, }).AsQueryable(); var sorts = parameters.sort.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); var directions = parameters.direction.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); var sort1 = sorts.Length > 0 ? sorts[0] : ""; var direction1 = directions.Length > 0 ? directions[0] : ""; switch (sort1) { case "name": if (direction1 == "up") { res = res.OrderBy(x => x.name); } else { res = res.OrderByDescending(x => x.name); } break; default: if (direction1 == "up") { res = res.OrderBy(x => x.name); } else { res = res.OrderByDescending(x => x.name); } break; } var total = res.Count(); var res2 = res.Skip(parameters.pageSize * (parameters.page - 1)).Take(parameters.pageSize).ToList(); return(Json(new { items = res2.Select(x => new { x.id, x.name, }), total = items.Count }, JsonRequestBehavior.AllowGet)); }
public ActionResult Partners_getItems() { var parameters = AjaxModel.GetParameters(HttpContext); var mng = new PartnersManager(); var rep = new CoreRepository(); var p = new DynamicParameters(); var specialization = mng.GetPartnersSpec(); List <int?> statusIDs = new List <int?>(); List <int?> specsIDs = new List <int?>(); if (parameters.filter != null && parameters.filter.Count > 0) { p.Add("text", parameters.filter.ContainsKey("text") ? parameters.filter["text"].ToString().Trim() : string.Empty); if (parameters.filter.ContainsKey("statusIDs")) { statusIDs = parameters.filter["statusIDs"].ToString() != string.Empty ? parameters.filter["statusIDs"].ToString().Split(',').Select(x => (int?)RDL.Convert.StrToInt(x.ToString(), 0)).ToList() : null; } if (parameters.filter.ContainsKey("specIDs")) { specsIDs = parameters.filter["specIDs"].ToString() != string.Empty ? parameters.filter["specIDs"].ToString().Split(',').Select(x => (int?)RDL.Convert.StrToInt(x, 0)).ToList() : null; } } string[] sorts = parameters.sort.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); string sort1 = sorts.Length > 0 ? sorts[0] : ""; string[] directions = parameters.direction.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); string direction1 = directions.Length > 0 ? directions[0] : ""; if (specsIDs != null) { p.Add("specsIDs", String.Join(",", specsIDs)); } else { p.Add("specsIDs", String.Join(",", string.Empty)); } if (statusIDs != null) { p.Add("statusIDs", String.Join(",", statusIDs)); } else { p.Add("statusIDs", String.Join(",", string.Empty)); } p.Add("sort1", sort1); p.Add("direction1", direction1); p.Add("page", parameters.page); p.Add("pageSize", parameters.pageSize); p.Add("total", dbType: DbType.Int32, direction: ParameterDirection.Output); var items = rep.GetSQLData <dynamic>("[GetPartners]", p, CommandType.StoredProcedure); var total = p.Get <object>("total"); var res = new List <object>(); foreach (var group in (items as List <dynamic>).GroupBy(x => x.partnerID)) { var partner = group.FirstOrDefault(); var specs = string.Empty; foreach (var item in specialization) { specs += string.Format("<input type='checkbox' class='specialization' " + (group.FirstOrDefault(x => (int)x.specsID == item.id) != null ? "checked": string.Empty) + " specID='" + item.id + "' id='spec" + item.id + "' /><label for='spec" + item.id + "'>{0}</label><br />", item.name); } res.Add(new { partnerID = group.Key, partner.fio, partner.statusName, partner.url, partner.desc, partner.experience, partner.technologies, partner.conditions, specs = specs }); } var json = JsonConvert.SerializeObject(new { items = res, total = res.Count }); return(Content(json, "application/json")); }