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