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)); }