public ActionResult Set(Dictionary <string, string> plan, string UserId)
{
string[] reject = { "action", "page", "controller" };
UserId = User.Identity.GetUserId();
using (var db = new businessPlanEntities())
{
using (var tran = db.Database.BeginTransaction())
{
try
{
var q = db.PlanItems.Where(c => c.UserId == UserId && plan.Keys.Contains(c.Item)).ToList();
if (q.Count > 0)
{
db.PlanItems.RemoveRange(q);
db.SaveChanges();
}
db.PlanItems.AddRange(plan.Where(c => !reject.Contains(c.Key)).Select(c => new PlanItems
{
UserId = UserId,
Data = c.Value,
Item = c.Key
}));
db.SaveChanges();
tran.Commit();
return(Json(plan));
}
catch (Exception e)
{
tran.Rollback();
Response.StatusCode = 500;
return(Json(e.Message));
}
}
}
}
public ActionResult GetKad(string keyword)
{
using (var db = new businessPlanEntities())
{
var result = db.bp_kad.Where(c => c.id.StartsWith(keyword) || c.title.Contains(keyword)).OrderBy(c => c.id).Take(10).ToList();
return(Json(result));
}
}
public ActionResult createDiag3(string UserId)
{
using (var db = new businessPlanEntities())
{
var returned = Plan.GetPlan(UserId, db);
return(View(returned));
}
}
public ActionResult GetById(long id)
{
using (var db = new businessPlanEntities())
{
var result = db.GeoCodes.Find(id);
return(Json(result));
}
}
public ActionResult Footer()
{
string UserId = User.Identity.GetUserId();
using (var db = new businessPlanEntities())
{
var returned = Plan.GetPlan(UserId, db);
return(View(returned));
}
}
public ActionResult Get(string UserId)
{
UserId = User.Identity.GetUserId();
using (var db = new businessPlanEntities())
{
return(Json((from c in db.PlanItems
where c.UserId == UserId
select c).ToDictionary(c => c.Item, c => c.Data)));
}
}
public ActionResult Resolve(long Id)
{
using (var db = new businessPlanEntities())
{
var curr = db.GeoCodes.Find(Id);
List <Object> ret = new List <object>();
while (curr != null && curr.Level >= 3)
{
ret.Add(new
{
curr.Id,
curr.Descr
});
curr = db.GeoCodes.Find(curr.ParentId);
}
ret.Reverse();
return(Json(ret));
}
}
public ActionResult Pdf()
{
string UserId = User.Identity.GetUserId();
ViewBag.UserId = UserId;
using (var db = new businessPlanEntities())
{
var returned = Plan.GetPlan(UserId, db);
if (returned == null)
{
Response.StatusCode = 500;
return(null);
}
string customSwitches = string.Format(
//"--print-media-type " +
//"--allow \"{0}\" \"{1}\" " +
"--header-html \"{0}\" " +
"--footer-html \"{1}\" " +
"--load-error-handling ignore " +
"--header-spacing \"10\" " +
"--footer-spacing \"10\" " +
"--footer-font-size \"10\" " +
"--header-font-size \"10\" " +
//"--footer-left \"Εμπιστευτικό – Να μην διανεμηθεί\" " +
//"--footer-center \"[page]/[toPage]\"" +
"",
//" --load-error-handling ignore",
Url.Action("Header", "Pdf", new { titlos = returned.company.title }, "http"),
Url.Action("Footer", "Pdf", new { }, "http")
);
Response.Headers.Add("Content-Disposition:", "attachment; filename=\"BusinessPlan.pdf\"");
return(new ViewAsPdf(returned)
{
RotativaOptions = new Rotativa.Core.DriverOptions {
CustomSwitches = customSwitches
}
});
}
}
public ActionResult GetByPid(long?pid)
{
using (var db = new businessPlanEntities())
{
if (pid != null)
{
var result = db.GeoCodes.Where(c => c.ParentId == pid.Value).ToList().Select(c => new {
c.Descr,
c.Id,
});
return(Json(result));
}
else
{
var result = db.GeoCodes.Where(c => c.Level == 3).ToList().Select(c => new {
c.Descr,
c.Id,
});
return(Json(result));
}
}
}
