public IHttpActionResult PosttblDriver(tblDriver tblDriver) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblDrivers.Add(tblDriver); try { db.SaveChanges(); } catch (DbUpdateException) { if (tblDriverExists(tblDriver.drv_Id)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tblDriver.drv_Id }, tblDriver)); }
public IHttpActionResult PuttblDriver(int id, tblDriver tblDriver) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblDriver.drvId) { return(BadRequest()); } db.Entry(tblDriver).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblDriverExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PuttblDriver(int id, tblDriver tblDriver) { Console.WriteLine("Hello"); tblDriver oldDetails = tblDriver; if (!ModelState.IsValid) { return(BadRequest("Not valid data")); } using (db) { var drvr = db.tblDrivers.Where(g => g.drv_Id.Equals(id)).FirstOrDefault(); if (drvr != null) { drvr.drv_Firstname = tblDriver.drv_Firstname; drvr.drv_Lastname = tblDriver.drv_Lastname; drvr.drv_Contact = tblDriver.drv_Contact; drvr.drv_Location = tblDriver.drv_Location; drvr.drv_VehicleType = tblDriver.drv_VehicleType; drvr.drv_Email = tblDriver.drv_Email; drvr.drv_Password = tblDriver.drv_Password; var res = db.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
public ActionResult AddDriver(FormCollection form, HttpPostedFileBase txtProfile) { string name = "txtProfile"; if (txtProfile != null) { int size = (int)txtProfile.ContentLength / 1024; var extention = System.IO.Path.GetExtension(txtProfile.FileName); if (size <= 1024 && (extention.ToLower().Equals(".jpg") || extention.ToLower().Equals(".jpeg") || extention.ToLower().Equals(".png"))) { name = Code() + "" + extention; string path = Server.MapPath("~/Images/"); txtProfile.SaveAs(path + "" + name); } } tblDriver driver = new tblDriver(); driver.CompanyId = Convert.ToInt32(Session["CompanyId"]); driver.DriverName = form["txtDname"]; driver.ImageURL = name.ToString(); driver.ContactNo = form["txtCno"]; driver.EmailId = form["txtEmail"]; driver.LicenseNo = form["txtLno"]; driver.AadharcardNo = form["txtAno"]; driver.IsActive = true; driver.CreatedOn = DateTime.Now; dc.tblDrivers.Add(driver); dc.SaveChanges(); return(RedirectToAction("CompanyProfile", "ClientCompany", new { id = driver.CompanyId })); }
public ActionResult DeleteConfirmed(int id) { tblDriver tblDriver = db.tblDrivers.Find(id); db.tblDrivers.Remove(tblDriver); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Detail(int id) { tblDriver driver = dc.tblDrivers.SingleOrDefault(ob => ob.DriverId == id); ViewBag.CompanyName = (from ob in dc.tblTransportCompanies where ob.CompanyId == driver.CompanyId select ob).Take(1).SingleOrDefault().CompanyName; string Name = ViewBag.CompanyName; return(View(driver)); }
public ActionResult Edit([Bind(Include = "DId,Name,Salary,Residence,ContactNo")] tblDriver tblDriver) { if (ModelState.IsValid) { db.Entry(tblDriver).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblDriver)); }
public IHttpActionResult GettblDriver(int id) { tblDriver tblDriver = db.tblDrivers.Find(id); if (tblDriver == null) { return(NotFound()); } return(Ok(tblDriver)); }
public ActionResult Create([Bind(Include = "DId,Name,Salary,Residence,ContactNo")] tblDriver tblDriver) { if (ModelState.IsValid) { db.tblDrivers.Add(tblDriver); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblDriver)); }
public void Add() { var addDriver = new tblDriver { DriverName = DDriverName, DriverMobile = DDriverMobile, NumberPlates = DNumberPlates }; _dbHavalehEntities.tblDriver.Add(addDriver); _dbHavalehEntities.SaveChanges(); }
public IHttpActionResult PosttblDriver(tblDriver tblDriver) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblDrivers.Add(tblDriver); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tblDriver.drvId }, tblDriver)); }
public IHttpActionResult DeletetblDriver(int id) { tblDriver tblDriver = db.tblDrivers.Find(id); if (tblDriver == null) { return(NotFound()); } db.tblDrivers.Remove(tblDriver); db.SaveChanges(); return(Ok(tblDriver)); }
public IHttpActionResult GettblDriver(string drvEmail, string drv_Password) { tblDriver drv = db.tblDrivers.Where(dv => dv.drvEmail.Equals(drvEmail) && dv.drv_Password.Equals(drv_Password)).FirstOrDefault(); if (drvEmail == null && drv_Password == null) { return(null); } else { return(Ok(drv)); } }
// GET: Drivers/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblDriver tblDriver = db.tblDrivers.Find(id); if (tblDriver == null) { return(HttpNotFound()); } return(View(tblDriver)); }
public JsonResult Active(int id) { tblDriver driver = dc.tblDrivers.SingleOrDefault(ob => ob.DriverId == id); if (driver.IsActive == true) { driver.IsActive = false; } else { driver.IsActive = true; } dc.SaveChanges(); return(Json(driver.IsActive, JsonRequestBehavior.AllowGet)); }
public DBResult SaveDriver(DriverModel model) { tblDriver driver = model.Id == 0 ? new tblDriver() : db.tblDrivers.FirstOrDefault(d => d.DriverID == model.Id); driver.Name = model.Name; driver.Surname = model.Surname; try { if (model.Id == 0) { db.tblDrivers.Add(driver); } db.SaveChanges(); return(new DBResult { ReturnCode = ReturnCode.Success }); } catch (Exception ex) { return(new DBResult { Message = ex.Message, ReturnCode = ReturnCode.Failed }); } }