public IHttpActionResult Postannouncement(announcement announcement)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
announcement.announceTime = DateTime.Now;
db.announcements.Add(announcement);
announcement.status = "Active";
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (announcementExists(announcement.ID_announcement))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = announcement.ID_announcement }, announcement));
}
public ActionResult Create([Bind(Include = "ann_id,ann_text,ann_date,ann_severity,ann_visible")] announcement announcement)
{
try
{
if (ModelState.IsValid)
{
announcement.emp_id = Convert.ToInt32(Session["empId"]);
db.announcements.Add(announcement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(announcement));
}
catch (Exception Error)
{
ViewBag.Error = Error.GetBaseException().Message;
if (ViewBag.Error.Contains("fk_announcements_emp_id"))
{
//throw new Exception("You must enter a valid User Id to create an announcement.");
ViewBag.Error = "You must enter a valid User Id to create an announcement.";
}
else if (ViewBag.Error.Contains("ann_emp_id_check"))
{
ViewBag.Error = "You must enter a valid User Id to create an announcement.";
}
else if (ViewBag.Error.Contains("ann_severity_check"))
{
ViewBag.Error = "The announcement severity value must be one of Emergency, Important, or Cautionary.";
}
}
return(View("Error"));
}
public ActionResult Delete(int AnnouncementID)
{
ViewBag.AnnouncementID = AnnouncementID;
announcement announcement = AnnouncementRepository.GetAnnouncementByID(AnnouncementID);
return(PartialView(announcement));
}
public string setAthletesForAnnouncement(AnnouncementForAthletesDTO announcementForAthletesDTO)
{
try
{
announcement announcement = new announcement();
announcement.announcementTitle = announcementForAthletesDTO.announcementTitle;
announcement.announcementDetail = announcementForAthletesDTO.announcementDetail;
announcement.coachId = announcementForAthletesDTO.coachId;
announcement.available = true;
var announce = context.announcement.Add(announcement);
context.SaveChanges();
List <AthleteIdDTO> athletesId = announcementForAthletesDTO.athletesId;
athletesId.ForEach(a => {
announcementByAthlete announceByAthlete = new announcementByAthlete();
announceByAthlete.athleteId = a.athleteId;
announceByAthlete.announcementId = announce.id;
announceByAthlete.available = true;
context.announcementByAthlete.Add(announceByAthlete);
});
context.SaveChanges();
return(CONSTANTES.CONSTANTES.ServiceResponse.ok);
}
catch (Exception e)
{
return(CONSTANTES.CONSTANTES.ServiceResponse.error);
}
}
public async Task EditAnnouncement(Request request, Response response)
{
var userSession = await CheckAuth.Check(request, response, AuthLevel.Organizer);
if (userSession == null)
{
return;
}
var requestJson = request.Json <EditAnnoRequest>();
//判断请求是否有效
if (!Validation.Valid(requestJson, out string reason))
{
await response.BadRequest(reason);
return;
}
//生成修改后对象
var updateAnno = new announcement
{
aid = requestJson.aid,
content = requestJson.content,
update_time = DateTime.Now
};
var annoDb = DbFactory.Get <Announcement>();
await annoDb.SimpleDb.AsUpdateable(updateAnno).IgnoreColumns(it => new { it.create_time }).ExecuteCommandAsync();
await annoDb.InvalidateCache();
await response.OK();
}
public IHttpActionResult Deleteannouncement(int id)
{
announcement announcement = db.announcements.Find(id);
if (announcement == null)
{
return(NotFound());
}
announcement.status = "Inactive";
db.Entry(announcement).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!announcementExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
//db.announcements.Remove(announcement);
//db.SaveChanges();
return(Ok(announcement));
}
public IHttpActionResult Putannouncement(int id, announcement announcement)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != announcement.ID_announcement)
{
return(BadRequest());
}
db.Entry(announcement).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!announcementExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Edit(int AnnouncementID, string CallerType = "")
{
ViewBag.CallerType = CallerType;
announcement announcement = AnnouncementRepository.GetAnnouncementByID(AnnouncementID);
GetData(announcement.ministryID);
return(PartialView(announcement));
}
public ActionResult DeleteConfirmed(Guid id)
{
announcement announcement = db.announcements.Find(id);
db.announcements.Remove(announcement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private announcement ann; //Класс с описанием объявлений
#endregion
#region Constructors
/// <summary>
/// Конуструктор для инициализации переменных
/// </summary>
public Parser()
{
ann = new announcement()
{
region = "Харьковская область",
contact_name = "АН Аверс",
contract_type = "Продажа",
currency = "у.е."
};
}
public ActionResult EditAnnouncement(int annoID)
{
ViewBag.IsAdmin = (bool)Session["adminLoggedIn"];
announcement anno = (from ann in edb.announcements
where ann.ID_announcement == annoID
select ann).FirstOrDefault();
return(View("NewAnnouncement", anno));
}
public IHttpActionResult Getannouncement(int id)
{
announcement announcement = db.announcements.Find(id);
if (announcement == null)
{
return(NotFound());
}
return(Ok(announcement));
}
public ActionResult Create(string a_id, DateTime a_date, string a_content, bool a_display)
{
announcement anns = new announcement();
anns.a_id = a_id;
anns.a_date = a_date;
anns.a_content = a_content;
anns.a_display = a_display;
db.announcement.Add(anns);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteAnnouncement()
{
int ID_announcement = Convert.ToInt32(Request["ID_announcement"]);
announcement delAnno = (from anno in edb.announcements
where anno.ID_announcement == ID_announcement
select anno).FirstOrDefault();
edb.announcements.Remove(delAnno);
edb.SaveChanges();
return(GetClubHomeView());
}
private void postTodb(object sender, RoutedEventArgs e)
{
mainDal post = new mainDal();
announcement a = new announcement();
a.Title = this.titleBox.Text;
a.Contents = this.contentBox.Text;
DateTime d = DateTime.Now;
a.Date = d.ToString();
post.post(a);
this.Close();
}
public ActionResult DeleteConfirmed(int AnnouncementID, string CallerType = "")
{
announcement announcement = AnnouncementRepository.GetAnnouncementByID(AnnouncementID);
AnnouncementRepository.DeleteRecord(announcement);
if (CallerType == "Ministry")
{
return(RedirectToAction("List", new { bdate = "1/1/2015", edate = "1/1/2015", SearchType = "MinistrySearch", MinistryID = announcement.ministryID, CallerType = "Ministry" }));
}
else
{
return(RedirectToAction("List", new { bDate = DateTime.Today, eDate = DateTime.Today.AddDays(30) }));
}
}
public string insertAnnouncement(announcement announcement)
{
try
{
announcement.available = true;
context.announcement.Add(announcement);
context.SaveChanges();
return(CONSTANTES.CONSTANTES.ServiceResponse.ok);
}
catch (Exception e)
{
return(CONSTANTES.CONSTANTES.ServiceResponse.error);
}
}
public ActionResult DeleteConfirmed(int id)
{
try
{
announcement announcement = db.announcements.Find(id);
db.announcements.Remove(announcement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception Error)
{
ViewBag.Error = Error.GetBaseException().Message;
}
return(View("Error"));
}
public void post(announcement a)
{
makeConnection();
string query = "insert into announcement (title,contents,postDate) values(@ti,@co,@pd)";
SqlParameter t = new SqlParameter("ti", a.Title);
SqlParameter c = new SqlParameter("co", a.Contents);
SqlParameter p = new SqlParameter("pd", a.Date);
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(t);
cmd.Parameters.Add(c);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
con.Close();
}
// PUT: api/Announcement/5
public IHttpActionResult Put(int id, [FromBody] announcement value)
{
try
{
value.id = id;
return(ResponseMessage(Request.CreateResponse(new
{
response = announcementService.updateAnnouncement(value)
})));
}
catch (Exception e)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.ToString())));
}
}
public ActionResult Edit([Bind(Include = "GID,Title,body_text,username,date")] announcement announcement)
{
var myrole = new Class1();
var userID = User.Identity.GetUserId();
ViewBag.currentrole = myrole.a(userID);
if (ModelState.IsValid)
{
announcement.username = announcement.username;
announcement.date = System.DateTime.Now;
db.Entry(announcement).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(announcement));
}
public string updateAnnouncement(announcement announcement)
{
try
{
var result = context.announcement.FirstOrDefault(x => x.id == announcement.id);
if (result != null)
{
result.announcementTitle = announcement.announcementTitle;
result.announcementDetail = announcement.announcementDetail;
context.SaveChanges();
}
return(CONSTANTES.CONSTANTES.ServiceResponse.ok);
}
catch (Exception e)
{
return(CONSTANTES.CONSTANTES.ServiceResponse.error);
}
}
// GET: Home/Details/5
public ActionResult Details(Guid?id)
{
var myrole = new Class1();
var userID = User.Identity.GetUserId();
ViewBag.currentrole = myrole.a(userID);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
announcement announcement = db.announcements.Find(id);
if (announcement == null)
{
return(HttpNotFound());
}
return(View(announcement));
}
public ActionResult Create([Bind(Include = "GID,Title,body_text,username,date")] announcement announcement)
{
var myrole = new Class1();
var userID = User.Identity.GetUserId();
ViewBag.currentrole = myrole.a(userID);
if (ModelState.IsValid)
{
announcement.GID = Guid.NewGuid();
announcement.username = User.Identity.Getusern();
announcement.body_text = announcement.body_text;
announcement.date = System.DateTime.Now;
db.announcements.Add(announcement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(announcement));
}
// GET: announcements/Edit/5
public ActionResult Edit(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
announcement announcement = db.announcements.Find(id);
if (announcement == null)
{
return(RedirectToAction("Error"));
}
return(View(announcement));
}
catch (Exception Error)
{
ViewBag.Error = Error.GetBaseException().Message;
}
return(View("Error"));
}
public ActionResult NewAnnouncement(announcement anno)
{
ViewBag.IsAdmin = (bool)Session["adminLoggedIn"];
if (Request.Form.Count == 0)
{
return(View(new announcement()));
}
else
{
if (anno.ID_announcement == 0)
{
announcement newAnno = new announcement
{
topic = Request["topic"], detail = Request["detail"]
};
newAnno.announceTime = DateTime.Now;
newAnno.status = "Active";
edb.announcements.Add(newAnno);
edb.SaveChanges();
}
else
{
int ID_announcement = anno.ID_announcement;
var annoUpdate = edb.announcements
.Where(aa => aa.ID_announcement == ID_announcement)
.Single();
annoUpdate.detail = anno.detail;
annoUpdate.topic = anno.topic;
edb.SaveChanges();
}
return(GetClubHomeView());
}
}
public async Task AddAnnouncement(Request request, Response response)
{
var now = DateTime.Now;
var userSession = await CheckAuth.Check(request, response, AuthLevel.Organizer);
if (userSession == null)
{
return;
}
var requestJson = request.Json <AddAnnoRequest>();
//判断请求是否有效
if (!Validation.Valid(requestJson, out string reason))
{
await response.BadRequest(reason);
return;
}
//插入新公告
var annoDb = DbFactory.Get <Announcement>();
var newAnnouncement = new announcement
{
create_time = now,
update_time = now,
content = requestJson.content
};
await annoDb.SimpleDb.AsInsertable(newAnnouncement).ExecuteCommandAsync();
await annoDb.InvalidateCache();
await response.OK();
}
public string insertAnnouncement(announcement announcement)
{
return(announcementRepository.insertAnnouncement(announcement));
}
public ActionResult Edit(announcement announcement, string CallerType = "")
{
string ReturnUrl = Request.UrlReferrer.ToString();
try
{
//if (contribution.CheckNumber == null) { contribution.CheckNumber = ""; }
if (ModelState.IsValid)
{
//document
foreach (var file in announcement.files)
{
if (file != null && file.ContentLength > 0)
{
int documentTypeID = ConstantRepository.GetConstantByName("Property Document").constantID;
// Get file info
document document = new document();
document.Title = string.Format("{0} document", announcement.Title);
document.DocumentTypeID = documentTypeID;
document.Status = "Active";
document.EnteredBy = User.Identity.Name.ToString();
document.DateEntered = System.DateTime.Today;
document.FileName = Path.GetFileName(file.FileName);
document.ContentLength = file.ContentLength;
document.ContentType = file.ContentType;
document.Author = "Announcement Document";
var path = Path.Combine(Server.MapPath("~/App_Data/ClientFiles"), document.FileName);
// var path = Path.Combine(Server.MapPath("~/public_html/ClientFiles"), document.FileName);
file.SaveAs(path);
db.documents.Add(document);
db.SaveChanges();
announcement.DocumentID = document.documentID;
}
}
db.Entry(announcement).State = EntityState.Modified;
db.SaveChanges();
TempData["Message2"] = string.Format("Announcement update successfully.");
GetData(announcement.ministryID);
/* if (CallerType == "Officer")
* {
* return RedirectToAction("MinistryGeneralAnnouncements", "Announcement", new { ministryID = announcement.ministryID, bDate = announcement.BeginDate, eDate = announcement.EndDate, Requestor = "Officer" });
* }
* */
return(Redirect(ReturnUrl));
/*
* if (CallerType == "Ministry")
* {
* return Redirect(string.Format("/Home/Admin?Page=Announcement&MinistryID={0}&CallerType={1}", announcement.ministryID, "Ministry"));
* }
* else
* {
* return Redirect("/Home/Admin?Page=Announcement");
* }
*/
}
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error editing announcement.");
}
GetData(announcement.ministryID);
return(PartialView(announcement));
}
public string updateAnnouncement(announcement announcement)
{
return(announcementRepository.updateAnnouncement(announcement));
}
