public ActionResult Detail(int id) { tblVehicle vehicle = dc.tblVehicles.SingleOrDefault(ob => ob.VehicleId == id); ViewBag.CompanyName = (from ob in dc.tblTransportCompanies where ob.CompanyId == vehicle.CompanyId select ob).Take(1).SingleOrDefault().CompanyName; string Name = ViewBag.CompanyName; return(View(vehicle)); }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { ViewBag.SubMenus = db.tblSubMenus.ToList(); ViewBag.Action = "Create New Item"; return(View(new ItemViewModel())); } } else { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { ViewBag.Action = "Edit Item"; ViewBag.Menus = db.tblSubMenus.ToList(); tblVehicle item = db.tblVehicles.Where(i => i.VehicleId == id).FirstOrDefault(); ItemViewModel itemvm = new ItemViewModel(); itemvm.ItemId = item.VehicleId; itemvm.SubMenuId = Convert.ToInt32(item.SubmenuId); itemvm.Title = item.Title; itemvm.Price = item.Price; itemvm.Description = item.Description; itemvm.SmallImage = item.SmallImage; itemvm.LargeImage = item.LargeImage; //HttpPostedFileBase fup = Request.Files["SmallImage"]; //if(fup!=null) //{ // if(fup.FileName!="") // { // fup.SaveAs(Server.MapPath("~/img/dogaccessories" + fup.FileName)); // } //} //HttpPostedFileBase fup1 = Request.Files["LargeImage"]; //if (fup1 != null) //{ // if (fup1.FileName != "") // { // fup1.SaveAs(Server.MapPath("~/img/dogaccessories" + fup1.FileName)); // itemvm.LargeImage = item.LargeImage; // } //} itemvm.IsAvailable = "Available"; ViewBag.SubMenus = db.tblSubMenus.ToList(); return(View(itemvm)); } } }
public ActionResult Delete(int id) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { tblVehicle sm = db.tblVehicles.Where(x => x.VehicleId == id).FirstOrDefault(); db.tblVehicles.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public void AddNewVehicle() { string vehicleMake = "TOYOTA"; string vehicleModel = "HIACE VAN"; string country = "Japanese"; string defined = "Super Robinson"; string general = "campertronic"; if (!CheckVehicleExists(vehicleMake, vehicleModel)) { bool countryExists = CheckCountryExists(country); bool definedExists = CheckDefinedTypeExists(defined); bool generalExists = CheckGeneralTypeExists(general); // Create new vehicle object. var vehicle = new tblVehicle(); vehicle.Vehicle_Make = "Toyota"; vehicle.Vehicle_Model = "Camroad"; if (countryExists) { SelectExistingCountry(vehicle, "Japanese"); } else { // Create new country } if (generalExists) { var db2 = new seleniumScrapeEntities(); // Set the Vehicle Defined Type FK (in vehicle table) SelectExistingGeneralType(vehicle, "Camper"); } else { // Create new Defined Type. } if (definedExists) { SelectExistingDefinedType(vehicle, "MonsterCar"); } else { // Create new general type. } } }
private void SelectExistingGeneralType(tblVehicle vehicle, string generalType) { var db2 = new seleniumScrapeEntities(); // Set the Vehicle Country of Origin FK (in vehicle table) vehicle.Vehicle_Type_General_id_fk = db2.tblVehicleTypeGenerals.Where(x => x.VehicleTypeGeneral == generalType).Select( x => x.VehicleTypeGeneral_pk).SingleOrDefault(); db2.Dispose(); }
private void SelectExistingCountry(tblVehicle vehicle, string country) { var db2 = new seleniumScrapeEntities(); // Set the Vehicle Country of Origin FK (in vehicle table) vehicle.Vehicle_Type_ID_fk = db2.tblVehicleTypeCountries.Where(x => x.Vehicle_Type_Country == country).Select( x => x.Vehicle_Type_Country_ID_pk).SingleOrDefault(); db2.Dispose(); }
private void SelectExistingDefinedType(tblVehicle vehicle, string definedType) { var db2 = new seleniumScrapeEntities(); // Set the Vehicle Country of Origin FK (in vehicle table) vehicle.Vehicle_Type_Defined_fk = db2.tblVehicleTypeDefineds.Where(x => x.VehicleTypeDefined == definedType).Select( x => x.VehicleTypeDefined_id_pk).SingleOrDefault(); db2.Dispose(); }
public JsonResult Active(int id) { tblVehicle vehicle = dc.tblVehicles.SingleOrDefault(ob => ob.VehicleId == id); if (vehicle.IsActive == true) { vehicle.IsActive = false; } else { vehicle.IsActive = true; } dc.SaveChanges(); return(Json(vehicle.IsActive, JsonRequestBehavior.AllowGet)); }
public ActionResult AddVehicle(FormCollection form, HttpPostedFileBase txtImage, HttpPostedFileBase txtVimage) { string name = "txtImage"; if (txtImage != null) { int size = (int)txtImage.ContentLength / 1024; var extention = System.IO.Path.GetExtension(txtImage.FileName); if (size <= 1024 && (extention.ToLower().Equals(".jpg") || extention.ToLower().Equals(".jpeg") || extention.ToLower().Equals(".png"))) { name = Code() + "" + extention; string path = Server.MapPath("~/Images/"); txtImage.SaveAs(path + "" + name); } } string vehiclename = "txtVimage"; if (txtVimage != null) { int size = (int)txtVimage.ContentLength / 1024; var extention = System.IO.Path.GetExtension(txtVimage.FileName); if (size <= 1024 && (extention.ToLower().Equals(".jpg") || extention.ToLower().Equals(".jpeg") || extention.ToLower().Equals(".png"))) { vehiclename = Code() + "" + extention; string path = Server.MapPath("~/Images/"); txtVimage.SaveAs(path + "" + name); } } tblVehicle vehicle = new tblVehicle(); vehicle.CompanyId = Convert.ToInt32(Session["CompanyId"]); vehicle.VehicleTypeId = Convert.ToInt32(form["vehicletype"]); vehicle.VehicleName = form["txtVname"]; vehicle.RegNo = form["txtRno"]; vehicle.DocumentImage = name.ToString(); vehicle.Fuel = form["txtFuel"]; vehicle.Capacity = form["txtCapacity"]; vehicle.IsActive = true; vehicle.Image = vehiclename.ToString(); dc.tblVehicles.Add(vehicle); dc.SaveChanges(); return(RedirectToAction("CompanyProfile", "ClientCompany", new { id = vehicle.CompanyId })); }
public static tblVehicle CreatetblVehicle(long vehicleID, string branchId) { tblVehicle tblVehicle = new tblVehicle(); tblVehicle.VehicleID = vehicleID; tblVehicle.BranchId = branchId; return tblVehicle; }
public void AddTotblVehicles(tblVehicle tblVehicle) { AddObject("tblVehicles", tblVehicle); }
public static tblVehicle CreatetblVehicle(int vehicleID) { tblVehicle tblVehicle = new tblVehicle(); tblVehicle.VehicleID = vehicleID; return tblVehicle; }
public ActionResult AddOrEdit(ItemViewModel ivm) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { if (ivm.ItemId == 0) { tblVehicle itm = new tblVehicle(); itm.SubmenuId = Convert.ToInt32(ivm.SubMenuId); itm.Title = ivm.Title; itm.Price = ivm.Price; itm.Description = ivm.Description; HttpPostedFileBase fup = Request.Files["SmallImage"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName)); itm.SmallImage = fup.FileName; } } HttpPostedFileBase fup1 = Request.Files["LargeImage"]; if (fup1 != null) { if (fup1.FileName != "") { fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName)); itm.LargeImage = fup1.FileName; } } itm.IsAvailable = "Available"; db.tblVehicles.Add(itm); db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } else { tblVehicle itm = db.tblVehicles.Where(i => i.VehicleId == ivm.ItemId).FirstOrDefault(); itm.SubmenuId = Convert.ToInt32(ivm.SubMenuId); itm.Title = ivm.Title; itm.Price = ivm.Price; itm.Description = ivm.Description; HttpPostedFileBase fup = Request.Files["SmallImage"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName)); itm.SmallImage = fup.FileName; } } HttpPostedFileBase fup1 = Request.Files["LargeImage"]; if (fup1 != null) { if (fup1.FileName != "") { fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName)); itm.LargeImage = fup1.FileName; } } db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } ViewBag.SubMenus = db.tblSubMenus.ToList(); return(View(new ItemViewModel())); } }
public void SaveNewVehicleToDB(tblVehicle vehicle) { var vehicleSaver = new VehicleSaver(); vehicleSaver.SaveToDB(vehicle); }