public ActionResult DeleteConfirmed(int id)
{
tbl_vehicles tbl_vehicles = db.tbl_vehicles.Find(id);
db.tbl_vehicles.Remove(tbl_vehicles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,model,color,capacity,owner_id,created_at,created_by,license_no")] tbl_vehicles tbl_vehicles)
{
if (ModelState.IsValid)
{
db.Entry(tbl_vehicles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.owner_id = new SelectList(db.tbl_accounts, "id", "first_name", tbl_vehicles.owner_id);
return(View(tbl_vehicles));
}
// GET: tbl_vehicles/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_vehicles tbl_vehicles = db.tbl_vehicles.Find(id);
if (tbl_vehicles == null)
{
return(HttpNotFound());
}
return(View(tbl_vehicles));
}
public ActionResult Create([Bind(Include = "model,color,capacity,owner_id,license_no")] tbl_vehicles tbl_vehicles)
{
if (tbl_vehicles.owner_id == null)
{
tbl_vehicles.owner_id = UserSession.User.user_id;
}
if (ModelState.IsValid)
{
tbl_vehicles.created_at = DateTime.Now;
tbl_vehicles.created_by = UserSession.User.user_id;
db.tbl_vehicles.Add(tbl_vehicles);
db.SaveChanges();
var httpRequest = Request;
if (httpRequest.Files.Count > 0)
{
if (!Images.SaveImagesFromRequest(httpRequest, "en", "tbl_vehicles", tbl_vehicles.id, "main"))
{
//return Json(new { type = "success", message = "Upload images success" });
return(Json(new { type = "error", message = "Error while upload images" }));
}
}
if (Request.IsAjaxRequest())
{
return(Json(new { type = "success", message = "" }));
}
return(RedirectToAction("Create"));
}
List <string> errors = new List <string>();
foreach (var i in ModelState.Values)
{
if (i.Errors.Count > 0)
{
errors.AddRange(i.Errors.Select(a => a.ErrorMessage));
}
}
if (Request.IsAjaxRequest())
{
return(Json(new { type = "error", message = errors[0], data = errors }));
}
return(View(tbl_vehicles));
}
// GET: tbl_vehicles/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_vehicles tbl_vehicles = db.tbl_vehicles.Find(id);
if (tbl_vehicles == null)
{
return(HttpNotFound());
}
ViewBag.owner_id = new SelectList(db.tbl_accounts, "id", "first_name", tbl_vehicles.owner_id);
return(View(tbl_vehicles));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_vehicles tbl_vehicles = db.tbl_vehicles.Find(id);
if (tbl_vehicles == null)
{
return(HttpNotFound());
}
ViewBag.Images = db.tbl_images.Where(a => a.model_name == "tbl_vehicles" && a.model_id == id).ToList();
return(View(tbl_vehicles));
}
public ActionResult Edit([Bind(Include = "id,model,color,capacity,owner_id,license_no")] tbl_vehicles tbl_vehicles)
{
if (ModelState.IsValid)
{
var old = db.tbl_vehicles.Find(tbl_vehicles.id);
old.model = tbl_vehicles.model;
old.color = tbl_vehicles.color;
old.license_no = tbl_vehicles.license_no;
old.owner_id = tbl_vehicles.owner_id;
old.capacity = tbl_vehicles.capacity;
db.Entry(old).State = EntityState.Modified;
db.SaveChanges();
var httpRequest = Request;
if (httpRequest.Files.Count > 0)
{
if (!Images.SaveImagesFromRequest(httpRequest, "en", "tbl_vehicles", old.id, "main"))
{
//return Json(new { type = "success", message = "Upload images success" });
return(Json(new { type = "error", message = "Error while upload images" }));
}
}
if (Request.IsAjaxRequest())
{
return(Json(new { type = "success", message = "" }));
}
return(RedirectToAction("Edit", tbl_vehicles.id));
}
List <string> errors = new List <string>();
foreach (var i in ModelState.Values)
{
if (i.Errors.Count > 0)
{
errors.AddRange(i.Errors.Select(a => a.ErrorMessage));
}
}
if (Request.IsAjaxRequest())
{
return(Json(new { type = "error", message = errors[0], data = errors }));
}
return(View(tbl_vehicles));
}
public APIResult <ActAsOwnerResponse> actAsOwner(string ID = "")
{
tbl_vehicles vehicle = new tbl_vehicles()
{
license_no = HttpContext.Current.Request.Form["license_no"],
model = HttpContext.Current.Request.Form["model"],
color = HttpContext.Current.Request.Form["color"],
capacity = int.Parse(HttpContext.Current.Request.Form["capacity"].FirstOrDefault().ToString())
};
var returned = new ActAsOwnerResponse();
if (!Request.Content.IsMimeMultipartContent())
{
return(APIResult <ActAsOwnerResponse> .Error(ResponseCode.UserNotAcceptable, "Unsupported MediaType !"));
}
var u = APIRequest.User(HttpContext.Current.Request);
tbl_accounts acc;
using (var ctx = new MainEntities())
{
acc = ctx.tbl_accounts.Find(u.Entity.id);
}
if (u.Entity.mail_verified != true)
{
return(APIResult <ActAsOwnerResponse> .Error(ResponseCode.UserUnVerified, "Your email not verified, You must verify your email!"));
}
if (acc.id_no == "" && ID == "")
{
return(APIResult <ActAsOwnerResponse> .Error(ResponseCode.UserValidationField, "ID number is required!"));
}
if (ID == "")
{
ID = acc.id_no;
}
long vID = 0;
if (!long.TryParse(ID, out vID))
{
return(APIResult <ActAsOwnerResponse> .Error(ResponseCode.UserValidationField, "Invalid ID number!"));
}
vehicle.created_at = DateTime.Now;
vehicle.created_by = APIRequest.User(HttpContext.Current.Request).Entity.id;
vehicle.owner_id = vehicle.created_by;
using (var ctx = new MainEntities())
{
ctx.tbl_vehicles.Add(vehicle);
acc.id_no = vID.ToString();
ctx.tbl_accounts.Attach(acc);
ctx.Entry(acc).State = System.Data.Entity.EntityState.Modified;
if (u.hasRole("owner"))
{
ctx.sec_users_roles.Add(new sec_users_roles()
{
user_id = u.Entity.id, role_id = 2
});
}
if (ctx.SaveChanges() > 0)
{
if (u.hasRole("driver"))
{
ctx.tbl_drivers_vehicles_rel.Add(new tbl_drivers_vehicles_rel()
{
vehicle_id = vehicle.id,
created_at = DateTime.Now,
created_by = u.Entity.id,
driver_id = u.Entity.id,
status = 1
});
ctx.SaveChanges();
}
var httpRequest = HttpContext.Current.Request;
string errors = "";
foreach (string img in httpRequest.Files)
{
var postedFile = httpRequest.Files[img];
APIResult <tbl_images> result;
if (img == "ID_Image")
{
result = Images.SaveImageFromFile(postedFile, "tbl_accounts", u.Entity.id, "ID");
}
else
{
result = Images.SaveImageFromFile(postedFile, "tbl_vehicles", vehicle.id, "main");
}
if (!result.isSuccess)
{
errors += (errors == ""?"":", ") + result.message;
}
}
using (var imgCtx = new MainEntities())
{
returned.vehicles = imgCtx.tbl_vehicles.Where(a => a.owner_id == acc.id && a.is_delete != true)
.Select(
c => new VehicleResponse()
{
data = c,
images = new ImagesResponse()
{
Count = imgCtx.tbl_images.Where(d => d.model_name == "tbl_vehicles" && d.model_id == c.id && d.model_tag == "main").Count(),
Url = (imgCtx.tbl_images.Where(d => d.model_name == "tbl_vehicles" && d.model_id == c.id && d.model_tag == "main").Count() == 0)?"": "/img/scale/tbl_vehicles/" + c.id + "/original/main-{index}.gif"
}
// .Select(b => "/img/scale/tbl_vehicles/"+ b.model_id + "/original/main-"++".gif").ToList(),
}).ToList();
returned.ID = ID;
returned.ID_Image = string.Format("/img/scale/tbl_accounts/{0}/original/{1}-last.gif", acc.id, "ID");
}
return(APIResult <ActAsOwnerResponse> .Success(returned, "Save success"));
}
else
{
return(APIResult <ActAsOwnerResponse> .Error(ResponseCode.BackendDatabase, "Error while saving !"));
}
}
}
