public async Task <Result <EventOrganizerData> > FindEventOrganizerById(int eventId)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
EventOrganizerData eventi = await con.QueryFirstOrDefaultAsync <EventOrganizerData>(
@"select s.EventId,
s.CustomerId,
s.OrganizerId,
s.EventName,
s.Place,
s.MaximumPrice,
s.NumberOfGuestes,
s.Note,
s.WeddingDate
from weddingplanner.vEvent s
where s.EventId = @EventId;",
new { EventId = eventId });
if (eventi == null)
{
return(Result.Failure <EventOrganizerData>(Status.NotFound, "Event not found."));
}
return(Result.Success(eventi));
}
}
public async Task <Result <EventOrganizerData> > FindEventOrganizerById(int taskId)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
EventOrganizerData WishsData = await con.QueryFirstOrDefaultAsync <EventOrganizerData>(
@"select s.TaskId,
s.CustomerId,
s.Task,
s.StateTask
from weddingplanner.vWish s
where s.TaskId = @TaskId;",
new { TaskId = taskId });
if (WishsData == null)
{
return(Result.Failure <EventOrganizerData>(Status.NotFound, "wish not found."));
}
return(Result.Success(WishsData));
}
}
