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