public ApiResponse Login(string UserName, string Password)
{
RepoDemo.MeetingDemoEntities DB = new RepoDemo.MeetingDemoEntities();
var Obj = DB.Usp_Login(UserName, Password).ToList <Usp_Login_Result>().FirstOrDefault();
if (Obj.Status == 0)
{
return new ApiResponse {
Status = "Invalid", Message = "Invalid User."
}
}
;
if (Obj.Status == -1)
{
return new ApiResponse {
Status = "Inactive", Message = "User Inactive."
}
}
;
else
{
return new ApiResponse {
Status = "Success", Message = UserName
}
};
}
}
}
public void DeleteMeetingById(MeetingInfo meeting)
{
using (var context = new RepoDemo.MeetingDemoEntities())
{
context.MeetingDetails.Remove(context.MeetingDetails.Single(x => x.MeetingId == meeting.MeetingId));
context.SaveChanges();
}
}
public MeetingInfo GetMeetingById(int meetingId)
{
RepoDemo.MeetingDemoEntities DB = new RepoDemo.MeetingDemoEntities();
var meeting = DB.MeetingDetails.FirstOrDefault(x => x.MeetingId == meetingId);
return(new MeetingInfo
{
MeetingAgenda = meeting.MeetingAgenda,
MeetingAttendees = meeting.MeetingAttendees,
MeetingDateTime = meeting.MeetingDateTime,
MeetingId = meeting.MeetingId,
MeetingSubject = meeting.MeetingSubject
});
}
public void SetMeeting(MeetingInfo meeting)
{
using (var context = new RepoDemo.MeetingDemoEntities())
{
var meetingInfo = new MeetingDetail
{
MeetingAgenda = meeting.MeetingAgenda,
MeetingAttendees = meeting.MeetingAttendees,
MeetingDateTime = meeting.MeetingDateTime,
MeetingSubject = meeting.MeetingSubject
};
context.MeetingDetails.Add(meetingInfo);
context.SaveChanges();
}
}
public void UpdateMeetingById(MeetingInfo meeting)
{
using (var context = new RepoDemo.MeetingDemoEntities())
{
var meetingInfo = new MeetingDetail
{
MeetingAgenda = meeting.MeetingAgenda,
MeetingAttendees = meeting.MeetingAttendees,
MeetingDateTime = meeting.MeetingDateTime,
MeetingId = meeting.MeetingId,
MeetingSubject = meeting.MeetingSubject
};
context.Entry(meetingInfo).State = EntityState.Modified;
context.SaveChanges();
}
}
public IEnumerable <MeetingInfo> GetMeetings()
{
List <MeetingInfo> meetings = new List <MeetingInfo>();
RepoDemo.MeetingDemoEntities DB = new RepoDemo.MeetingDemoEntities();
var meetingDetails = DB.MeetingDetails;
foreach (var meeting in meetingDetails)
{
meetings.Add(new MeetingInfo
{
MeetingAgenda = meeting.MeetingAgenda,
MeetingAttendees = meeting.MeetingAttendees,
MeetingDateTime = meeting.MeetingDateTime,
MeetingId = meeting.MeetingId,
MeetingSubject = meeting.MeetingSubject
});
}
return(meetings);
}
