/// <summary>
/// Raises the AnnounceMade event
/// </summary>
protected void RaiseAnnounceMade( Announcement announce )
{
if( AnnounceMade != null )
{
AnnounceMade( this, announce );
}
}
public ActionResult Create(Announcement announcement)
{
//try
//{
if (ModelState.IsValid)
{
try
{
AnnouncementService.Add(announcement);
return RedirectToAction("Index");
}
catch (ValidationErrorsException ex)
{
foreach (var error in ex.Errors)
{
ModelState.AddModelError(error.PropertyName, error.ErrorMassage);
}
}
}
ViewBag.Agencies = new SelectList(AgencyService.GetAll(), "Id", "Name");
return View(announcement);
//}
//catch
//{
// return View(announcement);
//}
}
public void ToDocument_AnnouncementWithAnId_IdIsRepresentedAsObjectId()
{
var announcement = new Announcement();
announcement.Id = ObjectId.GenerateNewId().ToString();
var document = announcement.ToBsonDocument();
Expect(document["_id"].BsonType, Is.EqualTo(BsonType.ObjectId));
}
public static AnnouncementResponseModel From(Announcement announcement)
{
return new AnnouncementResponseModel()
{
Message = announcement.Message,
Severity = announcement.Severity.ToString(),
StartDate = announcement.StartDate,
EndDate = announcement.EndDate
};
}
public ActionResult Edit(int? id)
{
Announcement announcement = db.Announcements.SingleOrDefault(a => a.AnnouncementID == id);
if (announcement == null)
announcement = new Announcement() {
AnnouncementID = 0,
StartDate = DateTime.Now,
EndDate = DateTime.Now.AddDays(14)
};
return View(announcement);
}
public void New_Announcement_Should_Be_Deserialized_Correctly()
{
var newAnnouncement = new NewAnnouncement
{
Title = "Test Announcement 1",
Description = new[] {"Test Test"},
ValidTill = DateTime.UtcNow.AddDays(7)
};
var announcement = new Announcement(newAnnouncement);
Console.WriteLine(announcement.ToBsonDocument());
}
// Use this for initialization
void Start () {
slide = GetComponentInChildren<Slider>();
AlarmSlider = slide.transform.parent.gameObject;
alarmCol = GetComponentInChildren<BoxCollider2D> ();
// playerLoc = GameObject.Find ("Player").GetComponentInChildren<Transform> ().position;
// alarmLoc = transform.position;
announce = GameObject.Find ("Announce text").GetComponentInChildren<Announcement> ();
doOnce = 0;
slide.value = 0;
inRange = false;
pastState = false;
AlarmSlider.SetActive(false);
}
public static AnnouncementModel From(Announcement announcement)
{
return new AnnouncementModel()
{
AnnouncementId = announcement.Id,
SignboardIds = announcement.SignboardIds.ToList(),
Message = announcement.Message,
Name = announcement.Name,
StartDate = announcement.StartDate,
EndDate = announcement.EndDate,
Severity = announcement.Severity.ToString(),
IsActive = announcement.IsActive
};
}
public ActionResult Create(Announcement announcement)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
_svc.CreateAnnoucement(announcement);
return RedirectToAction("Index");
}
catch
{
var opportunities = _svc.GetAvailableOpportunities();
var vm = new AnnouncementBindingModel(announcement, opportunities);
return View(vm);
}
}
public void Announce (Announcement announcement)
{
if (!IsRecentAnnouncement (announcement)) {
if (IsConnected) {
Logger.LogInfo ("Listener", "Announcing message " + announcement.Message +
" to " + announcement.FolderIdentifier + " on " + Server);
AnnounceInternal (announcement);
AddRecentAnnouncement (announcement);
} else {
Logger.LogInfo ("Listener", "Can't send message to " + Server + ". Queuing message");
this.queue_up [announcement.FolderIdentifier] = announcement;
}
} else {
Logger.LogInfo ("Listener", "Already processed message " + announcement.Message +
" to " + announcement.FolderIdentifier + " from " + Server);
}
}
public void ToDocument_AnnouncementWithPublishDate_PublishDateShouldAlwaysBeLocal()
{
// Arrange
var announcement = new Announcement();
// Act
// Being saved as UTC time
announcement.PublishedOn = DateTime.UtcNow;
var document = announcement.ToBsonDocument();
var converted = BsonSerializer.Deserialize<Announcement>(document);
// Assert
// Verify that it is deserialized as local date / time
Console.WriteLine("Kind: " + converted.PublishedOn.Kind);
Console.WriteLine("Converted: " + converted.PublishedOn);
Console.WriteLine("Original: " + announcement.PublishedOn);
Expect(converted.PublishedOn.Kind, Is.EqualTo(DateTimeKind.Local));
Expect(converted.PublishedOn.ToString(), Is.EqualTo(announcement.PublishedOn.ToLocalTime().ToString()));
}
public bool Add_Announcement(Announcement Model)
{
try
{
Model.DateCreated = DateTime.Now;
Model.IsEnable = true;
Model.IsActive = true;
Model.Id = Guid.NewGuid();
using (var db = new MyLearnDBEntitiess())
{
db.Announcements.Add(Model);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public int UpdateAnnouncement(Announcement announcement)
{
announcement.lecturer_id = 1;
List <FileResource> files = new List <FileResource>();
files = GetFileResource(announcement.announcement_id);
announcement.filesDisplay = files;
using (var connection = GetConnection())
{
var p = new DynamicParameters();
p.Add("@inMessage", announcement.message, dbType: DbType.String);
if (!String.IsNullOrEmpty(announcement.title))
{
p.Add("@inTitle", announcement.title, dbType: DbType.String);
}
p.Add("@inLecturerId", announcement.lecturer_id, dbType: DbType.Int32);
p.Add("@inAnnouncementId", announcement.announcement_id, dbType: DbType.Int32);
int rowCount = connection.Execute("usp_updateAnnouncement", p, commandType: CommandType.StoredProcedure);
return(rowCount);
}
}
public ActionResult Edit(Announcement model)
{
if (model.AnnouncementID > 0) {
// EDIT MODE
try {
model = db.Announcements.Find(model.AnnouncementID);
UpdateModel(model);
model.StartDate = new DateTime(model.StartDate.Year, model.StartDate.Month, model.StartDate.Day, 0, 0, 0);
if (model.EndDate.HasValue)
model.EndDate = new DateTime(model.EndDate.Value.Year, model.EndDate.Value.Month, model.EndDate.Value.Day, 23, 59, 59);
db.SaveChanges();
return RedirectToAction("Index");
} catch (Exception) {
ModelState.AddModelError("", "Edit Failure, see inner exception");
}
return View(model);
} else {
// silly stuff
model.Title = "";
model.StartDate = new DateTime(model.StartDate.Year, model.StartDate.Month, model.StartDate.Day, 0, 0, 0);
if (model.EndDate.HasValue)
model.EndDate = new DateTime(model.EndDate.Value.Year, model.EndDate.Value.Month, model.EndDate.Value.Day, 23, 59, 59);
// ADD MODE
if (ModelState.IsValid) {
db.Announcements.Add(model);
db.SaveChanges();
return RedirectToAction("Index");
} else {
return View(model);
}
}
}
public int AddAnnouncement(Announcement announcement)
{
DateTime currentTime = DateTime.Now;
announcement.lecturer_id = 1;
using (var connection = GetConnection())
{
var p = new DynamicParameters();
p.Add("@announcementDate", value: currentTime, dbType: DbType.DateTime);
p.Add("@message", value: announcement.message, dbType: DbType.String, size: 1000);
p.Add("@title", value: announcement.title, dbType: DbType.String, size: 100);
p.Add("@lastEditDate", value: currentTime, dbType: DbType.DateTime);
p.Add("@lecturerId", value: announcement.lecturer_id, dbType: DbType.Int32);
p.Add("@courseId", value: announcement.course_id, dbType: DbType.Int32);
p.Add("@outAnnouncementId", dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("usp_addAnnouncement", p, commandType: CommandType.StoredProcedure);
int announcementId = p.Get <int>("@outAnnouncementId");
return(announcementId);
}
}
public void New_Announcement_Should_Be_Saved_Correctly()
{
var announcementsContext = new IafonzDataContext("IafonzTestDb");
var newAnnouncement = new NewAnnouncement
{
Title = "Test Announcement 1",
Description = new[] {"<p>Test Test </p>"},
ValidTill = DateTime.UtcNow.AddDays(7)
};
var announcement = new Announcement(newAnnouncement);
announcementsContext.Announcements.Insert(announcement);
var addedAnnouncement =
announcementsContext.Announcements.FindOneById(new BsonObjectId(new ObjectId(announcement.Id)));
Console.WriteLine(addedAnnouncement.ToJson());
Expect(addedAnnouncement, Is.Not.Null);
}
public async Task <ActionResult <Announcement> > Put(AnnouncementDTO announcementDTO)
{
if (announcementDTO == null)
{
return(BadRequest());
}
Announcement announcement = _mapper.Map <AnnouncementDTO, Announcement>(announcementDTO);
if (!db.Announcements.Any(an => an.Id == announcement.Id))
{
return(NotFound());
}
db.Update(announcement);
await db.SaveChangesAsync();
var query = db.Announcements.Where(an => an.Id == announcement.Id);
var announcementDTO2 = await _mapper.ProjectTo <AnnouncementDTO>(query).FirstOrDefaultAsync();
return(Ok(announcementDTO2));
}
public ActionResult Edit(int id, Announcement announcement)
{
try
{
// TODO: Add update logic here
Announcement editingAnnouncement = db.Announcements.Where(c => c.AnnouncementID.Equals(id)).FirstOrDefault();
editingAnnouncement.Title = announcement.Title;
editingAnnouncement.Description = announcement.Description;
editingAnnouncement.Location = announcement.Location;
editingAnnouncement.PublicationDate = editingAnnouncement.PublicationDate;
editingAnnouncement.CompanyID = editingAnnouncement.CompanyID;
editingAnnouncement.LevelID = announcement.LevelID;
editingAnnouncement.CategoryID = announcement.CategoryID;
db.SaveChanges();
return(RedirectToAction("GetAllAnnouncementDoneBy", new { idUser = User.Identity.GetUserId() }));
}
catch
{
return(View());
}
}
private async void DeleteBtn_Click(object sender, EventArgs e)
{
Announcement delAnnouncement = (Announcement)announcementsListBox.SelectedItem;
if (delAnnouncement != null)
{
var confirmDeletion = MessageBox.Show("Are you sure you want to delete this announcement?", "Confirm Delete", MessageBoxButtons.YesNo);
if (confirmDeletion == DialogResult.Yes)
{
// Delete announcement from db
_context.Announcements.Remove(delAnnouncement);
await _context.SaveChangesAsync();
// Update ListBox
Announcements.Remove(delAnnouncement);
// Update flowLayoutPanel
foreach (CardControl control in announcementsFLPanel.Controls)
{
if ((int)control.Tag == delAnnouncement.Id)
{
announcementsFLPanel.Controls.Remove(control);
// Reset panel with new set of recent announcements
announcementsFLPanel.Controls.Clear();
foreach (var announcement in Announcements.Take(3))
{
CardControl cardControl = new CardControl(announcement);
announcementsFLPanel.Controls.Add(cardControl);
}
}
}
}
}
else
{
MessageBox.Show("No announcement that can be deleted.", "Error occured");
}
}
public HttpResponseMessage Create(HttpRequestMessage request, AnnouncementViewModel announcementVm)
{
if (ModelState.IsValid)
{
var newAnnoun = new Announcement();
try
{
newAnnoun.Content = announcementVm.Content;
newAnnoun.Status = announcementVm.Status;
newAnnoun.Title = announcementVm.Title;
newAnnoun.CreatedDate = DateTime.Now;
newAnnoun.UserId = User.Identity.GetUserId();
foreach (var user in announcementVm.AnnouncementUsers)
{
newAnnoun.AnnouncementUsers.Add(new AnnouncementUser()
{
UserId = user.UserId,
HasRead = false
});
}
_announcementService.Create(newAnnoun);
_announcementService.Save();
var announ = _announcementService.GetDetail(newAnnoun.ID);
//push notification
TMSHub.PushToAllUsers(Mapper.Map <Announcement, AnnouncementViewModel>(announ), null);
return(request.CreateResponse(HttpStatusCode.OK, announcementVm));
}
catch (Exception dex)
{
return(request.CreateErrorResponse(HttpStatusCode.BadRequest, dex.Message));
}
}
else
{
return(request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public IActionResult EditAnnouncementRandom(Announcement ARandom, int id)
{
var random = DB.Announcement
.Where(x => x.Id == id && x.TypeCS.NameType == "R")
.SingleOrDefault();
if (random == null)
{
return(Content("不存在该记录"));
}
else
{
var UserCurrent = DB.Users
.Where(x => x.UserName == HttpContext.User.Identity.Name)
.SingleOrDefault();
var re = ARandom.RegisteNumber;
var b = DB.BaseInfo
.Where(x => x.RegisteNumber == ARandom.RegisteNumber)
.SingleOrDefault();
if (b != null)
{
random.WriteTime = DateTime.Now;
random.Writer = UserCurrent.UserName;
random.Title = ARandom.Title;
random.Content = ARandom.Content;
random.PublicTime = ARandom.PublicTime;
random.PublicUnit = ARandom.PublicUnit;
random.RegisteNumber = ARandom.RegisteNumber;
random.CompanyName = b.CompanyName;
DB.SaveChanges();
return(Content("success"));
}
else
{
return(Content("nobase"));
}
}
}
public ActionResult DeleteAnnouncement(int id)
{
Announcement announcement = _announcementRepository.GetById(id);
User authenticatedUser = _userRepository.GetUserByPhone(User.Identity.Name);
if (authenticatedUser == announcement.User)
{
foreach (Photo photo in announcement.Photos)
{
deletePhoto(photo.Url);
}
_announcementRepository.Delete(announcement);
_announcementRepository.SaveChanges();
TempData["message"] = string.Format(Translation.Translation.CabinetDataDeleteMessage);
return(RedirectToAction("Announcements", new { phone = authenticatedUser.Phone }));
}
else
{
throw new Exception(Translation.Translation.AccessIsDeniedMessage);
}
}
public ActionResult AddPhoto(int announcementId, object qqfile)
{
bool res = false;
string fileName;
Photo photo = new Photo();
Stream stream = getFileStream(qqfile, out fileName);
string message = string.Empty;
User authenticatedUser = _userRepository.GetUserByPhone(User.Identity.Name);
if (authenticatedUser != null)
{
Announcement announcement = _announcementRepository.GetById(announcementId);
if (announcement != null)
{
if (announcement.Photos.Count < authenticatedUser.Profile.MaxPhotosPerAnnouncements)
{
photo.Url = savePhoto(stream, fileName);
photo.Owner = authenticatedUser;
photo.AnnouncementId = announcementId;
_photoRepository.Add(photo);
_photoRepository.SaveChanges();
res = true;
}
if (announcement.Photos.Count < authenticatedUser.Profile.MaxPhotosPerAnnouncements)
{
message = string.Format(Translation.Translation.PhotosLeft, authenticatedUser.Profile.MaxPhotosPerAnnouncements - announcement.Photos.Count);
}
else
{
message = string.Format(Translation.Translation.LimitForPhotosIsReachedLabel, Url.Action("UpdateLimit", "Account"));
}
}
}
return(Json(new { Done = res, PhotoId = photo.PhotoId, PhotoUrl = photo.Url, Message = message }, "text/json"));
}
public IEnumerable <int> getSimularAnnouncements(Announcement announcement)
{
//Select all items from db except selected announcement
Announcements = _db.Announcements.Where(i => i.Id != announcement.Id).ToList();
//ititialize dictionary with key = announcement.Id, keyValue = similar words count
Dictionary <int, int> IdOfSimilarAnnouncements = new Dictionary <int, int>(Announcements.Count());
//words of selected announcement
var ourAnnouncementWords = announcement.Tittle.ToLower().Split(' ')
.Union(announcement.Description.ToLower().Split(' '));
foreach (var item in Announcements)
{
int sameWordsCount = 0;
var otherAnnouncementWord = item.Tittle.ToString().ToLower().Split(' ')
.Union(item.Description.ToLower().Split(' '));
var sameWords = ourAnnouncementWords.Intersect(otherAnnouncementWord);
sameWordsCount = sameWords.Count();
if (sameWordsCount == 0)
{
continue;
}
else
{
IdOfSimilarAnnouncements.Add(item.Id, sameWordsCount);
}
}
//get id of 3 most similar announcement
IEnumerable <int> ListOfThreeSimilarAnnouncements = IdOfSimilarAnnouncements.OrderByDescending(t => t.Value).Take(3).Select(t => t.Key);
return(ListOfThreeSimilarAnnouncements);
}
private int GetDistance(Card card, Card maxCard, Announcement announce)
{
int distance = 0;
if (card.CardColor != maxCard.CardColor)
{
throw new ArgumentException("When comparing distance between two cards, they must have same color");
}
CardColor trumpColor = GetTrumpColor();
switch (announce.Type)
{
case AnnouncementTypeEnum.AllTrumps:
distance = GetDistanceTrumps(card, maxCard);
break;
case AnnouncementTypeEnum.NoTrumps:
distance = GetDistanceNoTrumps(card, maxCard);
break;
case AnnouncementTypeEnum.Spades:
case AnnouncementTypeEnum.Hearts:
case AnnouncementTypeEnum.Diamonds:
case AnnouncementTypeEnum.Clubs:
if (card.CardColor == trumpColor)
{
distance = GetDistanceTrumps(card, maxCard);
}
else
{
distance = GetDistanceNoTrumps(card, maxCard);
}
break;
}
return(distance);
}
private async Task <bool> SendNotificationToAnnoucmentCreator(int annoucmentId, PushNotification pushNotification)
{
Announcement announcement = await _repository.Filter <Announcement>(a => a.Id == annoucmentId)
.Include(a => a.User).ThenInclude(u => u.PersonSettings).FirstOrDefaultAsync();
User user = announcement.User;
var userLanguage = await _repository.FilterAsNoTracking <PersonOtherSetting>(x =>
x.UserId == user.Id).ToListAsync();
if (user.PersonSettings.Select(x => x.SubscriptionsType).Contains(SubscriptionsType.NewMessagesNotifications))
{
_repository.Create(new PersonNotification
{
UserId = user.Id,
PushNotificationId = pushNotification.Id,
Announcement = announcement,
AnnouncementId = annoucmentId,
});
var lang = userLanguage.Select(l => l.Language).FirstOrDefault();
await _firebaseRepository.SendIndividualNotification(new FirebaseIndividualNotificationModel
{
Description = lang == Language.English ? pushNotification.Description :
pushNotification.PushNotificationTranslates.Select(n => n.Description).FirstOrDefault(),
Title = lang == Language.English ? pushNotification.Title :
pushNotification.PushNotificationTranslates.Select(n => n.Title).FirstOrDefault(),
NotificationType = NotificationType.PushNotification,
PushNotificationActionType = pushNotification.PushNotificationActionType,
FromAdmin = true,
SenderId = null,
ReceiverId = user.Id,
GenericId = annoucmentId
}, false);
}
await _repository.SaveChangesAsync();
return(true);
}
private static void BindNewAnnouncement(MySqlCommand command, Announcement announcement)
{
// @Timestamp
command.Parameters.Add(new MySqlParameter
{
ParameterName = "@Timestamp",
DbType = DbType.Time,
Value = announcement.TimeStamp
});
command.Parameters["@Timestamp"].Direction = ParameterDirection.Input;
// @Text
command.Parameters.Add(new MySqlParameter
{
ParameterName = "@Text",
DbType = DbType.String,
Value = announcement.Text
});
command.Parameters["@Text"].Direction = ParameterDirection.Input;
// @Category
command.Parameters.Add(new MySqlParameter
{
ParameterName = "@Category",
DbType = DbType.String,
Value = announcement.Category
});
command.Parameters["@Category"].Direction = ParameterDirection.Input;
// @ UserID
command.Parameters.Add(new MySqlParameter
{
ParameterName = "@UserID",
DbType = DbType.Int32,
Value = announcement.User.Id
});
command.Parameters["@UserID"].Direction = ParameterDirection.Input;
}
public void Send(string userId, string title, string content, string[] receiversUser)
{
try
{
_log.LogInformation("Send Announcement - START");
var announcement = new Announcement()
{
SenderId = userId,
Title = title,
Content = content,
CreatedDate = DateTime.Now,
Status = Data.Enums.StatusEnum.Active
};
_log.LogInformation("Add Announcement");
//Add Announcement
_announcementService.Add(announcement);
_log.LogInformation("Add AnnouncementUser");
//Add AnnounmentUser
foreach (var user in receiversUser)
{
_announcementUserService.Add(new AnnouncementUser()
{
AnouncementId = announcement.Id,
UserId = user,
HasRead = false
});
}
//Save data
_unitOfWork.Commit();
_log.LogInformation("Send Announcement Success");
}
catch (Exception ex)
{
_log.LogError($"Send Announcement Error. {ex.ToString()}");
}
}
public async Task <ActionResult> Read(int?id)
{
try
{
Announcement announcement = null;
if (id == null)
{
announcement = db.Announcements.OrderByDescending(a => a.CreateAt).FirstOrDefault();
}
else
{
announcement = await db.Announcements.FindAsync(id);
}
if (announcement == null)
{
throw new ApplicationException("Announcement does not exists");
}
AnnouncementViewModel avm =
Mapper.Map <Announcement, AnnouncementViewModel>(announcement);
if (announcement.AnnouncementReads == null)
{
announcement.AnnouncementReads = new List <AnnouncementRead>();
}
await SaveAnnouncementReadInformation(announcement);
return(View(avm));
}
catch (Exception ex)
{
ModelState.AddModelError("Error", ex.Message);
return(View(new AnnouncementViewModel()));
}
}
public void updateAnnouncement(Announcement announcement, String title, String text, DateTime expiry, Image img, Image icon)
{
Announcement temp = null;
try
{
temp = getAnnouncementByID(announcement.Announcement_ID);
temp.Title = title;
temp.Text = text;
temp.Expiry = expiry;
}
catch (Exception)
{
}
try
{
if (img != null)
{
temp.Image = convertImageToByte(img);
}
if (icon != null)
{
temp.Icon = convertImageToByte(icon);
}
}
catch (Exception)
{
}
try
{
context.Announcement.ApplyCurrentValues(temp);
context.SaveChanges();
}
catch (Exception err)
{
System.Windows.Forms.MessageBox.Show(err.ToString());
}
}
public void GetAllAnnouncements_TwoRecordsExists()
{
Announcement announcement1 = new Announcement
{
IDAnnouncement = Guid.NewGuid(),
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(announcement1);
clubmembershipDataContext.Announcements.InsertOnSubmit(announcement2);
clubmembershipDataContext.SubmitChanges();
List <AnnouncementModel> result = announcementResource.GetAllAnnouncements();
Assert.AreEqual(2, result.Count);
AnnouncementModel announcementModel1 = result.FirstOrDefault(x => x.IDAnnouncement == announcement1.IDAnnouncement);
Assert.AreEqual(announcementModel1, announcement1);
AnnouncementModel announcementModel2 = result.FirstOrDefault(x => x.IDAnnouncement == announcement2.IDAnnouncement);
Assert.AreEqual(announcementModel2, announcement2);
}
public ActionResult Delete(int?id, bool?error)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Announcement announcement = _repo.GetAnnouncementById((int)id);
if (announcement == null)
{
return(HttpNotFound());
}
else if (announcement.UserId != User.Identity.GetUserId() && !User.IsInRole("Admin"))
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (error != null)
{
ViewBag.Error = true;
}
return(View(announcement));
}
public void Publish(Announcement announcement)
{
announcement.DateTime = DateTime.UtcNow;
string query = "insert into announcements (title, body, username, email, timestamp) " +
"values (" +
$"'{announcement.Title}'," +
$"'{announcement.Body}'," +
$"'{announcement.Username}'," +
$"'{announcement.Email}'," +
$"{Tools.ConvertToUnixTimestamp(announcement.DateTime)}" +
$")";
lock (Program.Locker)
{
using (NpgsqlCommand cmd = new NpgsqlCommand(query, Program.NpgsqlConnection))
{
cmd.ExecuteNonQuery();
}
_announcements.Add(announcement);
}
Console.WriteLine($"Publish {announcement.Title} from {announcement.Username}");
}
// GET: Admin/Announcements/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Announcement announcement = db.Announcements.Find(id);
var userid = User.Identity.GetUserId();
var announcementa = from item in db.Announcements where (item.AnnouncementId == id) select item;
announcementa = announcementa.Include(a => a.CreatedBy);
announcementa = announcementa.Where(a => a.CreatedBy == userid);
if (announcementa.Count() == 0)
{
announcement = null;
}
if (announcement == null)
{
return(HttpNotFound());
}
return(View(announcement));
}
public void VerifyAnnouncementInAnnouncementFrame(Announcement.
AnnouncementTypeEnum announcementTypeEnum)
{
//Verifying Display of Announcement in Announcement frame
Logger.LogMethodEntry("ManageAnnouncement", "VerifyAnnouncementInAnnouncementFrame",
base.IsTakeScreenShotDuringEntryExit);
//Get announcement From Memory
Announcement announcement = Announcement.Get(announcementTypeEnum);
//Declaration Page Class Object
AnnouncementDefaultUXPage announcementDefaultUxPage =
new AnnouncementDefaultUXPage();
//Select Announcement Frame
announcementDefaultUxPage.SelectAnnouncementFrame();
//Assert for Announcement Display
Logger.LogAssertion("VerifyAnnouncementDisplay", ScenarioContext.
Current.ScenarioInfo.Title, () => Assert.AreEqual(announcement.Name,
announcementDefaultUxPage.GetAnnouncementDetails(announcement.Name)));
//Close the light box
announcementDefaultUxPage.CloseAnnoucementLightBox();
Logger.LogMethodExit("ManageAnnouncement", "VerifyAnnouncementInAnnouncementFrame",
base.IsTakeScreenShotDuringEntryExit);
}
public ActionResult DeleteAnnouncement(int id, Announcement model)
{
try
{
var result = _announcementService.Delete(id);
if (result)
{
string bodySubject = "Web portal changes - Announcement Details delete";
var message = "Announcement Details :" + model.AnnouncementDetails + "<br/>Announcement Url :" + model.Url + "<br/>Announcement deleted successfully";
SendMailToAdmin(message, bodySubject);
Success("Announcement updated successfully!", true);
}
else
{
Danger("Something went wrong! Please try again.", true);
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Announcement(Announcement model)
{
if (model.ExpirationDate <= DateTime.Now && !(model.ExpirationDate.Equals(DateTime.MinValue)))
{
ModelState.AddModelError("TimeError", "We can't go back to the past");
return(View("Announcement"));
}
if (ModelState.IsValid)
{
var announcement = new Announcement()
{
Content = model.Content,
CreateDate = DateTime.Now,
ExpirationDate = model.ExpirationDate,
};
unitOfWork.Repository <Announcement>().Add(announcement);
unitOfWork.Complete();
return(RedirectToAction("Index", "Home"));
}
return(View("Announcement"));
}
public async Task <IActionResult> Remove(int id)
{
Announcement announcement = await AnnouncementService.FindByIdAsync(id);
if (announcement == null)
{
return(NotFound());
}
if (!announcement.User.Equals(CurrentUser))
{
return(Unauthorized());
}
announcement = await AnnouncementService.RemoveAnnouncement(id);
if (announcement == null)
{
return(UnprocessableEntity(new { message = "Duyuru silinemedi" }));
}
return(Ok());
}
public async Task <IActionResult> PostAnnouncement(Announcement announcement)
{
ModelState[nameof(Announcement.DatePosted)].ValidationState
= ModelValidationState.Valid;
if (ModelState.IsValid &&
await AnnouncementService.PostAnnouncementAsync
(
ClassroomName,
User.Id,
announcement,
FormatDateTime,
ModelErrors
))
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.OperationType = "Post";
return(View("PostEditAnnouncement", announcement));
}
}
public async Task <IActionResult> Add(AddAnnouncement addAnnouncement)
{
if (ModelState.IsValid)
{
var announcement = new Announcement
{
Title = addAnnouncement.Title,
Content = addAnnouncement.Content,
PostDate = DateTime.UtcNow,
UrlSlug = Utils.GenerateSlug(addAnnouncement.Title)
};
await _naniWebContext.Announcements.AddAsync(announcement);
await _naniWebContext.SaveChangesAsync();
return(RedirectToAction("List"));
}
TempData["Error"] = true;
return(RedirectToAction("Add"));
}
private void enterState_Game()
{
foreach (Player player in Game.players)
{
Board board = player.board;
IBoardGUI gui = (IBoardGUI)Activator.CreateInstance(Type.GetType("Assets.Scripts.GUI.Boards." + board.GetType().Name + "GUI, Assembly-CSharp"));
gui.createBoard(board);
}
uiControllerGame = UIControllerGame.getInstance();
uiControllerGame.createMinionAndTowerButtons();
MouseHandler.initialize(this);
// Game sinifindan bilgileri alarak oyun icin gerekli yuklemeleri ve atamalari yap.
Announcement.make("Welcome to the Summoner's rift!", Announcement.ScreenPosition.MiddleTop, 2.0f);
updateCashAndIncome();
loadGameFlag = true;
StartCoroutine(sendLoadReadyMessage());
}
public async Task DeleteAnnouncementShouldReturnFalseIfInvalidIdIsGiven()
{
var announcement = new Announcement
{
Creator = "creator1",
Title = "title1",
Content = "content1",
ImageLink = "image1",
OfficialArticleLink = "article1",
Date = DateTime.UtcNow,
};
await dbContext.Announcements.AddAsync(announcement);
await dbContext.SaveChangesAsync();
var id = "invalid";
var announcementService = new AnnouncementService(dbContext, mapper);
Assert.True(dbContext.Announcements.Count() == 1);
Assert.False(await announcementService.DeleteAnnouncementAsync(id));
Assert.True(dbContext.Announcements.Count() == 1);
}
public async Task <ActionResult> Create([Bind(Include = "Id,EmployeeID,EmployeeName,Title,Body,Deleted,CreatedAt,LastUpdatedAt")] Announcement announcement)
{
if (string.IsNullOrEmpty(announcement.Title) || string.IsNullOrEmpty(announcement.Body))
{
ViewBag.Error = "Form was not Completed Properly";
return(View(announcement));
}
var id = User.Identity.GetUserId();
var user = _employeeRepository.GetAll().Where(x => x.UserId == id).FirstOrDefault();
if (user == null)
{
return(View("Error"));
}
announcement.EmployeeID = user.EmployeeNumber;
announcement.EmployeeName = user.FullName;
announcement.CreatedAt = DateTime.Now;
announcement.LastUpdatedAt = DateTime.Now;
db.Announcements.Add(announcement);
await db.SaveChangesAsync();
return(RedirectToAction("Dashboard", "Admin"));
}
protected abstract void AnnounceInternal (Announcement announcent);
private void AddRecentAnnouncement (Announcement announcement)
{
List<Announcement> recent_announcements =
GetRecentAnnouncements (announcement.FolderIdentifier);
if (!IsRecentAnnouncement (announcement))
recent_announcements.Add (announcement);
if (recent_announcements.Count > this.max_recent_announcements)
recent_announcements.RemoveRange (0, recent_announcements.Count - this.max_recent_announcements);
}
private bool IsRecentAnnouncement (Announcement announcement)
{
if (!this.recent_announcements.ContainsKey (announcement.FolderIdentifier)) {
return false;
} else {
foreach (Announcement recent_announcement in GetRecentAnnouncements (announcement.FolderIdentifier)) {
if (recent_announcement.Message.Equals (announcement.Message))
return true;
}
return false;
}
}
// ...
public IList<Announcement> GetAnnouncements(int eventId)
{
using (OCCDB db = new OCCDB())
{
var result = new List<Announcement>();
foreach (var announcement in db.Events.Find(eventId).Announcements)
{
var a = new Announcement();
Mapper.CopyProperties(announcement, a);
result.Add(a);
}
return result;
}
}
public void CreateAnnouncement(Announcement announcement)
{
using (OCCDB db = new OCCDB())
{
Data.Announcement a = new Data.Announcement()
{
Event_ID = announcement.EventID,
Title = announcement.Title,
Content = announcement.Content,
PublishDate = announcement.PublishDate
};
db.Announcements.Add(a);
db.SaveChanges();
}
}
public static MsCrmResultObject GetAnnouncementInfo(Guid announcementId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
A.new_announcementId Id
,A.new_name Name
,A.new_content Content
,A.new_imageurl ImageUrl
,CAST({2}.dbo.fn_UTCToTzSpecificLocalTime(A.CreatedOn, us.TimeZoneBias, us.TimeZoneDaylightBias,us.TimeZoneDaylightYear, us.TimeZoneDaylightMonth, us.TimeZoneDaylightDay, us.TimeZoneDaylightHour,us.TimeZoneDaylightMinute, us.TimeZoneDaylightSecond, 0, us.TimeZoneDaylightDayOfWeek,us.TimeZoneStandardBias, us.TimeZoneStandardYear, us.TimeZoneStandardMonth, us.TimeZoneStandardDay,us.TimeZoneStandardHour, us.TimeZoneStandardMinute, us.TimeZoneStandardSecond, 0,us.TimeZoneStandardDayOfWeek) as DATETIME) CreatedOn
FROM
new_announcement A (NoLock)
INNER JOIN
SystemUser SU (NoLock)
ON
SU.SystemUserId = '{1}'
INNER JOIN
dbo.UserSettingsBase US (NoLock)
ON
US.SystemUserId =SU.SystemUserId
WHERE
A.new_announcementId = '{0}'
ORDER BY
A.CreatedOn DESC";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, announcementId, Globals.AdminId, Globals.DatabaseName));
if (dt != null && dt.Rows.Count > 0)
{
Announcement _announcement = new Announcement();
_announcement.AnnouncementId = (Guid)dt.Rows[0]["Id"];
_announcement.Caption = dt.Rows[0]["Name"] != DBNull.Value ? dt.Rows[0]["Name"].ToString() : string.Empty;
_announcement.Description = dt.Rows[0]["Content"] != DBNull.Value ? dt.Rows[0]["Content"].ToString() : string.Empty;
_announcement.ImagePath = dt.Rows[0]["ImageUrl"] != DBNull.Value ? dt.Rows[0]["ImageUrl"].ToString() : "no_image_available.png";
if (dt.Rows[0]["CreatedOn"] != DBNull.Value)
{
_announcement.CreatedOnString = dt.Rows[0]["CreatedOn"] != DBNull.Value ? ((DateTime)dt.Rows[0]["CreatedOn"]).ToString("dd MMMM yyyy ddddd HH:mm", new CultureInfo("tr-TR", false)) : string.Empty;
_announcement.CreatedOn = (DateTime)dt.Rows[0]["CreatedOn"];
}
#region | GET ATTACHMENTS |
MsCrmResultObject attachmentResult = AttachmentFileHelper.GetAnnouncementAttachmentFiles(announcementId, sda);
if (attachmentResult.Success)
{
_announcement.AttachmentFileList = (List<AttachmentFile>)attachmentResult.ReturnObject;
}
#endregion
returnValue.Success = true;
returnValue.ReturnObject = _announcement;
}
else
{
returnValue.Result = "M026"; //"İlgili duyuruya ait bilgiye ulaşılamadı.";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public void Delete(Announcement entity)
{
throw new System.NotImplementedException();
}
public AnnouncementIdentifier(NetworkInterface inter, Announcement announcement)
{
_interface = inter.Index;
_address = announcement.Source;
_hash = announcement.Hash;
}
internal void OnSessionAnnounce(NetworkInterfaceHandler interfaceHandler, Announcement announcement)
{
lock (_sessionData)
{
AnnouncementIdentifier id = new AnnouncementIdentifier(interfaceHandler.NetworkInterface, announcement);
SessionData sessionData = null;
bool knownAnnouncement = _announcements.TryGetValue(id, out sessionData);
if (!knownAnnouncement)
{
announcement.Decompress();
Stream stream = new MemoryStream(announcement.Payload.Array, announcement.Payload.Offset, announcement.Payload.Count);
SessionDescription description = SessionDescription.Load(stream);
description.SetReadOnly();
SdpSession session = new SdpSession(description, interfaceHandler.NetworkInterface);
SessionAnnouncement sessionAnnouncement = null;
if (_sessionData.TryGetValue(session, out sessionData))
{
sessionAnnouncement = sessionData.Session;
}
if (sessionData != null)
{
if (description.IsUpdateOf(sessionAnnouncement.SessionDescription))
{
sessionAnnouncement = new SessionAnnouncement(description, interfaceHandler.NetworkInterface);
SessionAnnouncement oldAnnouncement = sessionData.Session;
sessionData.Session = sessionAnnouncement;
_announcements.Remove(sessionData.Id);
sessionData.Id = id;
SynchronizationContextPost(o =>
{
lock (Sessions)
{
Sessions.Replace(oldAnnouncement, sessionAnnouncement);
}
});
}
}
else
{
sessionAnnouncement = new SessionAnnouncement(description, interfaceHandler.NetworkInterface);
sessionData = new SessionData()
{
Session = sessionAnnouncement,
Timer = new Timer(OnTimeOut, session, System.Threading.Timeout.Infinite, System.Threading.Timeout.Infinite),
Id = id
};
_sessionData.Add(session, sessionData);
_announcements.Add(id, sessionData);
SynchronizationContextPost(o =>
{
lock (Sessions)
{
Sessions.Add(sessionAnnouncement);
}
});
}
}
sessionData.TimeOutTime = DateTime.Now + DefaultTimeOut;
sessionData.Timer.Change(DefaultTimeOut, TimeSpan.FromMilliseconds(-1));
}
}
void ListenerAnnouncementReceivedDelegate (Announcement announcement)
{
string identifier = Identifier;
if (!announcement.FolderIdentifier.Equals (identifier))
return;
if (!announcement.Message.Equals (CurrentRevision)) {
while (this.is_syncing)
Thread.Sleep (100);
Logger.LogInfo (Name, "Syncing due to announcement");
if (Status == SyncStatus.Paused)
Logger.LogInfo (Name, "We're paused, skipping sync");
else
SyncDownBase ();
}
}
public void PutAnnoucement(Guid id, Announcement announcement)
{
var a = _uow.AnnouncementRepo.FindById(id);
a.Name = announcement.Name;
a.Content = announcement.Content;
a.Description = announcement.Description;
a.StartDate = announcement.StartDate;
a.AwardCeiling = announcement.AwardCeiling;
a.AwardFloor = announcement.AwardFloor;
a.MaxDuration = announcement.MaxDuration;
a.PostDate = announcement.PostDate;
a.EstimateTotal = announcement.EstimateTotal;
a.LastUpdated = DateTime.UtcNow;
_uow.Commit();
}
public static Announcement CreateAnnouncement(int ID, int event_ID, global::System.DateTime publishDate)
{
Announcement announcement = new Announcement();
announcement.ID = ID;
announcement.Event_ID = event_ID;
announcement.PublishDate = publishDate;
return announcement;
}
public void AddToAnnouncements(Announcement announcement)
{
base.AddObject("Announcements", announcement);
}
public static MsCrmResultObject GetAnnouncementList(Guid portalId, Guid portalUserId, int start, int end, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"DECLARE @Date DATETIME = GETUTCDATE()
SELECT
*
FROM
(
SELECT
D.*
,COUNT(0) OVER() AS TotalRow
FROM
(
SELECT
B.*
,ROW_NUMBER() OVER(ORDER BY B.CreatedOn DESC) AS RowNumber
FROM
(
SELECT DISTINCT
A.new_announcementId Id
,A.new_name Name
,A.new_content Content
,A.new_imageurl ImageUrl
,CAST({1}.dbo.fn_UTCToTzSpecificLocalTime(A.CreatedOn, us.TimeZoneBias, us.TimeZoneDaylightBias,us.TimeZoneDaylightYear, us.TimeZoneDaylightMonth, us.TimeZoneDaylightDay, us.TimeZoneDaylightHour,us.TimeZoneDaylightMinute, us.TimeZoneDaylightSecond, 0, us.TimeZoneDaylightDayOfWeek,us.TimeZoneStandardBias, us.TimeZoneStandardYear, us.TimeZoneStandardMonth, us.TimeZoneStandardDay,us.TimeZoneStandardHour, us.TimeZoneStandardMinute, us.TimeZoneStandardSecond, 0,us.TimeZoneStandardDayOfWeek) as DATETIME) CreatedOn
FROM
new_announcement A (NoLock)
JOIN
new_new_user_new_role AS UR (NOLOCK)
ON
UR.new_userid='{2}'
JOIN
new_role AS RD (NOLOCK)
ON
RD.new_roleId=UR.new_roleid
AND
Rd.statecode=0
AND
RD.statuscode=1 --Active
JOIN
new_new_announcement_new_role AS ERDF (NOLOCK)
ON
ERDF.new_announcementid=A.new_announcementId
AND
ERDF.new_roleid=RD.new_roleId
INNER JOIN
dbo.UserSettingsBase US (NoLock)
ON
US.SystemUserId ='{0}'
WHERE
@Date BETWEEN A.new_startdate AND A.new_enddate
AND
A.new_portalId='{3}'
AND
A.StateCode = 0
AND
A.StatusCode=1 --Active
) AS B
) AS D
) AS C
WHERE
C.RowNumber BETWEEN {4} AND {5}
ORDER BY
C.RowNumber ASC";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, Globals.AdminId, Globals.DatabaseName, portalUserId, portalId.ToString(), start.ToString(), end.ToString()));
if (dt != null && dt.Rows.Count > 0)
{
List<Announcement> returnList = new List<Announcement>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Announcement _announcement = new Announcement();
_announcement.AnnouncementId = (Guid)dt.Rows[i]["Id"];
_announcement.Caption = dt.Rows[i]["Name"] != DBNull.Value ? dt.Rows[i]["Name"].ToString() : string.Empty;
_announcement.Description = dt.Rows[i]["Content"] != DBNull.Value ? dt.Rows[i]["Content"].ToString() : string.Empty;
_announcement.ImagePath = dt.Rows[i]["ImageUrl"] != DBNull.Value ? dt.Rows[i]["ImageUrl"].ToString() : string.Empty;
if (dt.Rows[i]["TotalRow"] != DBNull.Value)
{
returnValue.RecordCount = (int)dt.Rows[i]["TotalRow"];
}
if (dt.Rows[i]["CreatedOn"] != DBNull.Value)
{
_announcement.CreatedOn = (DateTime)dt.Rows[i]["CreatedOn"];
_announcement.CreatedOnString = dt.Rows[i]["CreatedOn"] != DBNull.Value ? ((DateTime)dt.Rows[i]["CreatedOn"]).ToString("dd MMMM yyyy ddddd HH:mm", new CultureInfo("tr-TR", false)) : string.Empty;
}
returnList.Add(_announcement);
}
returnValue.Success = true;
returnValue.ReturnObject = returnList;
}
else
{
returnValue.Success = true;
returnValue.Result = "M025"; //"Duyuru kaydı bulunamadı!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public void OnAnnouncement (Announcement announcement)
{
Logger.LogInfo ("Listener", "Got message " + announcement.Message + " from " +
announcement.FolderIdentifier + " on " + Server);
if (IsRecentAnnouncement (announcement))
return;
AddRecentAnnouncement (announcement);
AnnouncementReceived (announcement);
}
public void UpdateAnnouncement(Announcement announcement)
{
using (OCCDB db = new OCCDB())
{
var a = db.Announcements.Find(announcement.ID);
if (a == null) throw new ArgumentException("Announcement not found");
a.Title = announcement.Title;
a.Content = announcement.Content;
a.PublishDate = announcement.PublishDate;
db.SaveChanges();
}
}
public void CreateAnnoucement(Announcement a)
{
_uow.AnnouncementRepo.Add(a);
_uow.Commit();
}
