public bool Update(
MeetingAgenda agendaItem,
string schema,
string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
dbConnection.Open();
string updateQuery = $@"UPDATE [{schema}].[MeetingAgenda]
SET ReferanceId = @ReferenceId,
AgendaHeading = @AgendaHeading,
AgendaText = @AgendaText,
MeetingAttendeeId = @MeetingAttendeeId,
Duration = @Duration,
CreatedDate = @CreatedDate,
IsComplete = @IsComplete
WHERE Id = @Id";
var instance = dbConnection.Execute(updateQuery, new
{
agendaItem.ReferenceId,
agendaItem.AgendaHeading,
agendaItem.AgendaText,
agendaItem.MeetingAttendeeId,
agendaItem.Duration,
agendaItem.CreatedDate,
agendaItem.IsComplete,
agendaItem.Id
});
return(instance == 1);
}
}
/// <summary>
/// Method to add Meeting Agenda - RS
/// </summary>
/// <param name="addMeetingAgenda">Slab</param>
/// <param name="instituteId">institute id</param>
/// <returns>message</returns>
public async Task <SharedLookUpResponse> AddMeetingAgendaAsync(AddMeetingAgendaAc addMeetingAgenda, int instituteId)
{
if (!await _iMSDbContext.MeetingAgendas.AnyAsync(x => x.InstituteId == instituteId && x.Code.ToLowerInvariant() == addMeetingAgenda.Code.ToLowerInvariant()))
{
MeetingAgenda meetingAgenda = new MeetingAgenda()
{
CreatedOn = DateTime.UtcNow,
InstituteId = instituteId,
Name = addMeetingAgenda.Name,
Code = addMeetingAgenda.Code,
Description = addMeetingAgenda.Description,
Status = true
};
_iMSDbContext.MeetingAgendas.Add(meetingAgenda);
await _iMSDbContext.SaveChangesAsync();
return(new SharedLookUpResponse()
{
HasError = false, Message = "Meeting Agenda added successfully"
});
}
else
{
return new SharedLookUpResponse()
{
HasError = true, ErrorType = SharedLookUpResponseType.Code, Message = "Meeting Agenda with the same name is already exist"
}
};
}
/// <summary>
/// Method to update MeetingAgenda - RS
/// </summary>
/// <param name="updateMeetingAgenda">Slab detail</param>
/// <param name="instituteId">institute id</param>
/// <returns>message</returns>
public async Task <SharedLookUpResponse> UpdateMeetingAgendaAsync(UpdateMeetingAgendaAc updateMeetingAgenda, int instituteId)
{
List <MeetingAgenda> meetingAgendas = await _iMSDbContext.MeetingAgendas.Where(x => x.InstituteId == instituteId && x.Id != updateMeetingAgenda.MeetingAgendaId).ToListAsync();
bool isDuplicate = meetingAgendas.Any(x => x.Code.ToLowerInvariant() == updateMeetingAgenda.Code.ToLowerInvariant());
if (isDuplicate)
{
return new SharedLookUpResponse()
{
HasError = true, ErrorType = SharedLookUpResponseType.Code, Message = "Duplicate code of Meeting Agenda. Please use unique code"
}
}
;
else
{
MeetingAgenda meetingAgenda = await _iMSDbContext.MeetingAgendas.FirstAsync(x => x.Id == updateMeetingAgenda.MeetingAgendaId);
meetingAgenda.Name = updateMeetingAgenda.Name;
meetingAgenda.Code = updateMeetingAgenda.Code;
meetingAgenda.Description = updateMeetingAgenda.Description;
meetingAgenda.Status = updateMeetingAgenda.Status;
_iMSDbContext.MeetingAgendas.Update(meetingAgenda);
await _iMSDbContext.SaveChangesAsync();
return(new SharedLookUpResponse()
{
HasError = false, Message = "Meeting Agenda updated successfully"
});
}
}
public IActionResult UpdateDurationResult([FromBody] MeetingAgenda request)
{
if (!ModelState.IsValid)
{
return(StatusCode(401, "Request is missing values for the request"));
}
var result = _minutzAgendaService.UpdateDuration
(request.Id, Convert.ToInt32(request.Duration), User.ToRest());
return(result.Condition ? (IActionResult)Ok() : StatusCode(result.Code, result.Message));
}
public IActionResult QuickCreateAgendaResult([FromBody] MeetingAgenda request)
{
if (!ModelState.IsValid)
{
return(StatusCode(401, "Request is missing values for the request"));
}
var result = _minutzAgendaService.QuickCreate
(request.ReferenceId, request.AgendaHeading, request.Order, User.ToRest());
return(result.Condition ? Ok(result.Agenda) : StatusCode(result.Code, result.Message));
}
public async Task <IActionResult> GetMeetingAgendaByIdAsync(int meetingId)
{
int loggedInUserInstituteId = await GetUserCurrentSelectedInstituteIdAsync();
MeetingAgenda meeting = await _iMSDbContext.MeetingAgendas.FirstOrDefaultAsync(x => x.Id == meetingId && x.InstituteId == loggedInUserInstituteId);
if (meeting != null)
{
return(Ok(meeting));
}
else
{
return(Ok(new { Message = "Meeting Agenda not found" }));
}
}
public MeetingAgenda Put([FromBody] MeetingAgenda agenda)
{
_logger.LogInformation(Core.LogProvider.LoggingEvents.InsertItem, "MeetingAgenda - PUT - entry point {ID}", 1);
var payload = JsonConvert.SerializeObject(agenda);
_logger.LogInformation(Core.LogProvider.LoggingEvents.InsertItem, " sent data {payload}", payload);
var userInfo = Request.ExtractAuth(User, _authenticationService);
if (agenda.Id == Guid.Parse(_defaultAgendaId))
{
agenda.Id = Guid.NewGuid();
}
var result = _meetingService.CreateMeetingAgendaItem(agenda, userInfo.InfoResponse);
return(result);
}
protected void btnFreeze_Click(object sender, EventArgs e)
{
using (CultureDataContext db = new CultureDataContext())
{
MeetingAgenda c = db.MeetingAgendas.Where(x => x.Agenda_ID == int.Parse(ViewState["ID"].ToString())).FirstOrDefault();
try
{
c.Agenda_StatusID = (int)StatusEnum.Freezed;
db.SubmitChanges();
FillControls();
BindData();
}
catch (Exception exception)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Startup", "<script language='javascript'> alert('حدث خطأ اثناء الحذف'); </script>", false);
}
}
}
public ContentBubbleBot(IConfiguration configuration)
{
_config = configuration;
_agenda = new MeetingAgenda
{
AgendaItems = new List <AgendaItem>()
{
new AgendaItem {
Topic = "Approve 5% dividend payment to shareholders", Id = 1
},
new AgendaItem {
Topic = "Increase research budget by 10%", Id = 2
},
new AgendaItem {
Topic = "Continue with WFH for next 3 months", Id = 3
}
},
};
}
public bool Add(MeetingAgenda agendaItem, string schema, string connectionString)
{
if (string.IsNullOrEmpty(agendaItem.Id.ToString()))
{
agendaItem.Id = Guid.NewGuid();
}
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
dbConnection.Open();
string insertSql = $@"insert into [{schema}].[MeetingAgenda](
[Id]
,[ReferanceId]
,[AgendaHeading]
,[AgendaText]
,[MeetingAttendeeId]
,[Duration]
,[CreatedDate]
,[IsComplete]
)
values(
@Id
,@ReferenceId
,@AgendaHeading
,@AgendaText
,@MeetingAttendeeId
,@Duration
,@CreatedDate
,@IsComplete
)";
var instance = dbConnection.Execute(insertSql, new
{
agendaItem.Id,
agendaItem.ReferenceId,
agendaItem.AgendaHeading,
agendaItem.AgendaText,
agendaItem.MeetingAttendeeId,
agendaItem.Duration,
agendaItem.CreatedDate,
agendaItem.IsComplete
});
return(instance == 1);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (CultureDataContext db = new CultureDataContext())
{
try
{
if (ViewState["ID"] == null)
{
MeetingAgenda q = new MeetingAgenda()
{
Agenda_Item = txtName.Text,
Agenda_StatusID = (int)StatusEnum.UnderApprove,
Agenda_MeetingID = int.Parse(Request.QueryString["id"]),
Agenda_DiscussionPriorityID = int.Parse(ddlDiscussionPriority.SelectedValue),
Agenda_Notes = txtNotes.Text
};
db.MeetingAgendas.InsertOnSubmit(q);
}
else
{
MeetingAgenda q = db.MeetingAgendas.FirstOrDefault(x => x.Agenda_ID.Equals(int.Parse(ViewState["ID"].ToString())));
q.Agenda_Item = txtName.Text;
q.Agenda_Notes = txtNotes.Text;
q.Agenda_DiscussionPriorityID = int.Parse(ddlDiscussionPriority.SelectedValue);
}
db.SubmitChanges();
ClearControls();
BindData();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Startup", "<script language='javascript'> alert('تم الحفظ بنجاح');$('#AgendaModal').modal('hide');$('.modal-backdrop').remove();</script>", false);
}
catch (Exception exception)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Startup", "<script language='javascript'> alert('حدث خطا اثناء الحفظ');</script>", false);
//Logger.ErrorLog(exception);
}
}
}
}
public MeetingAgenda Post([FromBody] MeetingAgenda agenda)
{
var userInfo = Request.ExtractAuth(User, _authenticationService);
return(new MeetingAgenda());
}
public void AddTopictoAgenda(string topic)
{
MeetingAgenda.AddTopic(new Topic(topic));
}
