public JsonResult GetRemainingRows()
{
using (SCellsEntities db = new SCellsEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
return(Json(db.TierMap.Count(d => d.distance == 0) / 2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetRow(string id)
{
id = id.Substring(0, 3);
using (SCellsEntities db = new SCellsEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var sucursalList = db.Section.Where(d => d.name.Substring(0, 3) == id).OrderBy(d => d.name).ToList();
int[] data = new int[sucursalList.Count];
for (int i = 0; i < sucursalList.Count; i++)
{
data[i] = sucursalList[i].idS;
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdatePointsCells(int[] sectionsChosen, double distanceSelections)
{
using (SCellsEntities db = new SCellsEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
for (int i = 0; i < sectionsChosen.Length; i++)
{
double distanceFinal = 0;
for (int j = i + 1; j < sectionsChosen.Length; j++)
{
int predcessor = sectionsChosen[i];
int finalId = sectionsChosen[j];
distanceFinal += distanceSelections;
TierMap sCells = db.TierMap.First(d => d.tierIdStart == predcessor && d.tierIdFinish == finalId);
sCells.distance = distanceFinal;
db.Entry(sCells).State = EntityState.Modified;
db.SaveChanges();
//SectionMap sCells1 = db.SectionMap.First(d => d.sectionIdFinish == sCells.sectionIdStart && d.sectionIdStart == sCells.sectionIdFinish);
//sCells1.distance = distanceFinal;
//db.Entry(sCells1).State = EntityState.Modified;
//db.SaveChanges();
}
}
//for (int i = 0; i < sectionsChosen.Length; i++)
//{
// double distanceFinal = 0;
// for (int j = i + 1; j < sectionsChosen.Length; j++)
// {
// int predcessor = sectionsChosen[i];
// int finalId = sectionsChosen[j];
// distanceFinal += distanceSelections;
// SectionMap sCells = db.SectionMap.First(d => d.sectionIdStart == predcessor && d.sectionIdFinish == finalId);
// sCells.distance = distanceFinal;
// db.Entry(sCells).State = EntityState.Modified;
// db.SaveChanges();
// SectionMap sCells1 = db.SectionMap.First(d => d.sectionIdFinish == sCells.sectionIdStart && d.sectionIdStart == sCells.sectionIdFinish);
// sCells1.distance = distanceFinal;
// db.Entry(sCells1).State = EntityState.Modified;
// db.SaveChanges();
// }
//}
}
logger.Debug("SCells UpdatePointsCells");
return(Json(1, JsonRequestBehavior.AllowGet));
}
bool UpdateDistanceSelections(int id, double distance)
{
using (SCellsEntities db = new SCellsEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
TierMap sCells = db.TierMap.Find(id);
sCells.distance = distance;
db.Entry(sCells).State = EntityState.Modified;
db.SaveChanges();
int ids1 = db.Tier.Find(sCells.tierIdStart).idS;
int ids2 = db.Tier.Find(sCells.tierIdFinish).idS;
bool update = db.Section.Find(ids1).updateTier.Value;
if (update == false)
{
var listUpdate = db.TierMap.Where(a => a.Tier.Section.idS == ids1 && a.Tier1.idS == ids2).ToList();
foreach (var data in listUpdate)
{
data.distance = distance;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
}
listUpdate = db.TierMap.Where(a => a.Tier.Section.idS == ids2 && a.Tier1.idS == ids1).ToList();
foreach (var data in listUpdate)
{
data.distance = distance;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
}
}
logger.Debug("SCells UpdateDistance: " + id.ToString());
//db.Configuration.ProxyCreationEnabled = false;
//db.Configuration.LazyLoadingEnabled = false;
//SectionMap sCells = db.SectionMap.Find(id);
//sCells.distance = distance;
//db.Entry(sCells).State = EntityState.Modified;
//db.SaveChanges();
//SectionMap sCells1 = db.SectionMap.First(d => d.sectionIdFinish == sCells.sectionIdStart && d.sectionIdStart == sCells.sectionIdFinish);
//sCells1.distance = distance;
//db.Entry(sCells1).State = EntityState.Modified;
//db.SaveChanges();
//logger.Debug("SCells UpdateDistance: " + id.ToString());
}
return(true);
}
public JsonResult List(string id)
{
string login = HttpContext.User.Identity.Name;
using (SCellsEntities db = new SCellsEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
int idT = db.Tier.First(a => a.name == id).id;
var query = db.TierMap
.AsNoTracking()
.Include(d => d.Tier)
.Include(d => d.Tier1)
.Where(d => d.tierIdStart == idT)
.ToList();
var data = query.Select(dataList => new
{
editLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getPoint('" + dataList.id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-pencil" + '\u0022' + "></span></a></td>",
sectionIdStart = dataList.tierIdStart,
name1 = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getPoint('" + dataList.id + "')" + '\u0022' + ">" + dataList.Tier.name + "</a></td>",
sectionIdFinish = dataList.tierIdFinish,
name2 = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getPoint('" + dataList.id + "')" + '\u0022' + ">" + dataList.Tier1.name + "</a></td>",
dataList.distance
});
//int idS = db.Section.First(d => d.name == id).idS;
//var query = db.SectionMap
// .AsNoTracking()
// .Include(d => d.Section)
// .Include(d => d.Section1)
// .Where(d => d.sectionIdStart == idS)
// .ToList();
//var data = query.Select(dataList => new
//{
// editLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getPoint('" + dataList.id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-pencil" + '\u0022' + "></span></a></td>",
// dataList.sectionIdStart,
// name1 = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getPoint('" + dataList.id + "')" + '\u0022' + ">" + dataList.Section.name + "</a></td>",
// dataList.sectionIdFinish,
// name2 = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getPoint('" + dataList.id + "')" + '\u0022' + ">" + dataList.Section1.name + "</a></td>",
// dataList.distance
//});
return(Json(new { data, MaxJsonLength = int.MaxValue }));
}
}
public ActionResult Index()
{
SCellsEntities db = new SCellsEntities();
string login = HttpContext.User.Identity.Name;
ViewBag.list = new SelectList(db.Tier.OrderBy(d => d.name), "id", "name");
ViewBag.sections = new SelectList(db.Tier.OrderBy(d => d.name), "id", "name");
//ViewBag.list = new SelectList(db.Section.OrderBy(d => d.name), "idS", "name");
//ViewBag.sections = new SelectList(db.Section.OrderBy(d => d.name), "idS", "name");
try
{
logger.Debug("SCells ActionResult: " + login);
}
catch
{
logger.Debug("SCells ActionResult: ");
}
return(View());
}
public JsonResult GetPoint(int id)
{
using (SCellsEntities db = new SCellsEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.TierMap
.Include(d => d.Tier)
.Include(d => d.Tier1)
.Where(d => d.id == id)
.ToList();
var data = query.Select(dataList => new
{
dataList.id,
sectionIdStart = dataList.tierIdStart,
name1 = dataList.Tier.name,
sectionIdFinish = dataList.tierIdFinish,
name2 = dataList.Tier1.name,
dataList.distance
});
//var query = db.SectionMap
// .Include(d => d.Section)
// .Include(d => d.Section1)
// .Where(d => d.id == id)
// .ToList();
//var data = query.Select(dataList => new
//{
// dataList.id,
// dataList.sectionIdStart,
// name1 = dataList.Section.name,
// dataList.sectionIdFinish,
// name2 = dataList.Section1.name,
// dataList.distance
//});
return(Json(data.First(), JsonRequestBehavior.AllowGet));
}
}