public async Task <AdminContactModel> PostAdminContact(AdminContactModel model)
{
await _context.AdminContacts.AddAsync(model);
await _context.SaveChangesAsync();
return(model);
}
public List <AdminContactModel> AnalystMailBox()
{
using (SqlConnection con = new SqlConnection("Server=DESKTOP-7KC40QR\\SQLEXPRESS;Database=SH.WebAPP;Integrated Security=True;MultipleActiveResultSets=true"))
{
SqlCommand cmd = new SqlCommand("sp_GetAllRowsOfViewAnalystMailBox", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
AdminContactModel adminContactModel = new AdminContactModel();
adminContactModel.to = sdr["to"].ToString();
adminContactModel.Subject = sdr["Subject"].ToString();
adminContactModel.Message = sdr["Message"].ToString();
adminContactModel.Timestamp = Convert.ToDateTime(sdr["Timestamp"]);
anlaystContacts.Add(adminContactModel);
}
}
return(anlaystContacts);
}
public IActionResult MailBox()
{
using (var connection = new SqlConnection("Server=DESKTOP-7KC40QR\\SQLEXPRESS;Database=SH.WebAPP;Integrated Security=True;MultipleActiveResultSets=true"))
{
SqlCommand command = new SqlCommand(
"SELECT * FROM dbo.AdminContacts;",
connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
AdminContactModel adminContactModel = new AdminContactModel
{
Id = reader.GetGuid(0),
to = reader.GetString(1),
Subject = reader.GetString(2),
Message = reader.GetString(3),
Active = reader.GetBoolean(4),
Timestamp = reader.GetDateTime(5)
};
AdminContactList.Add(adminContactModel);
return(View());
}
}
else
{
//
}
reader.Close();
}
return(View());
}
