internal void InitContext()
{
var builder = new DbContextOptionsBuilder <FeedBackManagementSystemContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString());
var context = new FeedBackManagementSystemContext(builder.Options);
var eventInfo = Enumerable.Range(1, 1)
.Select(i => new TblEventEnrollmentDetails
{
EmployeeId = 273690,
Id = 1,
EventId = "EVNT00047261",
EventName = "Bags of Joy Distribution"
});
var login = Enumerable.Range(1, 1)
.Select(i => new TblLogin
{
UserId = "273690",
RoleId = 1,
Id = 1
});
context.TblLogin.AddRange(login);
var changedTblLogin = context.SaveChanges();
context.TblEventEnrollmentDetails.AddRange(eventInfo);
var changed = context.SaveChanges();
_context = context;
}
public int Save(Feedback feedbackDetails)
{
TblFeedbackDetails obj = new TblFeedbackDetails();
obj.EmployeeId = feedbackDetails.EmployeeId;
obj.EventId = feedbackDetails.EventId;
obj.FeedbackOptionId = feedbackDetails.FeedbackOptionId;
obj.RatingId = feedbackDetails.RatingId;
obj.UserCategoryId = feedbackDetails.UserCategoryId;
obj.Answer1 = feedbackDetails.Qstn1Ans;
obj.Answer2 = feedbackDetails.Qstn2Ans;
_context.TblFeedbackDetails.Add(obj);
return(_context.SaveChanges());
}
public int SendMail(List <PendingFeedback> pendingFeedback)
{
int result = 0;
foreach (var user in pendingFeedback)
{
if (user.UserTypeId == 1)
{
var participatedUser = _context.TblEventEnrollmentDetails.Where(x => x.Id == user.EventPrimaryId).FirstOrDefault();
participatedUser.IsReminderSent = true;
_context.Update(participatedUser);
result = _context.SaveChanges();
}
else
{
var notParticipatedUser = _context.TblNotParticipated.Where(x => x.Id == user.EventPrimaryId).FirstOrDefault();
notParticipatedUser.IsReminderSent = true;
_context.Update(notParticipatedUser);
result = _context.SaveChanges();
}
}
return(result);
}
