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