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