public ActionResult Delete(int id, FormCollection collection) { try { // TODO: Add delete logic here PoleInfoEntities objE = new PoleInfoEntities(); var objPoleInfo = objE.PoleInfoChangeApplies.Find(id); objE.PoleInfoChangeApplies.Remove(objPoleInfo); objE.SaveChanges(); return RedirectToAction("Index"); } catch { return View(); } }
// // GET: /PoleInfoChangeApply/Delete/5 public ActionResult Delete(int id) { PoleInfoEntities objE = new PoleInfoEntities(); var data = (from p in objE.PoleInfoChangeApplies.Where(p => p.ID == id) join t in objE.PoleTypes on p.TypeID equals t.ID select new PoleInfoViewModel { ID = p.ID, PoleID = p.PoleID, TypeID = p.TypeID, TypeName = t.TypeName, TaskAddeddate = p.TaskAddeddate, TaskPerformeddate = p.TaskPerformeddate, ImageMapPath = p.ImageMapPath, AdjacentPoleHeight = p.AdjacentPoleHeight, TransFormerLoading = p.TransFormerLoading, Notes = p.Notes, ImagesTakenpath = p.ImagesTakenpath }).SingleOrDefault(); return View(data); }
public ActionResult SaveUploadedPoleImage(List<PoleImageList> obj) { try { if(obj==null) { return Json(new { Success = 3, ID = 0, ex = "" }); } string PoleID=""; PoleInfoEntities objE = new PoleInfoEntities(); var FileSavePathList = objE.FileSavePaths.ToList(); string _savepath = FileSavePathList.SingleOrDefault(p => p.FileFor == "PoleImageMapPath").FilePath; userInfo = new UserInformationController().GetUserByAspNetUserId(User.Identity.GetUserId()); foreach (var itm in obj) { var id = itm.ID; PoleID = itm.PoleID; var Imgae64 = itm.Image64; Image image = PoleClass.Base64ToImage(Imgae64); string ImageMapPath = _savepath + itm.PoleID.ToString().Trim() + "_MapImage"+itm.ID.ToString() + ".jpg"; //string imgname = PoleID+"_img_"+id.ToString()+".jpg"; image.Save(ImageMapPath, System.Drawing.Imaging.ImageFormat.Jpeg); PoleImage poleimage = new PoleImage(); poleimage.UserID = userInfo.Id; poleimage.PoleInfoID = itm.PoleInfoID; poleimage.ImageMapPath = ImageMapPath; poleimage.CreateDate = DateTime.Now; db.PoleImages.Add(poleimage); db.SaveChanges(); } //var msg = "Saved Successfully Completed"; //return Content(msg, "text/html"); return Json(new { Success = 1, ID = PoleID, ex = "" }); } catch (Exception ex) { return Json(new { Success = 0, ex = ex.Message.ToString() }); //throw new HttpException(500, ex.Message); } //return Json(new { Success = 0, ex = new Exception("Unable to save").Message.ToString() }); }
private IEnumerable GetSearchData() { //.Where(p => p.IsChanged == null || p.IsChanged == false) PoleInfoEntities objE = new PoleInfoEntities(); var data = (from p in objE.PoleInfoChangeApplies join t in objE.PoleTypes on p.TypeID equals t.ID into typegroup join u in objE.UserInformations on p.TaskAssainUserID equals u.Id into asinGroup from type in typegroup.DefaultIfEmpty() from asain in asinGroup.DefaultIfEmpty() where (userInfo.UserTypeID == 1 || (p.UserID == userInfo.Id)) select new PoleInfoViewModel { ID = p.ID, PoleID = p.PoleID, TypeID = p.TypeID, TypeName = type.TypeName, TaskAssainUserID = p.TaskAssainUserID, UserFullName = asain.UserFullName, TaskAddeddate = p.TaskAddeddate, TaskPerformeddate = p.TaskPerformeddate, ImageMapPath = p.ImageMapPath, AdjacentPoleHeight = p.AdjacentPoleHeight, TransFormerLoading = p.TransFormerLoading, Notes = p.Notes, ImagesTakenpath = p.ImagesTakenpath }).ToList().OrderByDescending(p => p.ID); //PoleInfoViewModel return data; }
public ActionResult Register() { PoleInfoEntities objE = new PoleInfoEntities(); ViewBag.AspNetRole = new SelectList(objE.AspNetRoles.ToList(), "Id", "Name"); return View(); }