public async Task <AnalystContactModel> PostAnalystContact(AnalystContactModel model)
{
await _context.AnalystContacts.AddAsync(model);
await _context.SaveChangesAsync();
return(model);
}
public List <AnalystContactModel> UserMailBox()
{
using (SqlConnection con = new SqlConnection("Server=DESKTOP-7KC40QR\\SQLEXPRESS;Database=SH.WebAPP;Integrated Security=True;MultipleActiveResultSets=true"))
{
SqlCommand cmd = new SqlCommand("sp_GetAllRowsOfViewUserMailBox", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
AnalystContactModel analystContactModel = new AnalystContactModel();
analystContactModel.to = sdr["to"].ToString();
analystContactModel.Subject = sdr["Subject"].ToString();
analystContactModel.Message = sdr["Message"].ToString();
analystContactModel.Timestamp = Convert.ToDateTime(sdr["Timestamp"]);
userContact.Add(analystContactModel);
}
}
return(userContact);
}
public ActionResult 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())
{
AnalystContactModel analystContactModel = new AnalystContactModel
{
Id = reader.GetGuid(0),
to = reader.GetString(1),
Subject = reader.GetString(2),
Message = reader.GetString(3),
Active = reader.GetBoolean(4),
Timestamp = reader.GetDateTime(5)
};
AnalystContactList.Add(analystContactModel);
ViewData["Message"] = analystContactModel;
return(View());
}
}
else
{
//
}
reader.Close();
}
return(View());
}
