public ActionResult RegistrationAdd(CompleteDetailsViewModel addRegistration)
{
int exists = userBll.checkIfExists(Convert.ToInt32(TempData["id"]));
if (exists == 0)
{
int count = userBll.AddVehicle(addRegistration);
if (count == 2)
{
TempData["message"] = "Succesfully Added";
return(RedirectToAction("Home", "User"));
}
else
{
TempData["message"] = "Cannot be added as the Vehicle number already exists";
return(RedirectToAction("Home", "User"));
}
}
else
{
int isEdit = userBll.EditVehicleRegistration(Convert.ToInt32(TempData["VehicleId"]), addRegistration);
if (isEdit == 2)
{
TempData["message"] = "Succesfully Edited";
return(RedirectToAction("Home", "User"));
}
else
{
TempData["message"] = "Cannot be Edited";
return(RedirectToAction("Home", "User"));
}
}
}
public ActionResult AddRegistration()
{
ViewBag.text = "Add Registration:";
ViewBag.button = "Add";
CompleteDetailsViewModel add = userBll.BindDropdown();
return(View(add));
}
public int VehicleRegisterEdit(int id, CompleteDetailsViewModel edit)
{
using (var entity = new VehicleRegistrationContext())
{
using (System.Data.Entity.DbContextTransaction dbTran = entity.Database.BeginTransaction())
{
try
{
var details = (from m in entity.VehicleDetails
where m.VehicleId == id
select m).FirstOrDefault();
details.VehicleNameId = edit.VehicleNameId;
details.Colour = edit.Colour;
details.ChasisNumber = edit.ChasisNumber;
entity.SaveChanges();
var nameCount = (from n in entity.OwnerDetails
where n.OwnerName == edit.OwnerName
select n.OwnerName).Count();
if (nameCount == 0)
{
OwnerDetail addOwner = new OwnerDetail();
addOwner.OwnerName = edit.OwnerName;
addOwner.Address = edit.Address;
addOwner.Country = edit.CountryId;
entity.OwnerDetails.Add(addOwner);
entity.SaveChanges();
}
var ownerId = (from o in entity.OwnerDetails
where o.OwnerName == edit.OwnerName
select o.Id).FirstOrDefault();
var ownerNewDetails = (from m in entity.OwnerVehicleIntermediates
join n in entity.OwnerDetails
on m.OwnerId equals n.Id
join v in entity.VehicleDetails
on m.VehiclesId equals v.VehicleId
where v.VehicleId == id
select m).FirstOrDefault();
ownerNewDetails.OwnerId = ownerId;
int set = entity.SaveChanges();
dbTran.Commit();
return(2);
}
catch
{
dbTran.Rollback();
return(0);
}
}
}
}
public CompleteDetailsViewModel BindDropdown()
{
CompleteDetailsViewModel addNew = new CompleteDetailsViewModel();
addNew.CountryList = userDal.CountryDropdown();
addNew.OwnerList = userDal.OwnerDropdown();
addNew.NameList = userDal.NameDropdown();
return(addNew);
}
public ActionResult RegistrationEditing(int id)
{
TempData["id"] = id;
TempData["VehicleId"] = id;
CompleteDetailsViewModel getDetails = new CompleteDetailsViewModel();
ViewBag.toEdit = "Editing";
getDetails = userBll.GetEditDetails(id);
ViewBag.text = "Edit Registration";
ViewBag.button = "Save";
return(View("AddRegistration", getDetails));
}
public CompleteDetailsViewModel GetEditDetails(int id)
{
ViewAllList details = userDal.ViewDetails(id);
CompleteDetailsViewModel edit = new CompleteDetailsViewModel();
edit.CountryList = userDal.CountryDropdown();
edit.OwnerList = userDal.OwnerDropdown();
edit.NameList = userDal.NameDropdown();
edit.VehicleName = details.VehicleName;
edit.CountryName = details.Country;
edit.VehicleNumber = details.VehicleNumber;
edit.Colour = details.Colour;
edit.ChasisNumber = details.ChasisNumber;
edit.OwnerName = details.OwnerName;
edit.Address = details.Address;
edit.Date = details.Date;
return(edit);
}
public int AddRegistration(CompleteDetailsViewModel addNew)
{
using (var entity = new VehicleRegistrationContext())
{
var vehicleUniqueness = (from m in entity.VehicleDetails
where m.VehicleNumber == addNew.VehicleNumber
select m.VehicleNumber).Count();
var nameCount = (from n in entity.OwnerDetails
where n.OwnerName == addNew.OwnerName
select n.OwnerName).Count();
if (vehicleUniqueness == 0)
{
VehicleDetail addVehicle = new VehicleDetail();
addVehicle.VehicleNumber = addNew.VehicleNumber;
addVehicle.VehicleNameId = addNew.VehicleNameId;
addVehicle.ChasisNumber = addNew.ChasisNumber;
addVehicle.Colour = addNew.Colour;
DateTime dateAndTime = DateTime.Today;
addVehicle.Date = dateAndTime.ToString("dd-MM-yyyy");
addVehicle.IsActive = true;
using (System.Data.Entity.DbContextTransaction dbTran = entity.Database.BeginTransaction())
{
try
{
entity.VehicleDetails.Add(addVehicle);
entity.SaveChanges();
var id = (from m in entity.VehicleDetails
orderby m.VehicleId descending
select m.VehicleId).FirstOrDefault();
if (nameCount == 0)
{
OwnerDetail addOwner = new OwnerDetail();
addOwner.OwnerName = addNew.OwnerName;
addOwner.Country = addNew.CountryId;
addOwner.Address = addNew.Address;
entity.OwnerDetails.Add(addOwner);
entity.SaveChanges();
}
var ownerId = (from o in entity.OwnerDetails
where o.OwnerName == addNew.OwnerName
select o.Id).FirstOrDefault();
OwnerVehicleIntermediate addDetails = new OwnerVehicleIntermediate();
addDetails.VehiclesId = Convert.ToInt32(id);
addDetails.OwnerId = ownerId;
entity.OwnerVehicleIntermediates.Add(addDetails);
entity.SaveChanges();
dbTran.Commit();
return(2);
}
catch
{
dbTran.Rollback();
return(0);
}
}
}
else
{
return(0);
}
}
}
public int AddVehicle(CompleteDetailsViewModel addVehicle)
{
int count = userDal.AddRegistration(addVehicle);
return(count);
}
public int EditVehicleRegistration(int id, CompleteDetailsViewModel editRegistration)
{
int editCount = userDal.VehicleRegisterEdit(id, editRegistration);
return(editCount);
}
