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 <IActionResult> ChatBulletin(CreateBulletinModel inputModel)
{
ViewBag.userMenu = GetMenu();
ViewBag.nothi = Nothi();
if (!ModelState.IsValid)
{
return(View());
}
try
{
var loggedInUser = HttpContext.User;
var loggedInUserName = loggedInUser.Identity.Name;
var user = (from u in context.UserSspm where u.Username.Equals(loggedInUserName) select u).FirstOrDefault();
var ChatNum = (from x in context.BulletinChat
where x.Bnumber.Equals(inputModel.Bnumber)
orderby x.Bchat descending
select x
).FirstOrDefault();
Boolean X = Boolean.ReferenceEquals(ChatNum, null);
int num;
if (X)
{
num = 100000;
}
else
{
num = Convert.ToInt32(ChatNum.Bchat);
num = num + 1;
}
Models.BulletinChat ord = new Models.BulletinChat
{
UserId = user.UserId,
Chat = inputModel.Chat,
Ctime = DateTime.Now,
Bnumber = inputModel.Bnumber,
Bchat = num.ToString(),
};
// Add the new object to the Orders collection.
context.BulletinChat.Add(ord);
await context.SaveChangesAsync();
return(RedirectToAction("Index", "Home"));
}
catch (Exception ex)
{
var message = ex.Message;
return(View());
}
}
