public List <AnnouncementModel> retrieveAnnouncementData() { var AnnouncementModelList = new List <AnnouncementModel>(); string connectionString = @"Data Source = localhost; Initial Catalog = LoginDatabase; Integrated Security = True;"; using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); SqlCommand StrQuer = new SqlCommand("SELECT * FROM [Announcement]", sqlCon); SqlDataReader dr = StrQuer.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { AnnouncementModel temp = new AnnouncementModel() { AnnouncementID = dr.GetGuid(0), AnnouncementCreatedOn = dr.GetString(1), AnnouncementSendOn = dr.GetString(2), AnnouncementStopOn = dr.GetString(3), AnnouncementStatus = dr.GetString(4), AnnouncementType = (AnnouncementType)Convert.ToInt16(dr.GetString(5)), AnnouncementMessage = dr.GetString(6), AnnouncementBy = dr.GetString(8) }; //temp.AnnouncementBy = temp.AnnouncementBy.Replace("\0", ""); AnnouncementModelList.Add(temp); } } dr.Close(); } return(AnnouncementModelList); }
public HttpResponseMessage GetAnnouncement(int siteId, int announcementId) { ContentClientProcessor.UserContext.SiteId = siteId; AnnouncementModel announcement = ContentClientProcessor.GetAnnouncement(announcementId); return(Request.CreateResponse(HttpStatusCode.OK, announcement)); }
protected override async Task OnInitializedAsync() { if (Id != 0) { model = await announcements.GetAnnouncementByIdAsync(Id); } }
public async Task <ActionResult> UpdateAnnouncement([FromBody] AnnouncementModel announcementModel) { if (!ModelState.IsValid) { return(BadRequest(new ApiResponse { Status = false, ModelState = ModelState })); } try { var announcement = _mapper.Map <Announcement>(announcementModel); var status = await _announcementsRepository.Edit(announcement); if (!status) { return(BadRequest(new ApiResponse { Status = false })); } return(Ok(new ApiResponseObject <AnnouncementModel> { Status = true, Object = announcementModel })); } catch (Exception exp) { _logger.LogError(exp.Message); return(BadRequest(new ApiResponse { Status = false })); } }
public IActionResult AddAnnouncement(int announcementId, string operationType) { var model = new AnnouncementModel(announcementId, operationType, _announcementService); _session.SetString("OperationType", operationType); return(PartialView("_AddAnnouncement", model)); }
public static AnnouncementModel ToModel(this Announcement entity) { var model = new AnnouncementModel() { Id = entity.Id, Type = (AnnouncementType)entity.Type, Title = entity.Title, Content = entity.Content, ApplyUserId = entity.ApplyUserId, EffectiveDays = entity.EffectiveDays, CreateUserId = entity.CreateUserId, CreatedTime = entity.CreatedTime, Status = (AnnouncementStatus)entity.Status, AuditReason = entity.AuditReason, RefAssetInventoryId = entity.RefAssetInventoryId }; using (var dbContext = new MissionskyOAEntities()) { //Get english name var userEntityForApplyUser = dbContext.Users.FirstOrDefault(it => it.Id == entity.ApplyUserId); if (userEntityForApplyUser != null) { model.ApplyUserName = userEntityForApplyUser.EnglishName; } var userEntity = dbContext.Users.FirstOrDefault(it => it.Id == entity.CreateUserId); if (userEntity != null) { model.CreateUserName = userEntity.EnglishName; } } return(model); }
// GET: Announcement/Edit/5 public ActionResult Edit(Guid id) { AnnouncementModel announcementToEdit = new AnnouncementModel(); announcementToEdit = announcementRepository.GetAnnouncementByID(id); return(View("Edit", announcementToEdit)); }
public void GetAnnouncementById_AnnouncementExists() { Guid ID = Guid.NewGuid(); Announcement expectedAnnouncement = new Announcement { IDAnnouncement = ID, ValidFrom = new DateTime(2018, 10, 1), ValidTo = new DateTime(2018, 11, 15), EventDateTime = new DateTime(2018, 11, 1), Tags = "tags1", Text = "Eventcall1", Title = "Event1" }; Announcement announcement2 = new Announcement { IDAnnouncement = Guid.NewGuid(), ValidFrom = new DateTime(2017, 1, 1), ValidTo = new DateTime(2017, 3, 1), EventDateTime = null, Tags = "tags", Text = "Announcement", Title = "Important" }; clubmembershipDataContext.Announcements.InsertOnSubmit(expectedAnnouncement); clubmembershipDataContext.Announcements.InsertOnSubmit(announcement2); clubmembershipDataContext.SubmitChanges(); AnnouncementModel result = announcementResource.GetAnnouncementByID(ID); Assert.AreEqual(result, expectedAnnouncement); }
public ActionResult Create(AnnouncementModel model) { if (ModelState.IsValid) { if (model.OrganizationList == null || model.OrganizationList.Count <= 0) { ModelState.AddModelError("Department", "所属组织不能为空"); ViewBag.Organization = DataDictionaryHelper.GetOrganizationList(); return(View(PluginHelper.GetViewPath(this.GetType(), "Create"), model)); } string department = string.Empty; if (model.OrganizationList != null && model.OrganizationList.Count > 0) { for (int i = 0; i < model.OrganizationList.Count; i++) { if (i > 0) { department += ","; } department += model.OrganizationList[i].ToString(); } } model.Department = department; service.InsertGoogleProductRecord(model.ToInfo()); return(Json(new AjaxResult() { Result = Result.Success, Message = "操作成功" })); } ViewBag.Organization = DataDictionaryHelper.GetOrganizationList(); return(View(PluginHelper.GetViewPath(this.GetType(), "Create"), model)); }
/// <summary> /// 查看 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Details(Guid id) { var info = service.GetById(id); var model = new AnnouncementModel().ToModel(info); return(View(PluginHelper.GetViewPath(this.GetType(), "Details"), model)); }
public void InsertAnnouncement(AnnouncementModel announcementModel) { announcementModel.IDAnnouncement = Guid.NewGuid(); clubmembershipDataContext.Announcements.InsertOnSubmit(MapModelToDbObject(announcementModel)); clubmembershipDataContext.SubmitChanges(); }
public async Task <AnnouncementModel> UpdateAnnouncementAsync(AnnouncementModel announcement) { _context.Entry(announcement).State = EntityState.Modified; await _context.SaveChangesAsync(); return(announcement); }
public AnnouncementModel GetAnnouncementByID(Guid id) { AnnouncementModel announcementModel = new AnnouncementModel(); Announcement announcement = clubmembershipDataContext.Announcements.FirstOrDefault(x => x.IDAnnouncement == id); return(MapDbObjectToModel(announcement)); }
public ActionResult DeleteConfirmed(int id) { AnnouncementModel announcementModel = db.AnnouncementModels.Find(id); db.AnnouncementModels.Remove(announcementModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public HttpResponseMessage Post([FromBody] AnnouncementModel model) { var createAnnouncementAction = new CreateAnnouncement(model.ToEntity()); var result = PerformAction <CreateAnnouncement, Announcement>(createAnnouncementAction); return(Request.CreateResponse(result.ValidationResult.GetStatusCode(HttpStatusCode.Created), new ActionReponse <AnnouncementConfirmationModel>(new AnnouncementConfirmationModel(createAnnouncementAction.NumberOfUsersEmailed), result.ValidationResult))); }
public ActionResult Index() { AnnouncementModel model = new AnnouncementModel(); AnnouncementEntity ob = AnnouncementServices.GetAnnouncement(); model.AnnouncementText = ob.AnnouncementText; return(View(model)); }
public ActionResult ComposeAnnouncement(AnnouncementModel model) { AnnouncementRepository repository = new AnnouncementRepository(); repository.AddAnnouncement(User.Identity.Name, model.title, model.body); return(RedirectToAction("SendAnnouncement")); }
/// <summary> /// 修改 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Edit(Guid id) { var info = service.GetById(id); ViewBag.Organization = DataDictionaryHelper.GetOrganizationList(); var model = new AnnouncementModel().ToModel(info); return(View(PluginHelper.GetViewPath(this.GetType(), "Edit"), model)); }
public IHttpActionResult PostAnnouncement(AnnouncementModel model) { var announcement = Mapper.Map <Announcement>(model); announcementRepository.Save(announcement); var location = Url.Link("DefaultApi", new { controller = "Announcements", id = announcement.Id }); return(Created(location, announcement)); }
public async Task <IActionResult> AnnouncementCreation(AnnouncementModel announcement) // TODO: put in parameter list { var user = await userManager.GetUserAsync(User); AnnouncementRepository ancRepo = new AnnouncementRepository(configModel.ConnectionString); VolunteerRepository volunteerRepo = new VolunteerRepository(configModel.ConnectionString); VolunteerModel volunteer; // Ensure that ONLY staff accounts have access to this API endpoint if (user == null || !await userManager.IsInRoleAsync(user, UserHelpers.UserRoles.Staff.ToString())) { return(Utilities.ErrorJson("Not authorized")); } // Get the current user's volunteer profile so we can get their name volunteer = volunteerRepo.GetVolunteer(user.VolunteerId); // Validate the inputs // Note that in C#, DateTimes are never null, so instead of checking for null, we check for DateTime.MinValue, which is the // default value that ASP.NET's model binding will provide if the date is not included in the API call. if (String.IsNullOrEmpty(announcement.Title)) { return(Utilities.ErrorJson("Title field cannot be empty")); } if (announcement.StartDate == DateTime.MinValue || announcement.EndDate == DateTime.MinValue) { return(Utilities.ErrorJson("Start and end date must be provided")); } if (announcement.StartDate > announcement.EndDate) { return(Utilities.ErrorJson("Start date must be no later than end date")); } try { ancRepo.CreateAnnouncement(new AnnouncementModel { Title = announcement.Title, Message = announcement.Message, Author = volunteer.FirstName + " " + volunteer.LastName, LastUpdateBy = volunteer.FirstName + " " + volunteer.LastName, StartDate = announcement.StartDate, EndDate = announcement.EndDate }); } catch (Exception e) { return(Utilities.ErrorJson(e.Message)); } return(new JsonResult(new { Error = "" })); }
public void UpdateAnnouncement(AnnouncementModel announcementModel) { Models.DBObjects.Announcement existingannouncement = dbContext.Announcements.FirstOrDefault(x => x.IDAnnouncement == announcementModel.IDAnnouncement); if (existingannouncement != null) { existingannouncement.UpdateObject(announcementModel); dbContext.SubmitChanges(); } }
/// <summary> /// 新增 /// </summary> /// <returns></returns> public ActionResult Create() { var model = new AnnouncementModel(); ViewBag.Organization = DataDictionaryHelper.GetOrganizationList(); var name = Session["User"] as User; model.Name = name.UserName; return(View(PluginHelper.GetViewPath(this.GetType(), "Create"), model)); }
public ActionResult Edit([Bind(Include = "Id,Title,Description,CreatedDate,ValidFrom,ValidTo")] AnnouncementModel announcementModel) { if (ModelState.IsValid) { db.Entry(announcementModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(announcementModel)); }
public ActionResult Create(AnnouncementModel model) { if (ModelState.IsValid) { AnnouncementEntity ob = new AnnouncementEntity(); ob.AnnouncementText = model.AnnouncementText; AnnouncementServices.UpdateAnnouncement(ob); TempData[HRMWeb.Helpers.AlertStyles.Success] = "Announcement Successfully Updated"; } return(RedirectToAction("Index", "Announcement")); }
public async Task <IActionResult> AnnouncementEdit(AnnouncementModel announcement) { var user = await userManager.GetUserAsync(User); AnnouncementRepository repo = new AnnouncementRepository(configModel.ConnectionString); AnnouncementModel dbAnc; VolunteerRepository volunteerRepo = new VolunteerRepository(configModel.ConnectionString); VolunteerModel volunteer; // Ensure that ONLY staff accounts have access to this API endpoint if (user == null || !await userManager.IsInRoleAsync(user, UserHelpers.UserRoles.Staff.ToString())) { return(Utilities.ErrorJson("Not authorized")); } if (String.IsNullOrEmpty(announcement.Title)) { return(Utilities.ErrorJson("Title field cannot be empty")); } if (announcement.StartDate == DateTime.MinValue || announcement.EndDate == DateTime.MinValue) { return(Utilities.ErrorJson("Start and end date must be provided")); } if (announcement.StartDate > announcement.EndDate) { return(Utilities.ErrorJson("Start date must be no later than end date")); } dbAnc = repo.GetAnnouncement(announcement.Id); if (dbAnc == null) { return(Utilities.ErrorJson("Not a valid announcement")); } volunteer = volunteerRepo.GetVolunteer(user.VolunteerId); announcement.LastUpdateBy = volunteer.FirstName + " " + volunteer.LastName; try { repo.UpdateAnnouncement(announcement); } catch (Exception e) { return(Utilities.ErrorJson(e.Message)); } return(new JsonResult(new { Error = "", Announcement = repo.GetAnnouncement(announcement.Id) })); }
public ActionResult Create([Bind(Include = "Id,Title,Description,CreatedDate,ValidFrom,ValidTo")] AnnouncementModel announcementModel) { if (ModelState.IsValid) { db.AnnouncementModels.Add(announcementModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(announcementModel)); }
public IHttpActionResult Put(AnnouncementModel model) { try { return(Ok(accountService.Update(model))); } catch (Exception e) { throw new Exception(e.Message); } }
public void GivenAValidAnnouncementIsReadyToBeSubmitted() { var announcement = new AnnouncementModel { Message = "Hello", Subject = "Test", NotifyAll = true }; ScenarioCache.Store(ModelKeys.Announcement, announcement); }
//public JsonResult GetAnnouncementById(int ID) //{ // Announcement ann = AnRepo.Get(a => a.Id == ID && a.IsDeleted==false); // return Json(ann,JsonRequestBehavior.AllowGet); //} public ActionResult Announcement() { var usermanager = IdentityTools.NewUserManager(); var uid = usermanager.FindByName(User.Identity.Name); AnnouncementModel anm = new AnnouncementModel(); anm.AnList = AnRepo.GetAll(a => a.IsDeleted == false && a.Teacher.UserId == uid.Id).ToList(); anm.AnTList = AntRepo.GetAll(a => a.IsDeleted == false).ToList(); anm.TeacherId = TrRepo.Get(t => t.IsDeleted == false && t.UserId == uid.Id).Id; return(View(anm)); }
public bool InsertAnnouncement(AnnouncementModel announcement) { object[] keys = { "name", "description", "postDate", "expirationDate", "user" }; object[] values = { announcement.Title, announcement.Description, announcement.PostDate, announcement.ExpirationDateTimeStamp, announcement.Username }; var data = NSDictionary.FromObjectsAndKeys(values, keys, keys.Length); announcementNode.KeepSynced(true); announcementNode.GetChildByAutoId().SetValue <NSDictionary>(data, (error, reference) => { Console.WriteLine(error); }); return(true); }