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