public List <Workorder> GetWO(string value1 = null, string value2 = null, string value3 = null)
{
AV_SitesDL sd = new AV_SitesDL();
List <Workorder> wolst = new List <Workorder>();
DataSet ds = sd.GetDataSet("SiteWithSectors", value1);
if (ds.Tables.Count > 0)
{
DataTable Sit = ds.Tables[0];
AV_Site s = new AV_Site();
var rec = Sit.ToList <AV_Site>();
if (rec.Count > 0)
{
s = rec.FirstOrDefault();
}
DataTable sec = ds.Tables[1];
Workorder wo;
for (int i = 0; i < sec.Rows.Count; i++)
{
wo = new Workorder();
wo.SiteId = s.SiteId;
wo.siteCode = s.SiteCode;
wo.siteLatitude = s.Latitude.ToString();
wo.siteLongitude = s.Longitude.ToString();
wo.Client = s.ClientId.ToString();
wo.Scope = s.ScopeId.ToString();
wo.SiteAddress = s.SiteAddress;
wo.SiteName = s.SiteName;
wo.SiteTypeId = s.SiteTypeId.ToString();
wo.SiteClassId = s.SiteClassId;
wo.Description = s.Description;
wo.clusterCode = "-";
wo.sectorCode = sec.Rows[i]["SectorCode"].ToString();
wo.networkMode = sec.Rows[i]["NetworkModeId"].ToString();
wo.Band = sec.Rows[i]["BandId"].ToString();
wo.Carrier = sec.Rows[i]["CarrierId"].ToString();
wo.BandWidth = (!string.IsNullOrEmpty(sec.Rows[i]["BandWidth"].ToString())) ? sec.Rows[i]["BandWidth"].ToString() : "0";
wo.Antenna = sec.Rows[i]["Antenna"].ToString();
wo.BeamWidth = sec.Rows[i]["BeamWidth"].ToString();
wo.Azimuth = sec.Rows[i]["Azimuth"].ToString();
wo.PCI = sec.Rows[i]["PCI"].ToString();
wo.MRBTS = sec.Rows[i]["MRBTS"].ToString();
wo.RFHeight = DataType.ToInt32(sec.Rows[i]["RFHeight"].ToString());
wo.MTilt = DataType.ToInt32(sec.Rows[i]["MTilt"].ToString());
wo.ETilt = DataType.ToInt32(sec.Rows[i]["ETilt"].ToString());
wo.CellId = sec.Rows[i]["CellId"].ToString();
wolst.Add(wo);
}
}
return(wolst);
}