public static List<EquipmentType> GetEquipmentTypes()
{
List<EquipmentType> equipmentTypes = new List<EquipmentType>();
DBGateway aGateway = new DBGateway();
string queryType = "select * from equipmnttype";
DataSet ctDataSet = aGateway.Select(queryType);
foreach (DataRow dataRow in ctDataSet.Tables[0].Rows)
{
TelephoneComplainType aType = new TelephoneComplainType();
EquipmentType aEquipmentType = new EquipmentType();
aEquipmentType.TypeID = (int)dataRow["Id"];
aEquipmentType.Name = dataRow["TypeName"].ToString();
equipmentTypes.Add(aEquipmentType);
}
return equipmentTypes;
}
public static List<TelephoneComplain> GetTelephoneComplain(string id,string type)
{
string queryResolve = "select resolvedcomplains.id,phoneuserpersonalinfo.BANumber,phoneuserpersonalinfo.FullName,menucomplainType.Value as ComplainType," +
" allphoneinfo.PhoneNumber,menusrank.Value as Rank,resolvedcomplains.Description,resolvedcomplains.ComplainDate,resolvedcomplains.Remarks,resolvedcomplains.ResolvedDate,resolvedcomplains.ResolvedBy" +
" from resolvedcomplains,menucomplainType,phoneuserpersonalinfo,allphoneinfo," +
" menusRank where menucomplaintype.Id=resolvedcomplains.MenuComplainTypeId" +
" and phoneuserpersonalinfo.Id = resolvedcomplains.TelephoneUserId and phoneuserpersonalinfo.RankId = menusrank.id and resolvedcomplains.AllPhoneInfoID=allphoneinfo.ID and resolvedcomplains.id=" +
id + ";";
string queryPending = "select complains.id,phoneuserpersonalinfo.BANumber,phoneuserpersonalinfo.FullName,menucomplainType.Value as ComplainType," +
" allphoneinfo.PhoneNumber,menusrank.Value as Rank,complains.Description,complains.ComplainDate,complains.Remarks,complains.ResolvedDate,complains.ResolvedBy" +
" from complains,menucomplainType,phoneuserpersonalinfo,allphoneinfo," +
" menusRank where menucomplaintype.Id=complains.MenuComplainTypeId" +
" and phoneuserpersonalinfo.Id = complains.TelephoneUserId and phoneuserpersonalinfo.RankId = menusrank.id and complains.AllPhoneInfoID=allphoneinfo.ID and complains.id=" +
id + ";";
List<TelephoneComplain> aTelephoneComplainList = new List<TelephoneComplain>();
DBGateway aGateway = new DBGateway();
DataSet aDataSet;
if (type == "resolved")
{
aDataSet=aGateway.Select(queryResolve);
}
else
{
aDataSet=aGateway.Select(queryPending);
}
foreach (DataRow dataRow in aDataSet.Tables[0].Rows)
{
TelephoneComplain aTelephoneComplain = new TelephoneComplain();
aTelephoneComplain.BANumber = dataRow["BANumber"].ToString();
aTelephoneComplain.Name = dataRow["FullName"].ToString();
aTelephoneComplain.ComplainType = dataRow["ComplainType"].ToString();
aTelephoneComplain.NewPhoneNumber = dataRow["PhoneNumber"].ToString();
aTelephoneComplain.Rank = dataRow["Rank"].ToString();
aTelephoneComplain.Description = dataRow["Description"].ToString();
aTelephoneComplain.ComplainDate = dataRow["ComplainDate"].ToString();
aTelephoneComplain.ComplainId = dataRow["Id"].ToString();
//aTelephoneComplain.ActionTaken = dataRow["ActionTaken"].ToString();
aTelephoneComplain.ResolvedDate = dataRow["ResolvedDate"].ToString();
aTelephoneComplain.Remarks = dataRow["Remarks"].ToString();
aTelephoneComplain.ResolveBy = dataRow["ResolvedBy"].ToString();
aTelephoneComplainList.Add(aTelephoneComplain);
}
List<TelephoneComplainType> complainTypes = new List<TelephoneComplainType>();
string queryType = "select * from menucomplaintype";
DataSet ctDataSet = aGateway.Select(queryType);
foreach (DataRow dataRow in ctDataSet.Tables[0].Rows)
{
TelephoneComplainType aType = new TelephoneComplainType();
aType.TypeId = dataRow["Id"].ToString();
aType.TypeValue = dataRow["Value"].ToString();
complainTypes.Add(aType);
}
aTelephoneComplainList.ForEach(list => list.ProblemTypes = complainTypes);
return aTelephoneComplainList;
}