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