public async Task SaveOrUpdateRouteAsync(Route route) { try { DataTable dt = new DataTable(); dt.Columns.Add("CheckPointID", typeof(int)); dt.Columns.Add("EstimatedKM", typeof(decimal)); dt.Columns.Add("EstimatedArrivalMinutes", typeof(int)); foreach (var checkPoint in route.CheckPoints) { var dr = dt.NewRow(); dr["CheckPointID"] = checkPoint.CheckPointID; dr["EstimatedKM"] = checkPoint.EstimatedKM; dr["EstimatedArrivalMinutes"] = checkPoint.EstimatedArrivalMinutes; dt.Rows.Add(dr); } await _dao.ExecuteNonQueryAsync("[usp_SaveOrUpdateRoute]", CommandType.StoredProcedure, args => { args.Add("@RouteID", route.RouteID); args.Add("@RouteName", route.RouteName); args.Add("@TotalKM", route.TotalKM); args.Add("@CreatedBy", route.CreatedBy); args.Add("@CheckPoints", dt); }); } catch (Exception) { throw; } }
public async Task SaveOrUpdateVehicle(Vehicle vehicle) { try { await _dao.ExecuteNonQueryAsync("usp_SaveOrUpdateVehicle", CommandType.StoredProcedure, args => { args.Add("@VehicleID", vehicle.VehicleID); args.Add("@VehicleNo", vehicle.VehicleNo); args.Add("@ModelNo", vehicle.ModelNo); args.Add("@Color", vehicle.Color); args.Add("@PassengerCapacity", vehicle.PassengerCapacity); args.Add("@CubicCapacity", vehicle.CubicCapacity); args.Add("@PurchasedDate", vehicle.PurchasedDate); args.Add("@OwnerName", vehicle.OwnerName); args.Add("@OwnerContact", vehicle.OwnerContact); args.Add("@OwnerAddress", vehicle.OwnerAddress); args.Add("@DriverName", vehicle.DriverName); args.Add("@DriverContact", vehicle.DriverContact); args.Add("@DriverAdddress", vehicle.DriverAdddress); args.Add("@CreatedBy", vehicle.CreatedBy); }); } catch (Exception) { throw; } }
public async Task SaveOrUpdateCheckPoint(CheckPoint checkPoint) { try { await _dao.ExecuteNonQueryAsync("[usp_SaveOrUpdateCheckPoints]", CommandType.StoredProcedure, args => { args.Add("@CheckPointID", checkPoint.CheckPointID); args.Add("@CheckPointName", checkPoint.CheckPointName); args.Add("@CreatedBy", checkPoint.CreatedBy); }); } catch (Exception) { throw; } }
public async Task SaveOrUpdateUserAsync(User user) { try { await _dao.ExecuteNonQueryAsync("[usp_SaveOrUpdateUser]", CommandType.StoredProcedure, args => { args.Add("@UserID", user.UserID); args.Add("@UserName", user.UserName); args.Add("@Password", user.Password); args.Add("@FullName", user.FullName); args.Add("@UserRoleID", user.UserRoleID); args.Add("@Contact", user.Contact); args.Add("@Email", user.Email); args.Add("@Address", user.Address); args.Add("@VehicleID", user.VehicleID); args.Add("@CreatedBy", user.CreatedBy); }); } catch (Exception) { throw; } }
public async Task DeleteTripAsync(Transaction transaction) { try { await _dao.ExecuteNonQueryAsync("[usp_DeleteTransactions]", CommandType.StoredProcedure, args => { args.Add("@TrasactionID", transaction.TrasactionID); args.Add("@DeletedBy", transaction.CreatedBy); }); } catch (Exception) { throw; } }