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