public void CreateMeeting(int organizorId, string email, string mobile, System.DateTime dateTime, string purpose)
{
using (var db = new VMSDbEntities())
{
db.spCreateMeeting(organizorId, email, mobile, dateTime, purpose);
}
}
public bool UpdateMeeting(int id, MeetingState state, string email = null)
{
using (var db = new VMSDbEntities())
{
Random randomGenerator = new Random();
var otp = state == MeetingState.Acknowledged ? randomGenerator.Next(100000, 999999) : -1;
db.spUpdateMeeting(id, (int)state, email ?? string.Empty, otp);
}
return(true);
}
public Meeting GetMeeting(int id)
{
using (var db = new VMSDbEntities())
{
var meeting = db.Meetings
.Where(m => m.MeetingId == id)
.FirstOrDefault();
meeting.Visitor = db.Visitors
.Where(v => v.VisitorId == meeting.VisitorId)
.FirstOrDefault();
return(meeting);
}
}