public PortageDocument(web_dbDocument.TblDocument row) { this.Date = row.Date; this.FkPortage = row.FkPortage; this.Id = row.Id; this.Kind = row.Kind; }
public IActionResult Create(web_db._Weighing.TblCar model, IFormFile file) { if (!ModelState.IsValid) { ViewBag.error = "ثبت انجام نشد - فیلد ها را درست پر کنید"; return(View(model)); } try { var x = db.TblCars.Find(model.Id); if (x == null) { x = new web_db._Weighing.TblCar { Id = model.Id, PriceTowBascol = 0 }; db.TblCars.Add(x); } x.Title = model.Title; x.IsDel = model.IsDel; x.PriceTowBascol = model.PriceTowBascol; var dbdoc = new web_dbDocument.db_Context(); if (file != null) { var r = dbdoc.TblDocuments.FirstOrDefault(a => a.FkP == x.Id); if (r == null) { r = new web_dbDocument.TblDocument { Date = DateTime.Now, FkP = x.Id, fkuser = User._getuserid(), Id = Guid.NewGuid(), Kind = "Image" }; dbdoc.TblDocuments.Add(r); } r.Image = file.ToByteArray().imgTosmall(); } db.SaveChanges(); dbdoc.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; Models.cl._ListCar = db.TblCars.OrderBy(a => a.Title).ToList(); return(RedirectToAction(nameof(Index))); } catch { ViewBag.error = "ثبت انجام نشد"; } return(View(model)); }
public IActionResult DocUpload(IList <IFormFile> files, Guid idp, string kind = "") { var db = new web_dbDocument.db_Context(); foreach (IFormFile source in files) { string Extension = Path.GetExtension(source.FileName).ToLowerInvariant(); if (Extension.IsEmpty()) { Extension = ".jpg"; } if (kind.IsEmpty() == false) { var v = db.TblDocuments.FirstOrDefault(a => a.Kind == kind && (a.FkP == idp || a.FkPortage == idp)); if (v != null) { db.TblDocuments.Remove(v); } } web_dbDocument.TblDocument x = new web_dbDocument.TblDocument { Id = Guid.NewGuid(), FkP = idp, Kind = kind.IsEmpty() ? "" : kind, Date = DateTime.Now, fkuser = User._getuserid() }; db.TblDocuments.Add(x); x.Date = DateTime.Now; using (var target = new MemoryStream()) { source.CopyTo(target); x.Image = target.ToArray(); } x.Format = Extension; if ((Extension).IsImage()) { x.Image = x.Image.imgTosmall(web_lib.FilesHelper.imageSize.s800); } } db.SaveChanges(); return(Content("OK")); }
public IActionResult addDoc(Guid id, Guid idp, IFormFile image = null, bool del = false, string kind = "Yard") { var dbdoc = new web_dbDocument.db_Context(); if (del) { var x = dbdoc.TblDocuments.Find(id); var pp = db.TblPortages.Find(x.FkPortage); if ((pp.FkSalmali != User._getuserSalMaliDef()) || (pp.IsEnd) || (pp.IsDel)) { return(RedirectToAction("index")); } dbdoc.TblDocuments.Remove(x); } else { var pp = db.TblPortages.Find(idp); if ((pp.FkSalmali != User._getuserSalMaliDef()) || (pp.IsEnd) || (pp.IsDel)) { return(RedirectToAction("index")); } web_dbDocument.TblDocument x = null; if (kind == "Sign") { x = dbdoc.TblDocuments.FirstOrDefault(a => a.FkPortage == idp && a.Kind == kind); } if (kind == "SignPermit") { x = dbdoc.TblDocuments.FirstOrDefault(a => a.FkPortage == idp && a.Kind == kind); } if (x == null) { x = new web_dbDocument.TblDocument { Id = Guid.NewGuid(), FkPortage = idp, Kind = kind }; dbdoc.TblDocuments.Add(x); } x.Date = DateTime.Now; using (var target = new MemoryStream()) { image.CopyTo(target); x.Image = target.ToArray(); } x.Image = x.Image.imgTosmall(web_lib.FilesHelper.imageSize.s800); } dbdoc.SaveChanges(); return(RedirectToAction("view", new { id = idp, openkind = 1 })); }
private porret[] ClonePortage(Guid id, int setYear, bool image) { var portage = db.TblPortages.Find(id); var customer = db.TblCustomers.Find(portage.FkCustomer); var Clone = db.TblPortages.SingleOrDefault(a => a.Code == portage.Code && a.KindCode == portage.KindCode && a.FkSalmali == setYear); var contype = db.TblContractTypes.Find(portage.FkContracttype); var contypeclone = db.TblContractTypes.Single(a => a.Code == contype.Code && a.FkSalmali == setYear); var customerClone = db.TblCustomers.SingleOrDefault(a => a.Code == customer.Code && a.FkSalmali == setYear);; if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) { #region Clone Portage { if (Clone == null) { Clone = new web_db._Weighing.TblPortage { FkSalmali = setYear, Id = Guid.NewGuid(), }; db.TblPortages.Add(Clone); } Clone.FkContracttype = contypeclone.Id; Clone.FkCustomer = customerClone.Id; Clone.CarMashin = portage.CarMashin; Clone.CarRanande = portage.CarRanande; Clone.CarShMashin = portage.CarShMashin; Clone.CarTell = portage.CarTell; Clone.Code = portage.Code; Clone.Date1 = portage.Date1; Clone.Date2 = portage.Date2; Clone.Dateadd1 = portage.Dateadd1; Clone.Dateadd2 = portage.Dateadd2; Clone.Dateedit1 = portage.Dateedit1; Clone.Dateedit2 = portage.Dateedit2; Clone.FkCar = portage.FkCar; Clone.FkUsAdd1 = portage.FkUsAdd1; Clone.FkUsAdd2 = portage.FkUsAdd2; Clone.FkUsEdit1 = portage.FkUsEdit1; Clone.FkUsEdit2 = portage.FkUsEdit2; Clone.FkUsPermit = portage.FkUsPermit; Clone.IsDel = portage.IsDel; Clone.IsEnd = portage.IsEnd; Clone.IsPermitOk = portage.IsPermitOk; Clone.KindCode = portage.KindCode; Clone.KindTitle = portage.KindTitle; Clone.OtcodeResid = portage.OtcodeResid; Clone.PackingCount = portage.PackingCount; Clone.PackingOfWeight = portage.PackingOfWeight; Clone.SmsOk = portage.SmsOk; // Clone.SaveFaktor = portage.SaveFaktor; Clone.SmsVaziat = portage.SmsVaziat; // Clone.SumMoney = portage.SumMoney; Clone.Txt = portage.Txt; Clone.Weight1 = portage.Weight1; Clone.Weight1IsBascul = portage.Weight1IsBascul; Clone.TxtPermit = portage.TxtPermit; Clone.Weight2 = portage.Weight2; Clone.Weight2IsBascul = portage.Weight2IsBascul; Clone.WeightNet = portage.WeightNet; } #endregion #region Clone PortageRows foreach (var item in db.TblPortageRows.Include(a => a.TblPortageRowInjuries).Where(a => a.FkPortage == Clone.Id)) { db.TblPortageRowInjuries.RemoveRange(item.TblPortageRowInjuries); db.TblPortageRows.Remove(item); } foreach (var item in db.TblPortageRows.Include(a => a.TblPortageRowInjuries).Where(a => a.FkPortage == portage.Id)) { var cont = db.TblContracts.Find(item.FkContract); var contClone = db.TblContracts.Single(a => a.Code == cont.Code && a.FkSalmali == setYear); var v = new web_db._Weighing.TblPortageRow { Id = Guid.NewGuid(), FkContractType = Clone.FkContracttype, FkContract = contClone.Id, FkPortage = Clone.Id, Code = item.Code, CodeLocation = item.CodeLocation, Count = item.Count, Date = item.Date, FkLocation1 = item.FkLocation1, FkLocation2 = item.FkLocation2, FkLocation3 = item.FkLocation3, FkPacking = item.FkPacking, FkProduct = item.FkProduct, FkUser = item.FkUser, IsNimPalet = item.IsNimPalet, Txt = item.Txt, WeightOne = item.WeightOne }; db.TblPortageRows.Add(v); foreach (var iteminj in item.TblPortageRowInjuries) { db.TblPortageRowInjuries.Add(new web_db._Weighing.TblPortageRowInjury { FkInjury = iteminj.FkInjury, FkPortageRow = v.Id }); } } #endregion #region Clone images var dbdoc = new web_dbDocument.db_Context(); dbdoc.TblDocuments.RemoveRange(dbdoc.TblDocuments.Where(a => a.FkPortage == Clone.Id || a.FkP == Clone.Id)); if (image) { foreach (var item in dbdoc.TblDocuments.Where(a => a.FkPortage == portage.Id)) { var c = new web_dbDocument.TblDocument { Id = Guid.NewGuid(), Date = item.Date, Image = item.Image, Kind = item.Kind, FkP = Clone.Id, Format = item.Format }; dbdoc.TblDocuments.Add(c); } } #endregion db.SaveChanges(); dbdoc.SaveChanges(); var x = db.TblPortageRows.Where(a => a.FkPortage == Clone.Id); return(x.Select(a => new porret { id = (Guid)a.FkContract, Product = true }).Distinct().ToArray()); } else if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) { #region Clone Portage { if (Clone == null) { Clone = new web_db._Weighing.TblPortage { FkSalmali = setYear, Id = Guid.NewGuid(), }; db.TblPortages.Add(Clone); } Clone.FkContracttype = contypeclone.Id; Clone.FkCustomer = customerClone.Id; Clone.CarMashin = portage.CarMashin; Clone.CarRanande = portage.CarRanande; Clone.CarShMashin = portage.CarShMashin; Clone.CarTell = portage.CarTell; Clone.Code = portage.Code; Clone.Date1 = portage.Date1; Clone.Date2 = portage.Date2; Clone.Dateadd1 = portage.Dateadd1; Clone.Dateadd2 = portage.Dateadd2; Clone.Dateedit1 = portage.Dateedit1; Clone.Dateedit2 = portage.Dateedit2; Clone.FkCar = portage.FkCar; Clone.FkUsAdd1 = portage.FkUsAdd1; Clone.FkUsAdd2 = portage.FkUsAdd2; Clone.FkUsEdit1 = portage.FkUsEdit1; Clone.FkUsEdit2 = portage.FkUsEdit2; Clone.FkUsPermit = portage.FkUsPermit; Clone.IsDel = portage.IsDel; Clone.IsEnd = portage.IsEnd; Clone.IsPermitOk = portage.IsPermitOk; Clone.KindCode = portage.KindCode; Clone.KindTitle = portage.KindTitle; Clone.OtcodeResid = portage.OtcodeResid; Clone.PackingCount = portage.PackingCount; Clone.PackingOfWeight = portage.PackingOfWeight; Clone.SmsOk = portage.SmsOk; // Clone.SaveFaktor = portage.SaveFaktor; Clone.SmsVaziat = portage.SmsVaziat; // Clone.SumMoney = portage.SumMoney; Clone.Txt = portage.Txt; Clone.Weight1 = portage.Weight1; Clone.Weight1IsBascul = portage.Weight1IsBascul; Clone.TxtPermit = portage.TxtPermit; Clone.Weight2 = portage.Weight2; Clone.Weight2IsBascul = portage.Weight2IsBascul; Clone.WeightNet = portage.WeightNet; } #endregion #region Clone PortageRows foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == Clone.Id)) { db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id)); db.TblPortageRows.Remove(item); } foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == portage.Id)) { var cont = db.TblContracts.Find(item.FkContract); var contClone = db.TblContracts.Single(a => a.Code == cont.Code && a.FkSalmali == setYear); var v = new web_db._Weighing.TblPortageRow { Id = Guid.NewGuid(), FkContractType = Clone.FkContracttype, FkContract = contClone.Id, FkPortage = Clone.Id, Code = item.Code, CodeLocation = item.CodeLocation, Count = item.Count, Date = item.Date, FkLocation1 = item.FkLocation1, FkLocation2 = item.FkLocation2, FkLocation3 = item.FkLocation3, FkPacking = item.FkPacking, FkProduct = item.FkProduct, FkUser = item.FkUser, IsNimPalet = item.IsNimPalet, Txt = item.Txt, WeightOne = item.WeightOne }; db.TblPortageRows.Add(v); foreach (var iteminj in db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id)) { db.TblPortageRowInjuries.Add(new web_db._Weighing.TblPortageRowInjury { FkInjury = iteminj.FkInjury, FkPortageRow = v.Id }); } } #endregion #region Clone images var dbdoc = new web_dbDocument.db_Context(); dbdoc.TblDocuments.RemoveRange(dbdoc.TblDocuments.Where(a => a.FkPortage == Clone.Id)); foreach (var item in dbdoc.TblDocuments.Where(a => a.FkPortage == portage.Id)) { var c = new web_dbDocument.TblDocument { Id = Guid.NewGuid(), FkP = Clone.Id, Date = item.Date, Image = item.Image, Kind = item.Kind }; dbdoc.TblDocuments.Add(c); } #endregion dbdoc.SaveChanges(); db.SaveChanges(); return(new porret[] { new porret { id = contypeclone.Id, Product = false } }); } return(null); }