Esempio n. 1
0
        public List <PostalCode> GetList(List <Dictionary <string, object> > dictList)
        {
            data.Clear();

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

            return(data);
        }
Esempio n. 2
0
        //------------------------------------------------------------------------------
        public virtual bool SetPostalCodeByUuid(string set_type, PostalCode 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("@code", obj.code));
            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("@uuid", obj.uuid));
            parameters.Add(new SqlParameter("@active", obj.active));
            parameters.Add(new SqlParameter("@date_created", obj.date_created));
            parameters.Add(new SqlParameter("@description", obj.description));

            try {
                return (bool)data.ExecuteScalar(
                BaseProfileData.connectionString
                , CommandType.StoredProcedure
                , "usp_postal_code_set_by_uuid"
                , parameters
                );
            }
            catch (Exception e){
                log.Error(e);
                return false;
            }
        }
Esempio n. 3
0
        //------------------------------------------------------------------------------
        public virtual void SetPostalCodeByUuid()
        {
            ResponsePostalCodeBool wrapper = new ResponsePostalCodeBool();
            wrapper.message = "Success";
            wrapper.code = 0;
            wrapper.action = "postal-code/set/by-uuid";

            PostalCode obj = new PostalCode();

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

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

            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 _uuid = util.GetParamValue(_context, "uuid");
            if(!String.IsNullOrEmpty(_uuid))
                obj.uuid = (string)_uuid;

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

            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 _description = util.GetParamValue(_context, "description");
            if(!String.IsNullOrEmpty(_description))
                obj.description = (string)_description;

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

            util.SerializeTypeJSONToResponse(_context, wrapper);
        }
Esempio n. 4
0
        //------------------------------------------------------------------------------
        public virtual bool SetPostalCodeByCode(string set_type, PostalCode obj)
        {
            List<NpgsqlParameter> parameters
                = new List<NpgsqlParameter>();
            parameters.Add(new NpgsqlParameter("in_set_type", set_type));
            parameters.Add(new NpgsqlParameter("in_status", obj.status));
            parameters.Add(new NpgsqlParameter("in_code", obj.code));
            parameters.Add(new NpgsqlParameter("in_display_name", obj.display_name));
            parameters.Add(new NpgsqlParameter("in_name", obj.name));
            parameters.Add(new NpgsqlParameter("in_date_modified", obj.date_modified));
            parameters.Add(new NpgsqlParameter("in_uuid", obj.uuid));
            parameters.Add(new NpgsqlParameter("in_active", obj.active));
            parameters.Add(new NpgsqlParameter("in_date_created", obj.date_created));
            parameters.Add(new NpgsqlParameter("in_description", obj.description));

            try {
                return Convert.ToBoolean(data.ExecuteScalar(
                BaseProfileData.connectionString
                , CommandType.StoredProcedure
                , "usp_postal_code_set_code"
                , parameters
                ));
            }
            catch (Exception e){
                log.Error(e);
                return false;
            }
        }
Esempio n. 5
0
 public virtual bool SetPostalCodeByUuid(PostalCode obj)
 {
     return act.SetPostalCodeByUuid(DEFAULT_SET_TYPE, obj);
 }
Esempio n. 6
0
 public virtual bool SetPostalCodeByUuid(SetType set_type, PostalCode obj)
 {
     return act.SetPostalCodeByUuid(ConvertSetTypeToString(set_type), obj);
 }
Esempio n. 7
0
 //------------------------------------------------------------------------------
 public virtual bool SetPostalCodeByUuid(string set_type, PostalCode obj)
 {
     return act.SetPostalCodeByUuid(set_type, obj);
 }
Esempio n. 8
0
        public virtual PostalCode FillPostalCode(DataRow dr)
        {
            PostalCode obj = new PostalCode();

            if (dr["status"] != null)
                    obj.status = dataType.FillDataString(dr, "status");
            if (dr["code"] != null)
                    obj.code = dataType.FillDataString(dr, "code");
            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["uuid"] != null)
                    obj.uuid = dataType.FillDataString(dr, "uuid");
            if (dr["active"] != null)
                    obj.active = dataType.FillDataBool(dr, "active");
            if (dr["date_created"] != null)
                    obj.date_created = dataType.FillDataDateTime(dr, "date_created");
            if (dr["description"] != null)
                    obj.description = dataType.FillDataString(dr, "description");

            return obj;
        }
Esempio n. 9
0
 public virtual bool SetPostalCodeByCode(string set_type, PostalCode obj)
 {
     return data.SetPostalCodeByCode(set_type, obj);
 }