public int NumRecords(int num)
{
int retVal = 0;
WorkDescDataContext t = new WorkDescDataContext();
int wk = t.tblWorkDescriptions.Count();
LocationsDataContext locd = new LocationsDataContext();
int l = locd.tblLocations.Count();
if (num == 1)
{
if (wk >= 0)
{
retVal = wk;
}
}
if (num == 2)
{
if (l >= 0)
{
retVal = l;
}
}
return(retVal);
}
public QuoteSvcImplDB()
{
dc = (LocationsDataContext)MainFactory.getDb("Locations", true);
}
public QuoteSvcImplDB(LocationsDataContext dc)
{
this.dc = dc;
}
public BuildingSvcImplDB(LocationsDataContext dc)
{
this.dc = dc;
}
public LocDetail(string clli, int range, LocationsDataContext dc)
{
this.range = range;
var clliDetails = (from detail in dc.ADDRESSES_VWs
where detail.AddressCLLI.ToUpper().Equals(clli.ToUpper())
select detail).FirstOrDefault();
this.lat = (decimal)clliDetails.Zside_Latitude;
this.lng = (decimal)clliDetails.Zside_Longitude;
this.addressConcat = clliDetails.Zside_Premise + " " + clliDetails.Zside_Street + "|"
+ clliDetails.Zside_City + "|" + clliDetails.Zside_State;
this.zip = clliDetails.Zside_PostalCode;
}
public LocDetail(decimal lat, decimal lng, string zip, int range, string addressConcat, LocationsDataContext dc)
{
this.lat = lat;
this.lng = lng;
this.zip = zip;
this.addressConcat = addressConcat;
this.range = range;
this.dc = dc;
}