private RoomGuideDataStructure.RoomMembers RetriveMemberObject(DataRow memberRow)
{
RoomGuideDataStructure.RoomMembers roomMember = new RoomGuideDataStructure.RoomMembers();
try
{
roomMember.FirstName = memberRow["FirstName"].ToString();
roomMember.Id = memberRow["Id"].ToString();
roomMember.LastName = memberRow["LastName"].ToString();
roomMember.PhoneNumber = long.Parse(memberRow["PhoneNumber"].ToString());
roomMember.MailId = memberRow["MailId"].ToString();
roomMember.Message = memberRow["Messages"].ToString();
}
catch (Exception exception)
{
roomMember = new RoomGuideDataStructure.RoomMembers();
}
return(roomMember);
}
public RGResponse <List <RoomGuideDataStructure.RoomMembers> > GetRoomMembers()
{
DataTable Members = new DataTable();
List <RoomGuideDataStructure.RoomMembers> roomMembersList = new List <RoomGuideDataStructure.RoomMembers>();
RoomGuideDataStructure.RoomMembers roomMembers = new RoomGuideDataStructure.RoomMembers();
RGResponse <List <RoomGuideDataStructure.RoomMembers> > resp = new RGResponse <List <RoomGuideDataStructure.RoomMembers> >(null);
try
{
RGUtitlity.DataService dataService = new RGUtitlity.DataService();
string query = @"SELECT * FROM bachelorGuide.dbo.[Members] ";
Members = dataService.ExecuteDataTable(query);
if (Members.Rows.Count <= 0)
{
roomMembersList = (from temp in new string[] { string.Empty }
select new RoomGuideDataStructure.RoomMembers
{
FirstName = string.Empty,
Id = string.Empty,
LastName = string.Empty,
MailId = string.Empty,
PhoneNumber = 0,
}).ToList();
}
else
{
for (int index = 0; index <= Members.Rows.Count - 1; index++)
{
roomMembersList.Add(RetriveMemberObject(Members.Rows[index]));
}
}
resp = new RGResponse <List <RoomGuideDataStructure.RoomMembers> >(RGResult.Success, roomMembersList, "");
}
catch (Exception exception)
{
resp = new RGResponse <List <RoomGuideDataStructure.RoomMembers> >(RGResult.Success, null, "Error occured.");
}
return(resp);
}
