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; }