public async Task <ActionResult <Models.Bulletin> > Get()
 {
     Models.Bulletin Bulletin = new Models.Bulletin();
     try
     {
         Models.BulletinMgr mgr = new Models.BulletinMgr(AppConfig);
         Bulletin = await mgr.GetBulletin();
     }
     catch (Exception e)
     {
         System.Diagnostics.Trace.TraceError($"Error: Cannot find bulletin. Exception: {e.Message}");
     }
     return(Bulletin);
 }
        public async Task <IActionResult> AddBulletin(CreateBulletinModel inputModel)
        {
            if (!ModelState.IsValid)
            {
                return(View());
            }


            try
            {
                var loggedInUser     = HttpContext.User;
                var loggedInUserName = loggedInUser.Identity.Name;

                var id   = (from u in context.RunningNumber where u.Type.Equals("BNumber") select u).FirstOrDefault();
                var user = (from u in context.UserSspm where u.Username.Equals(loggedInUserName) select u).FirstOrDefault();

                int num;
                if (id.Number == null)
                {
                    num = 100001;
                }
                else
                {
                    num = Convert.ToInt32(id.Number);
                    num = num + 1;
                }

                Models.Bulletin ord = new Models.Bulletin
                {
                    UserId  = user.UserId,
                    Subject = inputModel.Subject,
                    Note    = inputModel.Note,
                    Time    = DateTime.Now,
                    Bnumber = num.ToString(),
                };


                // Add the new object to the Orders collection.
                context.Bulletin.Add(ord);
                await context.SaveChangesAsync();


                var query = from xx in context.RunningNumber
                            where xx.Type.Equals("BNumber")
                            select xx;

                foreach (RunningNumber RunTaskID in query)
                {
                    RunTaskID.Number = num.ToString();
                }

                // Submit the changes to the database.
                try
                {
                    await context.SaveChangesAsync();
                }
                catch (Exception e)
                {
                    Console.WriteLine(e);
                    // Provide for exceptions.
                }

                return(RedirectToAction("Index", "Home"));
            }
            catch (Exception ex)
            {
                var message = ex.Message;
                return(RedirectToAction("Index", "Home"));
            }
        }
 public async Task OnGet()
 {
     Models.BulletinMgr mgr = new Models.BulletinMgr(AppConfig);
     Bulletin = await mgr.GetBulletin();
 }