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"));
}
