// Post
public Task Add(EventManagementModel value)
{
Events.Add(
value.With(id: Guid.NewGuid())
);
return(Task.CompletedTask);
}
public async Task <ActionResult> Put(Guid id, EventManagementModel value)
{
if (value.Id != id)
{
return(BadRequest());
}
await _repo.Update(value);
return(Ok());
}
// Put
public Task Update(EventManagementModel value)
{
var singleEvent = Events.SingleOrDefault(@event => @event.Id == value.Id);
if (singleEvent != null)
{
Events.Remove(singleEvent);
}
Events.Add(value);
return(Task.CompletedTask);
}
public ActionResult Save(EventManagementModel model)
{
EventResponse response = new EventResponse()
{
Status = false
};
if (objEvents.Save(model) > 0)
{
response.Status = true;
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
// Post
public Task Add(EventManagementModel value)
{
using (var dbConnection = GetConnection())
{
dbConnection.Open();
return(Task.FromResult(
dbConnection.Execute(
@"INSERT INTO event_management (id, title, description, event_location, event_start_date, event_end_date, registration_open_date, registration_close_date)
VALUES(@Id, @Title, @Description, @EventLocation, @EventStartDate, @EventEndDate, @RegistrationOpenDate, @RegistrationCloseDate)",
new { Id = value.Id, Title = value.Title.Value, Description = value.Description.Value, EventLocation = value.EventLocation.Value, EventStartDate = value.EventStartDate.Value, EventEndDate = value.EventEndDate.Value, RegistrationOpenDate = value.RegistrationOpenDate.Value, RegistrationCloseDate = value.RegistrationCloseDate.Value }
)));
}
}
internal void Update(EventManagementModel model)
{
EventManagement newobj = objData.EventManagements.Where(p => p.EventId == model.EventId).FirstOrDefault(); //GetVendorTypes().Where(p => p.VendorTypeId == model.VendorTypeId).FirstOrDefault();
if (newobj != null)
{
newobj.ContactPerson = model.ContactPerson;
newobj.EventDate = model.EventDate;
newobj.EventDistrict = model.EventDistrict;
newobj.EventLocation = model.EventLocation;
newobj.EventName = model.EventName;
newobj.EventState = model.EventState;
newobj.MobileNo = model.MobileNo;
newobj.OrganizedBy = model.OrganizedBy;
newobj.EventImage = model.EventImage;
objData.SaveChanges();
}
}
public int Save(EventManagementModel c)
{
EventManagement vendortype = new EventManagement()
{
IsDelete = false,
ContactPerson = c.ContactPerson,
EventDate = c.EventDate,
EventId = c.EventId,
EventDistrict = c.EventDistrict,
EventLocation = c.EventLocation,
EventName = c.EventName,
EventState = c.EventState,
MobileNo = c.MobileNo,
OrganizedBy = c.OrganizedBy,
EventImage = c.EventImage,
};
objData.EventManagements.Add(vendortype);
return(objData.SaveChanges());
}
// Put
public Task Update(EventManagementModel value)
{
using (var dbConnection = GetConnection())
{
dbConnection.Open();
return(Task.FromResult(
dbConnection.Query(
@"UPDATE event_management
SET title = @Title, description = @Description, event_location = @EventLocation, event_start_date = @EventStartDate, event_end_date = @EventEndDate, registration_open_date = @RegistrationOpenDate, registration_close_date = @RegistrationCloseDate
WHERE id = @Id",
new {
Id = value.Id,
Title = value.Title.Value,
Description = value.Description.Value,
EventLocation = value.EventLocation.Value,
EventStartDate = value.EventStartDate.Value,
EventEndDate = value.EventEndDate.Value,
RegistrationOpenDate = value.RegistrationOpenDate.Value,
RegistrationCloseDate = value.RegistrationCloseDate.Value
}
)));
}
}
public Task Post(EventManagementModel value)
{
return(_repo.Add(value));
}
