public Event_AttendingStatus EventGoingInsert(int Userid, Event_AttendingStatus obj)
{
using (var context = _dbContextFactory.CreateConnection())
{
if (obj.UserGoingStatus == "Maybe")
{
var Count = context.Event_AttendingStatus.Where(x => x.Status == true && x.UserGoingStatus == obj.UserGoingStatus && x.EventId == obj.EventId && x.UserId == obj.UserId).Count();
if (Count == 0)
{
context.Event_AttendingStatus.Add(obj);
context.SaveChanges();
}
var DeclineCount = context.Event_AttendingStatus.Where(x => x.Status == true && x.UserGoingStatus == "Decline" && x.EventId == obj.EventId && x.UserId == obj.UserId).Count();
if (DeclineCount >= 1)
{
Event_AttendingStatus atteningstaus = context.Event_AttendingStatus.Where(x => x.Status == true && x.EventId == obj.EventId && x.UserGoingStatus == "Decline" && x.UserId == obj.UserId).FirstOrDefault();
context.Event_AttendingStatus.Remove(atteningstaus);
context.SaveChanges();
}
}
else if (obj.UserGoingStatus == "Decline")
{
var DeclineCount = context.Event_AttendingStatus.Where(x => x.Status == true && x.UserGoingStatus == "Maybe" && x.EventId == obj.EventId && x.UserId == obj.UserId).Count();
var Maybedecline = context.Event_AttendingStatus.Where(x => x.Status == true && x.UserGoingStatus == "Decline" && x.EventId == obj.EventId && x.UserId == obj.UserId).Count();
if (Maybedecline >= 1)
{
}
else
{
context.Event_AttendingStatus.Add(obj);
context.SaveChanges();
}
if (DeclineCount >= 1)
{
Event_AttendingStatus attendingstaus = context.Event_AttendingStatus.Where(x => x.Status == true && x.EventId == obj.EventId && x.UserGoingStatus == "Maybe" && x.UserId == obj.UserId).FirstOrDefault();
context.Event_AttendingStatus.Remove(attendingstaus);
context.SaveChanges();
}
}
else if (obj.UserGoingStatus == "AmGoing")
{
var DeclineCount = context.Event_AttendingStatus.Where(x => x.Status == true && x.UserGoingStatus == "Maybe" && x.EventId == obj.EventId && x.UserId == obj.UserId).Count();
var AmGoing = context.Event_AttendingStatus.Where(x => x.Status == true && x.UserGoingStatus == "AmGoing" && x.EventId == obj.EventId && x.UserId == obj.UserId).Count();
var Maybedecline = context.Event_AttendingStatus.Where(x => x.Status == true && x.UserGoingStatus == "Decline" && x.EventId == obj.EventId && x.UserId == obj.UserId).Count();
if (AmGoing >= 1)
{
}
else
{
context.Event_AttendingStatus.Add(obj);
context.SaveChanges();
}
}
}
return(obj);
}
public JsonResult EventGoing(int Type, string Status, int EventId)
{
Event_AttendingStatus Attending = new Event_AttendingStatus()
{
UserId = Convert.ToInt64(Session["UserId"].ToString()),
UserGoingStatus = Status,
Status = true,
CreatedOn = DateTime.Now,
EventId = EventId
};
EventService.EventGoingInsert(Convert.ToInt32(Session["UserId"].ToString()), Attending);
var data = EventService.EventGoingList(EventId, Convert.ToInt32(Session["UserId"]));
return Json(data, JsonRequestBehavior.AllowGet);
}
public JsonResult EventGoing(int Type, string Status, int EventId)
{
Event_AttendingStatus Attending = new Event_AttendingStatus()
{
UserId = Convert.ToInt64(Session["UserId"].ToString()),
UserGoingStatus = Status,
Status = true,
CreatedOn = DateTime.Now,
EventId = EventId
};
EventService.EventGoingInsert(Convert.ToInt32(Session["UserId"].ToString()), Attending);
var data = EventService.EventGoingList(EventId, Convert.ToInt32(Session["UserId"]));
return(Json(data, JsonRequestBehavior.AllowGet));
}
public Event_AttendingStatus EventGoingInsert(int Userid, Event_AttendingStatus obj)
{
return(_IEventCategoryRepo.EventGoingInsert(Userid, obj));
}