public ActionResult AddOrEdit(CompanyVehicleHistory b)
{
using (BusinessDataBaseEntities db = new BusinessDataBaseEntities())
{
if (b.VehicleHistoryID == 0)
{
}
else
{
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 ActionResult DeleteConfirmed(int id)
{
CompanyVehicleHistory companyVehicleHistory = db.CompanyVehicleHistories.Find(id);
db.CompanyVehicleHistories.Remove(companyVehicleHistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult getchange([Bind(Include = "LicenseNumber,StartDateTime,EndDateTime,purpose")] CompanyVehicleHistory companyVehicleHistory)
{
if (ModelState.IsValid)
{
db.CompanyVehicleHistories.Add(companyVehicleHistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(companyVehicleHistory));
}
public ActionResult Edit([Bind(Include = "VehicleHistoryID,LicenseNumber,StartDateTime,EndDateTime,employeeID,purpose")] CompanyVehicleHistory companyVehicleHistory)
{
if (ModelState.IsValid)
{
db.Entry(companyVehicleHistory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LicenseNumber = new SelectList(db.CompanyVehicles, "LicenseNumber", "brand", companyVehicleHistory.LicenseNumber);
ViewBag.employeeID = new SelectList(db.Employees, "employeeID", "EmployeeName", companyVehicleHistory.employeeID);
return(View(companyVehicleHistory));
}
// GET: CompanyVehicleBorrow/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CompanyVehicleHistory companyVehicleHistory = db.CompanyVehicleHistories.Find(id);
if (companyVehicleHistory == null)
{
return(HttpNotFound());
}
return(View(companyVehicleHistory));
}
public ActionResult Delete(int id)
{
using (BusinessDataBaseEntities db = new BusinessDataBaseEntities())
{
CompanyVehicleHistory b = db.CompanyVehicleHistories.Where(x => x.VehicleHistoryID == id).FirstOrDefault <CompanyVehicleHistory>();
db.CompanyVehicleHistories.Remove(b);
//var q = db.CompanyVehicleHistories.Find(id);
//EventCalendar e = db.EventCalendars.Where(x => x.StartTime == q.StartDateTime && x.EndTime == q.EndDateTime && x.Location == q.LicenseNumber).FirstOrDefault<EventCalendar>();
//db.EventCalendars.Remove(e);
db.SaveChanges();
return(Json(new { success = true, message = "刪除成功" }, JsonRequestBehavior.AllowGet));
}
}
// GET: CompanyVehicleBorrow/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CompanyVehicleHistory companyVehicleHistory = db.CompanyVehicleHistories.Find(id);
if (companyVehicleHistory == null)
{
return(HttpNotFound());
}
ViewBag.LicenseNumber = new SelectList(db.CompanyVehicles, "LicenseNumber", "brand", companyVehicleHistory.LicenseNumber);
ViewBag.employeeID = new SelectList(db.Employees, "employeeID", "EmployeeName", companyVehicleHistory.employeeID);
return(View(companyVehicleHistory));
}
private void clsAltoButton1_Click(object sender, EventArgs e)
{
mytime1();
mytime2();
if (this.richTextBox1.Text != "" && this.comboBox3.Text != "" && this.comboBox4.Text != "" && this.dataGridView1.DataSource != null)
{
var q = new CompanyVehicleHistory
{
LicenseNumber = this.dataGridView1.Rows[0].Cells["車牌號碼"].Value.ToString(),
StartDateTime = this.dTPStartTime.Value,
EndDateTime = this.dTPEndTime.Value,
employeeID = LoginID,
purpose = this.richTextBox1.Text
};
dbcontext.CompanyVehicleHistories.Add(q);
dbcontext.SaveChanges();
MessageBox.Show("借車成功！" + "\n" + "借車時數共 " + ((this.dTPEndTime.Value - this.dTPStartTime.Value).Days).ToString() + "日" + ((this.dTPEndTime.Value - this.dTPStartTime.Value).Hours).ToString() + "小時" + "\n請準時歸還!");
}
else
{
MessageBox.Show("請正確操作", "警告", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
