コード例 #1
0
        public ActionResult Edit(Calibration calibration)
        {
            if (ModelState.IsValid)
            {
                HttpPostedFileBase filephoto = Request.Files[0];
                if (filephoto != null)
                {
                    Stream       fs    = filephoto.InputStream;
                    BinaryReader br    = new BinaryReader(fs);
                    byte[]       bytes = br.ReadBytes((Int32)fs.Length);
                    calibration.CalibReportpdf = bytes;
                }


                //SendMail(Calibration.HandedOverToEmail);
                //Calibration.MailStatus = TempData["Mailstatus"].ToString();
                equipmentContext.Entry(calibration).State = EntityState.Modified;
                if (calibration.CalibReportpdf == null)
                {
                    equipmentContext.Entry(calibration).Property(x => x.CalibReportpdf).IsModified = false;
                }
                equipmentContext.SaveChanges();
                // SendMail(handover.HandedOverToEmail);
                return(RedirectToAction("Index"));
            }
            return(View());
        }
コード例 #2
0
        public async Task <EquipmentBrand> GetAsync(int equipmentBrand)
        {
            var equipmentsBrand = await _context.EquipmentBrand.FindAsync(equipmentBrand);

            if (equipmentsBrand != null)
            {
                await _context.Entry(equipmentsBrand)
                .Collection(i => i.Name).LoadAsync();
            }

            return(equipmentsBrand);
        }
コード例 #3
0
        public async Task <EquipmentType> GetAsync(int equipmentType)
        {
            var equipmentsType = await _context.EquipmentType.FindAsync(equipmentType);

            if (equipmentsType != null)
            {
                await _context.Entry(equipmentsType)
                .Collection(i => i.Name).LoadAsync();
            }

            return(equipmentsType);
        }
コード例 #4
0
        public async Task <Equipments> GetAsync(int equipmentsId)
        {
            var equipments = await _context.Equipments.FindAsync(equipmentsId);

            if (equipments != null)
            {
                await _context.Entry(equipments)
                .Collection(i => i.Name).LoadAsync();

                await _context.Entry(equipments)
                .Reference(i => i.Code).LoadAsync();
            }

            return(equipments);
        }
コード例 #5
0
        public async Task <IActionResult> PutInvoice(int id, Invoice invoice)
        {
            if (id != invoice.InvoiceId)
            {
                return(BadRequest());
            }

            _context.Entry(invoice).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!InvoiceExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
コード例 #6
0
        // GET: Asset
        public ActionResult Index(string id, string sortOrder)
        {
            ViewBag.CurrentSort         = sortOrder;
            ViewBag.AssetSortParm       = String.IsNullOrEmpty(sortOrder) ? "asset_desc" : "";
            ViewBag.DescriptionSortParm = sortOrder == "description" ? "description_desc" : "description";

            var viewModel = new AssetIndexData();

            viewModel.Assets = db.Assets
                               .Include(i => i.WorkOrders)
                               .OrderBy(i => i.AssetID);

            switch (sortOrder)
            {
            case "asset_desc":
                viewModel.Assets = viewModel.Assets.OrderByDescending(s => s.AssetID);
                break;

            case "description":
                viewModel.Assets = viewModel.Assets.OrderBy(s => s.Description);
                break;

            case "description_desc":
                viewModel.Assets = viewModel.Assets.OrderByDescending(s => s.Description);
                break;

            default:
                viewModel.Assets = viewModel.Assets.OrderBy(s => s.AssetID);
                break;
            }

            if (!String.IsNullOrEmpty(id))
            {
                ViewBag.AssetID = id;
                var selectedAsset = viewModel.Assets.Where(x => x.AssetID == id).Single();
                db.Entry(selectedAsset).Collection(x => x.WorkOrders).Load();
                foreach (WorkOrder workOrder in selectedAsset.WorkOrders)
                {
                    db.Entry(workOrder).Reference(x => x.Asset).Load();
                }

                viewModel.WorkOrders = selectedAsset.WorkOrders;
            }

            return(View(viewModel));
        }
コード例 #7
0
 public ActionResult Edit([Bind(Include = "WorkOrderID,AssetID,Problem,DateRequested")] WorkOrder workOrder)
 {
     if (ModelState.IsValid)
     {
         db.Entry(workOrder).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.AssetID = new SelectList(db.Assets, "AssetID", "Description", workOrder.AssetID);
     return(View(workOrder));
 }
コード例 #8
0
        public ActionResult Edit(HandOver handover, HttpPostedFileBase file)
        {
            if (ModelState.IsValid)
            {
                if (file != null)
                {
                    Stream       fs    = file.InputStream;
                    BinaryReader br    = new BinaryReader(fs);
                    byte[]       bytes = br.ReadBytes((Int32)fs.Length);
                    handover.Photo = bytes;
                }
                SendMail(handover.HandedOverToEmail, handover.RecivedTo);
                handover.MailStatus = TempData["Mailstatus"].ToString();

                equipmentContext.Entry(handover).State = EntityState.Modified;
                equipmentContext.SaveChanges();
                // SendMail(handover.HandedOverToEmail);
                return(RedirectToAction("Index"));
            }
            GetDropwnList();
            return(View());
        }
コード例 #9
0
        public ActionResult Edit(Models.Equipment equipment)
        {
            if (ModelState.IsValid)
            {
                //Models.Equipment obj = new Models.Equipment();
                //obj = equipmentContext.Equipments.Single(objid => objid.Id == equipment.Id);
                HttpPostedFileBase filephoto = Request.Files[0];
                HttpPostedFileBase fileOperatingInstructionpdf = Request.Files[1];
                HttpPostedFileBase fileDatasheetpdf            = Request.Files[2];
                HttpPostedFileBase fileCataloguepdf            = Request.Files[3];
                if (filephoto.FileName != "")
                {
                    byte[] bytes;
                    using (BinaryReader br = new BinaryReader(filephoto.InputStream))
                    {
                        bytes = br.ReadBytes(filephoto.ContentLength);
                    }
                    equipment.Photo = bytes;
                }

                if (fileOperatingInstructionpdf.FileName != "")
                {
                    Stream       fs    = fileOperatingInstructionpdf.InputStream;
                    BinaryReader br    = new BinaryReader(fs);
                    byte[]       bytes = br.ReadBytes((Int32)fs.Length);
                    equipment.OperatingInstructionpdf = bytes;
                }

                if (fileDatasheetpdf.FileName != "")
                {
                    Stream       fs    = fileDatasheetpdf.InputStream;
                    BinaryReader br    = new BinaryReader(fs);
                    byte[]       bytes = br.ReadBytes((Int32)fs.Length);
                    equipment.Datasheetpdf = bytes;
                }

                if (fileCataloguepdf.FileName != "")
                {
                    Stream       fs    = fileCataloguepdf.InputStream;
                    BinaryReader br    = new BinaryReader(fs);
                    byte[]       bytes = br.ReadBytes((Int32)fs.Length);
                    equipment.Cataloguepdf = bytes;
                }

                equipmentContext.Entry(equipment).State = EntityState.Modified;
                if (equipment.Photo == null)
                {
                    equipmentContext.Entry(equipment).Property(x => x.Photo).IsModified = false;
                }
                if (equipment.OperatingInstructionpdf == null)
                {
                    equipmentContext.Entry(equipment).Property(x => x.OperatingInstructionpdf).IsModified = false;
                }
                if (equipment.Cataloguepdf == null)
                {
                    equipmentContext.Entry(equipment).Property(x => x.Cataloguepdf).IsModified = false;
                }
                if (equipment.Datasheetpdf == null)
                {
                    equipmentContext.Entry(equipment).Property(x => x.Datasheetpdf).IsModified = false;
                }
                equipmentContext.SaveChanges();

                return(RedirectToAction("Index"));
            }
            GetDropwnList();
            return(View());
        }
コード例 #10
0
 public void Update(Equipment equipment)
 {
     _context.Entry(equipment).State = EntityState.Modified;
 }