public async Task <ActionResult> deletedata(long id) { Record_the_entry re = db.Record_the_entry.Find(id); //re.StateDelete = 1; db.Record_the_entry.Remove(re); await db.SaveChangesAsync(); Record_the_Entrry_Image ereimg = db.Record_the_Entrry_Image.Where(p => p.IdRecordentry == id).FirstOrDefault(); if (ereimg != null) { var oldfile = Path.Combine(Server.MapPath("~/images"), ereimg.Image); if (System.IO.File.Exists(oldfile)) { System.IO.File.Delete(oldfile); db.Record_the_Entrry_Image.Remove(ereimg); await db.SaveChangesAsync(); } } return(Json("Ok", JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> RecordEntry(Record_the_entry _re, string _Date, HttpPostedFileBase _file) { if (_re.Id == 0) { bool uniq = db.Record_the_entry.Where(p => p.CopsCod == _re.CopsCod && p.StateDelete == 0).Any(); if (uniq) { return(new HttpStatusCodeResult(513)); } else { if (_Date != null && _Date != "") { DateTime tempdate = clsPersianDate.ShamsiToMiladi(_Date).Value.Date; _re.Date = tempdate; } _re.Height = _re.Height.Trim(); _re.basculenumber = _re.basculenumber.Trim(); _re.CopsCod = _re.CopsCod.Trim(); _re.length = _re.length.Trim(); _re.Transfernumber = _re.Transfernumber.Trim(); _re.Trucknumber = _re.Trucknumber.Trim(); _re.Weight = _re.Weight.Trim(); _re.width = _re.width.Trim(); _re.ExitState = false; _re.StateCopReserve = false; _re.StateDelete = 0; db.Record_the_entry.Add(_re); await db.SaveChangesAsync(); Record_the_Entrry_Image reimg = new Record_the_Entrry_Image(); var filename = ""; if (Request.Files.Count != 0 && Request.Files != null) { for (int i = 0; i < Request.Files.Count; i++) { HttpPostedFileBase imgre = Request.Files[i]; if (imgre.ContentLength > 0) { if (!imgre.ContentType.Contains("image")) { return(new HttpStatusCodeResult(530)); } var number = new Random(); filename = _re.Id + "" + number.Next() + "" + i + number.Next(1, 999999999).ToString() + ".jpg"; var path = Path.Combine(Server.MapPath("~/images"), filename); imgre.SaveAs(path); reimg.Image = filename; reimg.IdRecordentry = _re.Id; db.Record_the_Entrry_Image.Add(reimg); await db.SaveChangesAsync(); } } } return(Json("Ok", JsonRequestBehavior.AllowGet)); } } else { Record_the_entry _ere = db.Record_the_entry.Find(_re.Id); bool uniq = db.Record_the_entry.Where(p => p.CopsCod == _re.CopsCod && p.Id != _ere.Id && p.StateDelete == 0).Any(); if (uniq) { return(new HttpStatusCodeResult(513)); } else { if (_Date != null && _Date != "") { DateTime tempdate = clsPersianDate.ShamsiToMiladi(_Date).Value.Date; _ere.Date = tempdate; } _ere.basculenumber = _re.basculenumber.Trim(); _ere.CopsCod = _re.CopsCod.Trim(); _ere.Height = _re.Height.Trim(); _ere.IdCops = _re.IdCops; _ere.IdMine = _re.IdMine; _ere.IdStore = _re.IdStore; _ere.length = _re.length.Trim(); _ere.Time = _re.Time; _ere.Transfernumber = _re.Transfernumber.Trim(); _ere.Trucknumber = _re.Trucknumber.Trim(); _ere.Weight = _re.Weight.Trim(); _ere.width = _re.width.Trim(); await db.SaveChangesAsync(); Record_the_Entrry_Image reimg = new Record_the_Entrry_Image(); var filename = ""; if (Request.Files.Count != 0 && Request.Files != null) { for (int i = 0; i < Request.Files.Count; i++) { HttpPostedFileBase imgre = Request.Files[i]; if (imgre.ContentLength > 0) { if (!imgre.ContentType.Contains("image")) { return(new HttpStatusCodeResult(530)); } Record_the_Entrry_Image ereimg = db.Record_the_Entrry_Image.Where(p => p.IdRecordentry == _re.Id).FirstOrDefault(); if (ereimg != null) { var oldfile = Path.Combine(Server.MapPath("~/images"), ereimg.Image); if (System.IO.File.Exists(oldfile)) { System.IO.File.Delete(oldfile); db.Record_the_Entrry_Image.Remove(ereimg); await db.SaveChangesAsync(); } } var number = new Random(); filename = _re.Id + "" + number.Next() + "" + i + number.Next(1, 999999999).ToString() + ".jpg"; var path = Path.Combine(Server.MapPath("~/images"), filename); imgre.SaveAs(path); reimg.Image = filename; reimg.IdRecordentry = _ere.Id; db.Record_the_Entrry_Image.Add(reimg); await db.SaveChangesAsync(); } } } return(Json("Ok", JsonRequestBehavior.AllowGet)); } } }