Example #1
0
        public List <OfferLocation> GetList(List <Dictionary <string, object> > dictList)
        {
            data.Clear();

            foreach (Dictionary <string, object> dict in dictList)
            {
                foreach (KeyValuePair <string, object> obj in dict)
                {
                    OfferLocation objectValue = (OfferLocation)obj.Value;
                    objectValue.FillFromDictionary(dict);
                    data.Add(objectValue);
                }
            }

            return(data);
        }
Example #2
0
 public virtual bool SetOfferLocationByUuid(OfferLocation obj)
 {
     return act.SetOfferLocationByUuid(DEFAULT_SET_TYPE, obj);
 }
Example #3
0
 public virtual bool SetOfferLocationByUuid(SetType set_type, OfferLocation obj)
 {
     return act.SetOfferLocationByUuid(ConvertSetTypeToString(set_type), obj);
 }
Example #4
0
 //------------------------------------------------------------------------------
 public virtual bool SetOfferLocationByUuid(string set_type, OfferLocation obj)
 {
     return act.SetOfferLocationByUuid(set_type, obj);
 }
Example #5
0
        //------------------------------------------------------------------------------
        public virtual bool SetOfferLocationByUuid(string set_type, OfferLocation obj)
        {
            List<SqlParameter> parameters
                = new List<SqlParameter>();
            parameters.Add(new SqlParameter("@set_type", set_type));
            parameters.Add(new SqlParameter("@status", obj.status));
            parameters.Add(new SqlParameter("@fax", obj.fax));
            parameters.Add(new SqlParameter("@code", obj.code));
            parameters.Add(new SqlParameter("@description", obj.description));
            parameters.Add(new SqlParameter("@address1", obj.address1));
            parameters.Add(new SqlParameter("@twitter", obj.twitter));
            parameters.Add(new SqlParameter("@phone", obj.phone));
            parameters.Add(new SqlParameter("@postal_code", obj.postal_code));
            parameters.Add(new SqlParameter("@offer_id", obj.offer_id));
            parameters.Add(new SqlParameter("@country_code", obj.country_code));
            parameters.Add(new SqlParameter("@date_created", obj.date_created));
            parameters.Add(new SqlParameter("@active", obj.active));
            parameters.Add(new SqlParameter("@data", obj.data));
            parameters.Add(new SqlParameter("@uuid", obj.uuid));
            parameters.Add(new SqlParameter("@state_province", obj.state_province));
            parameters.Add(new SqlParameter("@city", obj.city));
            parameters.Add(new SqlParameter("@display_name", obj.display_name));
            parameters.Add(new SqlParameter("@name", obj.name));
            parameters.Add(new SqlParameter("@date_modified", obj.date_modified));
            parameters.Add(new SqlParameter("@dob", obj.dob));
            parameters.Add(new SqlParameter("@date_start", obj.date_start));
            parameters.Add(new SqlParameter("@longitude", obj.longitude));
            parameters.Add(new SqlParameter("@email", obj.email));
            parameters.Add(new SqlParameter("@date_end", obj.date_end));
            parameters.Add(new SqlParameter("@latitude", obj.latitude));
            parameters.Add(new SqlParameter("@facebook", obj.facebook));
            parameters.Add(new SqlParameter("@type", obj.type));
            parameters.Add(new SqlParameter("@address2", obj.address2));

            try {
                return (bool)data.ExecuteScalar(
                BasePlatformData.connectionString
                , CommandType.StoredProcedure
                , "usp_offer_location_set_by_uuid"
                , parameters
                );
            }
            catch (Exception e){
                log.Error(e);
                return false;
            }
        }
Example #6
0
        //------------------------------------------------------------------------------
        public virtual void SetOfferLocationByUuid()
        {
            ResponseOfferLocationBool wrapper = new ResponseOfferLocationBool();
            wrapper.message = "Success";
            wrapper.code = 0;
            wrapper.action = "offer-location/set/by-uuid";

            OfferLocation obj = new OfferLocation();

            string _status = util.GetParamValue(_context, "status");
            if(!String.IsNullOrEmpty(_status))
                obj.status = (string)_status;

            string _fax = util.GetParamValue(_context, "fax");
            if(!String.IsNullOrEmpty(_fax))
                obj.fax = (string)_fax;

            string _code = util.GetParamValue(_context, "code");
            if(!String.IsNullOrEmpty(_code))
                obj.code = (string)_code;

            string _description = util.GetParamValue(_context, "description");
            if(!String.IsNullOrEmpty(_description))
                obj.description = (string)_description;

            string _address1 = util.GetParamValue(_context, "address1");
            if(!String.IsNullOrEmpty(_address1))
                obj.address1 = (string)_address1;

            string _twitter = util.GetParamValue(_context, "twitter");
            if(!String.IsNullOrEmpty(_twitter))
                obj.twitter = (string)_twitter;

            string _phone = util.GetParamValue(_context, "phone");
            if(!String.IsNullOrEmpty(_phone))
                obj.phone = (string)_phone;

            string _postal_code = util.GetParamValue(_context, "postal_code");
            if(!String.IsNullOrEmpty(_postal_code))
                obj.postal_code = (string)_postal_code;

            string _offer_id = util.GetParamValue(_context, "offer_id");
            if(!String.IsNullOrEmpty(_offer_id))
                obj.offer_id = (string)_offer_id;

            string _country_code = util.GetParamValue(_context, "country_code");
            if(!String.IsNullOrEmpty(_country_code))
                obj.country_code = (string)_country_code;

            string _date_created = util.GetParamValue(_context, "date_created");
            if(!String.IsNullOrEmpty(_date_created))
                obj.date_created = Convert.ToDateTime(_date_created);
            else
                obj.date_created = DateTime.Now;

            string _active = util.GetParamValue(_context, "active");
            if(!String.IsNullOrEmpty(_active))
                obj.active = Convert.ToBoolean(_active);

            string _data = util.GetParamValue(_context, "data");
            if(!String.IsNullOrEmpty(_data))
                obj.data = (string)_data;

            string _uuid = util.GetParamValue(_context, "uuid");
            if(!String.IsNullOrEmpty(_uuid))
                obj.uuid = (string)_uuid;

            string _state_province = util.GetParamValue(_context, "state_province");
            if(!String.IsNullOrEmpty(_state_province))
                obj.state_province = (string)_state_province;

            string _city = util.GetParamValue(_context, "city");
            if(!String.IsNullOrEmpty(_city))
                obj.city = (string)_city;

            string _display_name = util.GetParamValue(_context, "display_name");
            if(!String.IsNullOrEmpty(_display_name))
                obj.display_name = (string)_display_name;

            string _name = util.GetParamValue(_context, "name");
            if(!String.IsNullOrEmpty(_name))
                obj.name = (string)_name;

            string _date_modified = util.GetParamValue(_context, "date_modified");
            if(!String.IsNullOrEmpty(_date_modified))
                obj.date_modified = Convert.ToDateTime(_date_modified);
            else
                obj.date_modified = DateTime.Now;

            string _dob = util.GetParamValue(_context, "dob");
            if(!String.IsNullOrEmpty(_dob))
                obj.dob = Convert.ToDateTime(_dob);
            else
                obj.dob = DateTime.Now;

            string _date_start = util.GetParamValue(_context, "date_start");
            if(!String.IsNullOrEmpty(_date_start))
                obj.date_start = Convert.ToDateTime(_date_start);
            else
                obj.date_start = DateTime.Now;

            string _longitude = util.GetParamValue(_context, "longitude");
            if(!String.IsNullOrEmpty(_longitude))
                obj.longitude = Convert.ToDouble(_longitude);

            string _email = util.GetParamValue(_context, "email");
            if(!String.IsNullOrEmpty(_email))
                obj.email = (string)_email;

            string _date_end = util.GetParamValue(_context, "date_end");
            if(!String.IsNullOrEmpty(_date_end))
                obj.date_end = Convert.ToDateTime(_date_end);
            else
                obj.date_end = DateTime.Now;

            string _latitude = util.GetParamValue(_context, "latitude");
            if(!String.IsNullOrEmpty(_latitude))
                obj.latitude = Convert.ToDouble(_latitude);

            string _facebook = util.GetParamValue(_context, "facebook");
            if(!String.IsNullOrEmpty(_facebook))
                obj.facebook = (string)_facebook;

            string _type = util.GetParamValue(_context, "type");
            if(!String.IsNullOrEmpty(_type))
                obj.type = (string)_type;

            string _address2 = util.GetParamValue(_context, "address2");
            if(!String.IsNullOrEmpty(_address2))
                obj.address2 = (string)_address2;

            // get data
            wrapper.data = api.SetOfferLocationByUuid(obj);

            util.SerializeTypeJSONToResponse(_context, wrapper);
        }
Example #7
0
        public virtual OfferLocation FillOfferLocation(DataRow dr)
        {
            OfferLocation obj = new OfferLocation();

            if (dr["status"] != null)
                    obj.status = dataType.FillDataString(dr, "status");
            if (dr["fax"] != null)
                    obj.fax = dataType.FillDataString(dr, "fax");
            if (dr["code"] != null)
                    obj.code = dataType.FillDataString(dr, "code");
            if (dr["description"] != null)
                    obj.description = dataType.FillDataString(dr, "description");
            if (dr["address1"] != null)
                    obj.address1 = dataType.FillDataString(dr, "address1");
            if (dr["twitter"] != null)
                    obj.twitter = dataType.FillDataString(dr, "twitter");
            if (dr["phone"] != null)
                    obj.phone = dataType.FillDataString(dr, "phone");
            if (dr["postal_code"] != null)
                    obj.postal_code = dataType.FillDataString(dr, "postal_code");
            if (dr["offer_id"] != null)
                    obj.offer_id = dataType.FillDataString(dr, "offer_id");
            if (dr["country_code"] != null)
                    obj.country_code = dataType.FillDataString(dr, "country_code");
            if (dr["date_created"] != null)
                    obj.date_created = dataType.FillDataDateTime(dr, "date_created");
            if (dr["active"] != null)
                    obj.active = dataType.FillDataBool(dr, "active");
            if (dr["data"] != null)
                    obj.data = dataType.FillDataString(dr, "data");
            if (dr["uuid"] != null)
                    obj.uuid = dataType.FillDataString(dr, "uuid");
            if (dr["state_province"] != null)
                    obj.state_province = dataType.FillDataString(dr, "state_province");
            if (dr["city"] != null)
                    obj.city = dataType.FillDataString(dr, "city");
            if (dr["display_name"] != null)
                    obj.display_name = dataType.FillDataString(dr, "display_name");
            if (dr["name"] != null)
                    obj.name = dataType.FillDataString(dr, "name");
            if (dr["date_modified"] != null)
                    obj.date_modified = dataType.FillDataDateTime(dr, "date_modified");
            if (dr["dob"] != null)
                    obj.dob = dataType.FillDataDateTime(dr, "dob");
            if (dr["date_start"] != null)
                    obj.date_start = dataType.FillDataDateTime(dr, "date_start");
            if (dr["longitude"] != null)
                    obj.longitude = dataType.FillDataDouble(dr, "longitude");
            if (dr["email"] != null)
                    obj.email = dataType.FillDataString(dr, "email");
            if (dr["date_end"] != null)
                    obj.date_end = dataType.FillDataDateTime(dr, "date_end");
            if (dr["latitude"] != null)
                    obj.latitude = dataType.FillDataDouble(dr, "latitude");
            if (dr["facebook"] != null)
                    obj.facebook = dataType.FillDataString(dr, "facebook");
            if (dr["type"] != null)
                    obj.type = dataType.FillDataString(dr, "type");
            if (dr["address2"] != null)
                    obj.address2 = dataType.FillDataString(dr, "address2");

            return obj;
        }