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 int DeleteRegistration(int id)
{
using (var entity = new VehicleRegistrationContext())
{
var IsActive = (from m in entity.VehicleDetails
where m.VehicleId == id
select m).SingleOrDefault();
IsActive.IsActive = false;
int flag = entity.SaveChanges();
string registrationNumber = IsActive.VehicleNumber;
return(flag);
}
}
public void AddData()
{
using (var entity = new VehicleRegistrationContext())
{
UserInfo add = new UserInfo();
add.Username = "******";
add.Password = "******";
add.Firstname = "James";
add.Lastname = "G";
entity.UserInfos.Add(add);
entity.SaveChanges();
}
}
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);
}
}
}
