public IActionResult DeleteEvent([FromBody] GetCalendarEvents evt)
{
string message = String.Empty;
//message = _DA.DeleteEvent(evt.EventId);
return(Json(new { message }));
}
private async Task <GetCalendarEvents.Response> FindAllCalendarEvents(GetCalendarEvents request)
{
this.logger.Debug("Started loading of all calendar events");
var responses = await this.GetActorResponses <GetCalendarEvents.Response>(request);
this.logger.Debug("All calendar events loaded");
return(new GetCalendarEvents.Response(this.employeeId, responses.SelectMany(x => x.Events).ToList()));
}
public IActionResult AddEvent([FromBody] GetCalendarEvents evt)
{
string message = String.Empty;
int eventId = 0;
//message = _DA.AddEvent(evt, out eventId);
return(Json(new { message, eventId }));
}
public string AddEvent(GetCalendarEvents evt, out int eventId)
{
string message = "";
SqlConnection conn = GetConnection();
SqlTransaction trans = conn.BeginTransaction();
eventId = 0;
try
{
SqlCommand cmd = new SqlCommand(@"insert into [Events]
(
title
,[description]
,event_start
,event_end
,all_day
)
values
(
@title
,@description
,@start
,@end
,@allDay
);
select scope_identity()", conn, trans)
{
CommandType = CommandType.Text
};
cmd.Parameters.Add("@title", SqlDbType.VarChar).Value = evt.Title;
cmd.Parameters.Add("@description", SqlDbType.VarChar).Value = evt.Description;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = evt.Start;
cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = Helpers.ToDBNullOrDefault(evt.End);
cmd.Parameters.Add("@allDay", SqlDbType.Bit).Value = evt.AllDay;
eventId = Convert.ToInt32(cmd.ExecuteScalar());
trans.Commit();
}
catch (Exception exp)
{
trans.Rollback();
message = exp.Message;
}
finally
{
CloseConnection(conn);
}
return(message);
}
public string UpdateEvent(GetCalendarEvents evt)
{
string message = "";
SqlConnection conn = GetConnection();
SqlTransaction trans = conn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand(@"update
[Events]
set
[description]=@description
,title=@title
,event_start=@start
,event_end=@end
,all_day=@allDay
where
event_id=@eventId" , conn, trans)
{
CommandType = CommandType.Text
};
cmd.Parameters.Add("@eventId", SqlDbType.Int).Value = evt.EventId;
cmd.Parameters.Add("@title", SqlDbType.VarChar).Value = evt.Title;
cmd.Parameters.Add("@description", SqlDbType.VarChar).Value = evt.Description;
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = evt.Start;
cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = Helpers.ToDBNullOrDefault(evt.End);
cmd.Parameters.Add("@allDay", SqlDbType.Bit).Value = evt.AllDay;
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception exp)
{
trans.Rollback();
message = exp.Message;
}
finally
{
CloseConnection(conn);
}
return(message);
}
private async Task <GetCalendarEvents.Response> FindAllCalendarEvents(GetCalendarEvents request)
{
var responses = await this.GetActorResponses <GetCalendarEvents.Response>(request);
return(new GetCalendarEvents.Response(this.employeeId, responses.SelectMany(x => x.Events).ToList()));
}
