How can I show data for tickets which were created in Last Week? I tried searching on google, but unable to make the code work. So, what I want is all chat logs that were created in Lastweek. Lastweek starts from Monday, and ends on Sunday.
- Chat Model Class
public class Chat
{
[Key]
public int ChatId { get; set; }
[Required]
public string CustName { get; set; }
public string Query { get; set; }
public string Resolution { get; set; }
[Required]
public DateTime ChatStartDateTime { get; set; }
public DateTime? ChatCreateDateTime { get; set; }
public DateTime? ChatEndDateTime { get; set; }
public int Id { get; set; }
public string Username { get; set; }
public string FirstName { get; set; }
public string Email { get; set; }
[ForeignKey("Id")]
public virtual User User { get; set; }
}
- Chat Log Controller code is here
var getSunday = DateTime.Now.Date.AddDays(-7);
var getSat = DateTime.Now.Date.AddDays(7);
//var dayOfWeek = DayOfWeek.Monday;
ViewBag.lastWeek = db.Chats.Where(x => x.ChatCreateDateTime >= getSunday && x.ChatCreateDateTime <= getSat).Count();
Any help is much appreciated.