//public bool AddNewUser(UserDetails user) // { // user.Id = Guid.NewGuid().ToString(); // string query = "insert into [User](Id,Name,Email,Password) values(@Id,@Name,@Email,@Password)"; // DynamicParameters parameters = new DynamicParameters(); // parameters.Add("Id", user.Id); // parameters.Add("Name", user.Name); // parameters.Add("Email", user.Email); // parameters.Add("Password", user.Password); // ExtensionObject extensionObject = new ExtensionObject() // { // Query = query, // ConnectionString = connectionString // }; // return extensionObject.AddOrUpdateItem<UserDetails>(parameters); // } public string AddUser(User user) { user.Id = Guid.NewGuid().ToString(); string query = "insert into [User](Id,Name,Email,PhoneNumber,Address,Gender,Password) values(@Id,@Name,@Email,@PhoneNumber,@Address,@Gender,@Password)"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", user.Id); parameters.Add("Name", user.Name); parameters.Add("Email", user.Email); parameters.Add("PhoneNumber", user.PhoneNumber); parameters.Add("Address", user.Address); parameters.Add("Gender", user.Gender); parameters.Add("Password", user.Password); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; if (extensionObject.AddOrUpdateItem <User>(parameters)) { return(user.Id); } else { return(null); } }
public string AddVehicle(Vehicle vehicle) { string query = "insert into Vehicle(Id,UserId,Model,Number,VehicleTypeId,IsActive) values(@Id,@UserId,@Model,@Number,@vehicleTypeId,@IsActive)"; vehicle.Id = Guid.NewGuid().ToString(); vehicle.IsActive = true; string vehicleTypeQuery = "select * from VehicleType where Name='Four-Wheeler'"; ExtensionObject vehicleTypeExtensionObject = new ExtensionObject() { Query = vehicleTypeQuery, ConnectionString = connectionString }; string VehicleTypeId = vehicleTypeExtensionObject.GetItem <VehicleType>().Id; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", vehicle.Id); parameters.Add("UserId", vehicle.UserId); parameters.Add("Model", vehicle.Model); parameters.Add("Number", vehicle.Number); parameters.Add("VehicleTypeId", VehicleTypeId); parameters.Add("IsActive", vehicle.IsActive); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; extensionObject.AddOrUpdateItem <Vehicle>(parameters); return(vehicle.Id); }
public bool AddViaPoint(ViaPoint viaPoint) { string query = "insert into ViaPoint(Id,RideId,Name,[Index],Distance) values(@Id,@RideId,@Name,@Index,@Distance)"; DynamicParameters parameters = new DynamicParameters(); string viaPointId = Guid.NewGuid().ToString(); parameters.Add("Id", viaPointId); parameters.Add("RideId", viaPoint.RideId); parameters.Add("Name", viaPoint.Name.ToLower()); parameters.Add("Index", viaPoint.Index); parameters.Add("Distance", viaPoint.Distance); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; if (extensionObject.AddOrUpdateItem <ViaPoint>(parameters)) { return(true); } else { return(false); } }
public bool UpdateRide(Ride ride) { if (ride.Status.Value == "Cancelled") { string statusQuery = "select * from Status where Type='Ride' and Value='Cancelled'"; ExtensionObject statusExtensionObject = new ExtensionObject() { Query = statusQuery, ConnectionString = connectionString }; string rideStatusId = statusExtensionObject.GetItem <Status>().Id; string query = "update Ride set StatusId=@StatusId where Id=@Id"; ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", ride.Id); parameters.Add("StatusId", rideStatusId); if (extensionObject.AddOrUpdateItem <Ride>(parameters)) { IBookingService bookingService = new BookingService(configuration); return(bookingService.CancelAllBookingsByRideId(ride.Id)); } return(false); } else { string query = "update Ride set AutoApproveRide=@AutoApproveRide, VehicleId=@VehicleId, StatusId=@statusId where Id=@Id"; string statusQuery = "select * from Status where Type='Ride' and Value='" + ride.Status.Value + "'"; ExtensionObject statusExtensionObject = new ExtensionObject() { Query = statusQuery, ConnectionString = connectionString }; string statusId = statusExtensionObject.GetItem <Status>().Id; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", ride.Id); parameters.Add("AutoApproveRide", ride.AutoApproveRide); parameters.Add("VehicleId", ride.Vehicle.Id); parameters.Add("StatusId", statusId); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <Booking>(parameters)); } }
public int AddBooking(Booking booking) { IRideService rideService = new RideService(configuration); Ride ride = rideService.GetRideById(booking.Ride.Id); ride.Id = booking.Ride.Id; int availableSeats = AvailableSeats(ride, booking.PickUp, booking.Drop); if (availableSeats >= booking.NumberOfSeatsBooked) { string query = "insert into Booking(Id,RideId,PickUp,[Drop],BookedBy,Price,StatusId,BookingTime,NumberOfSeatsBooked)" + " values(@Id,@RideId,@PickUp,@Drop,@BookedBy,@Price,@StatusId,@BookingTime,@NumberOfSeatsBooked)"; booking.Id = Guid.NewGuid().ToString(); string statusQuery = "select * from Status where Type='Booking' and Value='Pending'"; ExtensionObject statusExtensionObject = new ExtensionObject() { Query = statusQuery, ConnectionString = connectionString }; string statusId = statusExtensionObject.GetItem <Status>().Id; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", booking.Id); parameters.Add("RideId", booking.Ride.Id); parameters.Add("PickUp", booking.PickUp); parameters.Add("Drop", booking.Drop); parameters.Add("BookedBy", booking.BookedBy.Id); parameters.Add("Price", booking.Price); parameters.Add("StatusId", statusId); parameters.Add("BookingTime", booking.BookingTime); parameters.Add("NumberOfSeatsBooked", booking.NumberOfSeatsBooked); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; if (extensionObject.AddOrUpdateItem <Booking>(parameters)) { return(1); } else { return(0); } } else { return(-1); } }
public bool UpdateStatus(Status status) { string query = "update Status set Type=@Type and Value=@Value where Id=@Id"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", status.Id); parameters.Add("Type", status.Type); parameters.Add("Value", status.Value); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <Status>(parameters)); }
public bool AddStatus(Status status) { string query = "insert into Status(Id,Type,Value) values(@Id,@Type,@Value)"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", Guid.NewGuid().ToString()); parameters.Add("Type", status.Type); parameters.Add("Value", status.Value); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <Status>(parameters)); }
public bool UpdateVehicleType(VehicleType vehicleType) { string query = "update VehicleType set Name=@Name,MaximumFare=@MaximumFare,MaximumSeats=@MaximumSeats where Id=@Id"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", Guid.NewGuid().ToString()); parameters.Add("Name", vehicleType.Name); parameters.Add("MaximumFare", vehicleType.MaximumFare); parameters.Add("MaximumSeats", vehicleType.MaximumSeats); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <VehicleType>(parameters)); }
public bool AddVehicleType(VehicleType vehicleType) { string query = "insert into VehicleType(Id,Name,MaximumFare,MaximumSeats) values(@Id,@Name,@MaximumFare,@MaximumSeats)"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", Guid.NewGuid().ToString()); parameters.Add("Name", vehicleType.Name); parameters.Add("MaximumFare", vehicleType.MaximumFare); parameters.Add("MaximumSeats", vehicleType.MaximumSeats); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <VehicleType>(parameters)); }
public string AddRide(Ride ride) { string query = "insert into Ride(Id,PublisherId,PickUp,[Drop],StartDate,NumberOfSeats,Price,VehicleId,AutoApproveRide,StatusId) " + "values(@Id,@PublisherId,@PickUp,@Drop,@StartDate,@NumberOfSeats,@Price,@VehicleId,@AutoApproveRide,@Status)"; DynamicParameters parameters = new DynamicParameters(); ride.Id = Guid.NewGuid().ToString(); string statusQuery = "select * from Status where Type='Ride' and Value='Not Started'"; ExtensionObject statusExtensionObject = new ExtensionObject() { Query = statusQuery, ConnectionString = connectionString }; string rideStatusId = statusExtensionObject.GetItem <Status>().Id; ride.AutoApproveRide = false; parameters.Add("Id", ride.Id); parameters.Add("PublisherId", ride.Publisher.Id); parameters.Add("PickUp", ride.PickUp.ToLower()); parameters.Add("Drop", ride.Drop.ToLower()); parameters.Add("StartDate", ride.StartDate); parameters.Add("NumberOfSeats", ride.NumberOfSeats); //parameters.Add("AvailableSeats", ride.AvailableSeats); parameters.Add("Price", ride.Price); parameters.Add("VehicleId", ride.Vehicle.Id); parameters.Add("AutoApproveRide", ride.AutoApproveRide); parameters.Add("Status", rideStatusId); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; if (extensionObject.AddOrUpdateItem <Ride>(parameters)) { return(ride.Id); } else { return(null); } }
public bool LogException(string exception, string methodName) { string query = "insert into Log(Id,Method,Exception,TimeStamp) values(@Id,@Method,@Exception,@TimeStamp)"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", Guid.NewGuid().ToString()); parameters.Add("Method", methodName); parameters.Add("Exception", exception); parameters.Add("Timestamp", DateTime.Now); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <Log>(parameters)); }
public bool UpdateUser(User user) { string query = "update [User] set Name=@Name,Email=@Email,PhoneNumber=@PhoneNumber,Address=@Address,Password=@Password where Id=@Id"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", user.Id); parameters.Add("Name", user.Name); parameters.Add("Email", user.Email); parameters.Add("PhoneNumber", user.PhoneNumber); parameters.Add("Address", user.Address); parameters.Add("Password", user.Password); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <User>(parameters)); }
public bool UpdateVehicle(Vehicle vehicle) { string query = "update Vehicle set Model=@Model,Number=@Number,VehicleTypeId=@vehicleTypeId,IsActive=@IsActive where Id=@Id)"; vehicle.Id = Guid.NewGuid().ToString(); DynamicParameters parameters = new DynamicParameters(); parameters.Add("Id", vehicle.Id); parameters.Add("Model", vehicle.Model); parameters.Add("Number", vehicle.Number); parameters.Add("VehicleTypeId", vehicle.VehicleType.Id); parameters.Add("IsActive", vehicle.IsActive); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <Vehicle>(parameters)); }
public bool CancelAllBookingsByRideId(string rideId) { string statusQuery = "select * from Status where Type='Booking' and Value='Cancelled'"; ExtensionObject statusExtensionObject = new ExtensionObject() { Query = statusQuery, ConnectionString = connectionString }; string statusId = statusExtensionObject.GetItem <Status>().Id; string query = "update Booking set StatusId=@statusId where RideId=@RideId"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("RideId", rideId); parameters.Add("StatusId", statusId); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; return(extensionObject.AddOrUpdateItem <Booking>(parameters)); }
public int UpdateBooking(Booking booking) { IRideService rideService = new RideService(configuration); Ride ride = rideService.GetRideById(booking.Ride.Id); ride.Id = booking.Ride.Id; int availableSeats = AvailableSeats(ride, booking.PickUp, booking.Drop); if (booking.Status.Value == "Rejected") { string query = "update Booking set PickUp=@PickUp,[Drop]=@Drop" + ",StatusId=@Status,NumberOfSeatsBooked=@NumberOfSeatsBooked where Id=@Id"; DynamicParameters parameters = new DynamicParameters(); string statusQuery = "select * from Status where Type='Booking' and Value='" + booking.Status.Value + "'"; ExtensionObject statusExtensionObject = new ExtensionObject() { Query = statusQuery, ConnectionString = connectionString }; string statusId = statusExtensionObject.GetItem <Status>().Id; parameters.Add("Id", booking.Id); parameters.Add("PickUp", booking.PickUp); parameters.Add("Drop", booking.Drop); parameters.Add("Status", statusId); parameters.Add("NumberOfSeatsBooked", booking.NumberOfSeatsBooked); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; //new { booking.Id, booking.PickUp, booking.Drop, booking.Status, booking.NumberOfSeatsBooked }); if (extensionObject.AddOrUpdateItem <Booking>(parameters)) { return(1); } else { return(0); } } else if (booking.Status.Value == "Approved" && availableSeats >= booking.NumberOfSeatsBooked) { string query = "update Booking set PickUp=@PickUp,[Drop]=@Drop" + ",StatusId=@Status,NumberOfSeatsBooked=@NumberOfSeatsBooked where Id=@Id"; DynamicParameters parameters = new DynamicParameters(); string statusQuery = "select * from Status where Type='Booking' and Value='" + booking.Status.Value + "'"; ExtensionObject statusExtensionObject = new ExtensionObject() { Query = statusQuery, ConnectionString = connectionString }; string statusId = statusExtensionObject.GetItem <Status>().Id; parameters.Add("Id", booking.Id); parameters.Add("PickUp", booking.PickUp); parameters.Add("Drop", booking.Drop); parameters.Add("Status", statusId); parameters.Add("NumberOfSeatsBooked", booking.NumberOfSeatsBooked); ExtensionObject extensionObject = new ExtensionObject() { Query = query, ConnectionString = connectionString }; //new { booking.Id, booking.PickUp, booking.Drop, booking.Status, booking.NumberOfSeatsBooked }); if (extensionObject.AddOrUpdateItem <Booking>(parameters)) { return(1); } else { return(0); } } return(-1); }