public ActionResult Edit([Bind(Include = "LicenseNumber,VehicleYear,PurchaseDate,brand,serial,MaxPassenger,officeID,VehiclePhoto")] CompanyVehicle companyVehicle) { if (ModelState.IsValid) { if (Request.Files["File1"].ContentLength != 0) { byte[] data = null; using (BinaryReader br = new BinaryReader(Request.Files["File1"].InputStream)) { data = br.ReadBytes(Request.Files["File1"].ContentLength); } companyVehicle.VehiclePhoto = data; } else { CompanyVehicle c = db.CompanyVehicles.Find(companyVehicle.LicenseNumber); c.LicenseNumber = companyVehicle.LicenseNumber; c.VehicleYear = companyVehicle.VehicleYear; c.PurchaseDate = companyVehicle.PurchaseDate; c.brand = companyVehicle.brand; c.MaxPassenger = companyVehicle.MaxPassenger; c.officeID = companyVehicle.officeID; companyVehicle = c; } db.Entry(companyVehicle).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.officeID = new SelectList(db.Offices, "officeID", "office_name", companyVehicle.officeID); return(View(companyVehicle)); }
private void clsAltoButton2_Click(object sender, EventArgs e) { dbContext = new BusinessDataBaseEntities(); FileStream fs = System.IO.File.OpenRead(label6.Text); byte[] imageb = new byte[fs.Length]; fs.Read(imageb, 0, imageb.Length); try { var q = new CompanyVehicle { LicenseNumber = textBox1.Text, VehicleYear = int.Parse(textBox2.Text), PurchaseDate = dateTimePicker1.Value, brand = textBox3.Text, serial = textBox4.Text, MaxPassenger = textBox5.Text, officeID = int.Parse(comboBox1.Text), VehiclePhoto = imageb }; dbContext.CompanyVehicles.Add(q); dbContext.SaveChanges(); MessageBox.Show("Succeed"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult Create([Bind(Include = "LicenseNumber,VehicleYear,PurchaseDate,brand,serial,MaxPassenger,officeID,VehiclePhoto")] CompanyVehicle companyVehicle) { if (ModelState.IsValid) { if (Request.Files["File1"].ContentLength != 0) { byte[] data = null; using (BinaryReader br = new BinaryReader(Request.Files["File1"].InputStream)) { data = br.ReadBytes(Request.Files["File1"].ContentLength); } companyVehicle.VehiclePhoto = data; } db.CompanyVehicles.Add(companyVehicle); db.SaveChanges(); return(RedirectToAction("Index")); } //{ // db.CompanyVehicles.Add(companyVehicle); // db.SaveChanges(); // return RedirectToAction("Index"); //} //ViewBag.officeID = new SelectList(db.Offices, "officeID", "office_name", companyVehicle.officeID); return(View(companyVehicle)); }
public ActionResult DeleteConfirmed(string id) { CompanyVehicle companyVehicle = db.CompanyVehicles.Find(id); db.CompanyVehicles.Remove(companyVehicle); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Delete(string id) { using (BusinessDataBaseEntities db = new BusinessDataBaseEntities()) { CompanyVehicle b = db.CompanyVehicles.Where(x => x.LicenseNumber == id).FirstOrDefault <CompanyVehicle>(); db.CompanyVehicles.Remove(b); db.SaveChanges(); return(Json(new { success = true, message = "刪除成功" }, JsonRequestBehavior.AllowGet)); } }
// GET: CompanyVehicles/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyVehicle companyVehicle = db.CompanyVehicles.Find(id); if (companyVehicle == null) { return(HttpNotFound()); } return(View(companyVehicle)); }
public static void B_ClassWhichIsInheritedFromClassAndInterfaces() { var companyVehicle = new CompanyVehicle(100) { Color = "Black", SumInsured = 1000000, Cost = 250000 }; Trace.TraceInformation($"Get value of property from the base class: {companyVehicle.Color}"); Trace.TraceInformation($"Get value of property from IAsset interface: {companyVehicle.Cost}"); Trace.TraceInformation($"Get value of property from IInshured interface: {companyVehicle.SumInsured}"); }
// GET: CompanyVehicles/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyVehicle companyVehicle = db.CompanyVehicles.Find(id); if (companyVehicle == null) { return(HttpNotFound()); } ViewBag.officeID = new SelectList(db.Offices, "officeID", "office_name", companyVehicle.officeID); return(View(companyVehicle)); }
public ActionResult AddOrEdit(CompanyVehicle b) { using (BusinessDataBaseEntities db = new BusinessDataBaseEntities()) { db.Entry(b).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "修改成功" }, JsonRequestBehavior.AllowGet)); //var saveCars = new BusinessSystemMVC_Admin_page_.Models.CompanyVehicleHistory //{ // VehicleHistoryID = b.VehicleHistoryID, // StartDateTime = b.StartDateTime, // EndDateTime = b.EndDateTime, // employeeID = b.employeeID, // purpose = b.purpose //}; //return Json(new { success = true, message = "修改成功" }, JsonRequestBehavior.AllowGet); } }
public UpdateCompanyVehicleCommand(CompanyVehicle companyVehicle) { VehicleId = companyVehicle.VehicleId; CompanyId = companyVehicle.CompanyId; }
public async Task <bool> Update(CompanyVehicle companyVehicle) { await Task.CompletedTask; return(false); }
public async Task <bool> Insert(CompanyVehicle companyVehicle) { await Task.CompletedTask; return(true); }
public Task <IActionResult> Patch([FromBody] CompanyVehicle companyVehicle) { var result = _handler.Handler((UpdateCompanyVehicleCommand)companyVehicle); return(Response(result, _handler.Notifications)); }
public Task <IActionResult> Post([FromBody] CompanyVehicle companyVehicle) { var result = _handler.Handler(companyVehicle); return(Response(result, _handler.Notifications)); }
public async Task <bool> Update(CompanyVehicle companyVehicle) { var query = "update companyvehicle set DepartureDate = @DepartureDate, IsActive = @IsActive where VehicleId = @VehicleId and CompanyId = @CompanyId and IsActive = 1"; return(await Execute(query, companyVehicle)); }
public async Task <bool> Insert(CompanyVehicle companyVehicle) { var query = "insert into companyvehicle (VehicleId, CompanyId, EntryDate, IsActive) values (@VehicleId, @CompanyId, @EntryDate, @IsActive)"; return(await Execute(query, companyVehicle)); }