public List <ViewAllList> RegistrationsViewall() { using (var entity = new VehicleRegistrationContext()) { var details = (from i in entity.OwnerVehicleIntermediates join v in entity.VehicleDetails on i.VehiclesId equals v.VehicleId join o in entity.OwnerDetails on i.OwnerId equals o.Id join c in entity.VehicleNames on v.VehicleNameId equals c.NameId where v.IsActive == true select new ViewAllList() { VehicleId = v.VehicleId, VehicleNumber = v.VehicleNumber, VehicleName = c.Name, OwnerName = o.OwnerName, Date = v.Date }).ToList(); return(details); } }
public ViewAllList ViewDetails(int id) { using (var entity = new VehicleRegistrationContext()) { var details = (from i in entity.OwnerVehicleIntermediates join v in entity.VehicleDetails on i.VehiclesId equals v.VehicleId join o in entity.OwnerDetails on i.OwnerId equals o.Id join c in entity.VehicleNames on v.VehicleNameId equals c.NameId join y in entity.Countrys on o.Country equals y.CountryId where v.VehicleId == id select new ViewAllList() { VehicleId = v.VehicleId, VehicleNumber = v.VehicleNumber, VehicleName = c.Name, VehicleNameId = c.NameId, CountryId = y.CountryId, OwnerName = o.OwnerName, Address = o.Address, Country = y.CountryName, Colour = v.Colour, VehicleType = c.VehicleType, ChasisNumber = v.ChasisNumber, Date = v.Date }).FirstOrDefault(); return(details); } }
public UserInfos GetUserDetails(string Username) { using (var entity = new VehicleRegistrationContext()) { var checkUserExisting = (from u in entity.UserInfos where u.Username == Username select u.Username).Count(); if (checkUserExisting != 0) { var getUserDetails = (from u in entity.UserInfos where u.Username == Username select new UserInfos() { UserId = u.UserId, Username = u.Username, Password = u.Password, Firstname = u.Firstname, Lastname = u.Lastname }).FirstOrDefault(); return(getUserDetails); } else { return(null); } } }
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 CheckExists(int id) { using (var entity = new VehicleRegistrationContext()) { var checkUserExisting = (from u in entity.VehicleDetails where u.VehicleId == id select u.VehicleId).Count(); return(checkUserExisting); } }
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 List <SelectListItem> NameDropdown() { using (var entity = new VehicleRegistrationContext()) { var name = (from m in entity.VehicleNames select new SelectListItem() { Value = m.NameId.ToString(), Text = m.Name }).ToList(); return(name); } }
public List <SelectListItem> OwnerDropdown() { using (var entity = new VehicleRegistrationContext()) { var owner = (from m in entity.OwnerDetails select new SelectListItem() { Value = m.OwnerName, Text = m.OwnerName }).ToList(); return(owner); } }
public List <SelectListItem> CountryDropdown() { using (var entity = new VehicleRegistrationContext()) { var country = (from m in entity.Countrys select new SelectListItem() { Value = m.CountryId.ToString(), Text = m.CountryName }).ToList(); return(country); } }
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); } } }