Ejemplo n.º 1
0
    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);
    }
Ejemplo n.º 2
0
 public QuoteSvcImplDB()
 {
     dc = (LocationsDataContext)MainFactory.getDb("Locations", true);
 }
Ejemplo n.º 3
0
 public QuoteSvcImplDB(LocationsDataContext dc)
 {
     this.dc = dc;
 }
Ejemplo n.º 4
0
 public BuildingSvcImplDB(LocationsDataContext dc)
 {
     this.dc = dc;
 }
Ejemplo n.º 5
0
        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;
        }
Ejemplo n.º 6
0
 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;
 }