public static OfficialXComplaintsAssigned GetDetails(int id)
{
OfficialXComplaintsAssigned info = null;
info = BaseDataAccess.GetRecords <OfficialXComplaintsAssigned>(String.Format("select * from OfficialXComplaintsAssigned where Id='{0}'", id));
info.GovernmentOfficial = GovernmentOfficialDA.GetDetails(info.OfficialId);
info.Complaint = ComplaintDA.GetDetails(info.ComplaintId);
return(info);
}
public static ComplaintXEscalationLevel GetDetails(int id)
{
ComplaintXEscalationLevel info = null;
info = BaseDataAccess.GetRecords <ComplaintXEscalationLevel>(String.Format("select * from ComplaintXEscalationLevel where Id='{0}'", id));
if (info != null)
{
info.Complaint = ComplaintDA.GetDetails(info.ComplaintId);
}
return(info);
}
public static List <ComplaintXEscalationLevel> GetAllByComplaintId(int Id)
{
List <ComplaintXEscalationLevel> list = null;
list = BaseDataAccess.GetRecordsList <ComplaintXEscalationLevel>(String.Format("Select * from ComplaintXEscalationLevel where ComplaintId='{0}'", Id));
foreach (ComplaintXEscalationLevel info in list)
{
info.Complaint = ComplaintDA.GetDetails(info.ComplaintId);
}
return(list);
}
public static List <ComplaintXStatus> GetAllByStatus(int StatusId)
{
List <ComplaintXStatus> list = null;
list = BaseDataAccess.GetRecordsList <ComplaintXStatus>(String.Format("select * from ComplaintXStatus where Status='{0}' ", StatusId));
foreach (ComplaintXStatus info in list)
{
info.Complaint = ComplaintDA.GetDetails(info.ComplaintId);
info.ComplaintStatus = ComplaintStatusDA.GetDetails(info.StatusId);
}
return(list);
}
public static List <OfficialXComplaintsAssigned> GetAllByOfficialId(int officialId)
{
List <OfficialXComplaintsAssigned> list = null;
list = BaseDataAccess.GetRecordsList <OfficialXComplaintsAssigned>(string.Format("Select * from OfficialXComplaintsAssigned where OfficialId = '{0}'", officialId));
foreach (OfficialXComplaintsAssigned info in list)
{
info.GovernmentOfficial = GovernmentOfficialDA.GetDetails(info.OfficialId);
info.Complaint = ComplaintDA.GetDetails(info.ComplaintId);
}
return(list);
}