Esempio n. 1
0
        internal static UserSetting GetUserSetting(DataRow row)
        {
            UserSetting result = new UserSetting();
            if (row.Table.Columns.Contains("Id"))
            {
                if (Convert.IsDBNull(row["Id"]))
                {
                    result._isIdNull = true;
                }
                else
                {
                    result._id = Convert.ToInt32(row["Id"]);
                    result._isIdNull = false;
                }
            }

            if (row.Table.Columns.Contains("ZipCode"))
            {
                if (Convert.IsDBNull(row["ZipCode"]))
                {
                    result._isZipCodeNull = true;
                }
                else
                {
                    result._zipCode = Convert.ToString(row["ZipCode"]);
                    result._isZipCodeNull = false;
                }
            }

            if (row.Table.Columns.Contains("FilterChangeDate"))
            {
                if (Convert.IsDBNull(row["FilterChangeDate"]))
                {
                    result._isFilterChangeDateNull = true;
                }
                else
                {
                    result._filterChangeDate = Convert.ToDateTime(row["FilterChangeDate"]);
                    result._isFilterChangeDateNull = false;
                }
            }

            if (row.Table.Columns.Contains("UserId"))
            {
                if (Convert.IsDBNull(row["UserId"]))
                {
                    result._isUserIdNull = true;
                }
                else
                {
                    result._userId = Convert.ToInt32(row["UserId"]);
                    result._isUserIdNull = false;
                }
            }

            return result;
        }
Esempio n. 2
0
        public static int SaveUserSetting(UserSetting userSetting)
        {
            int result = 0;
            SqlCommand cmd = new SqlCommand("SaveUserSetting", ThermostatMonitorLib.Global.Connection);
            cmd.CommandType = CommandType.StoredProcedure;
            if (userSetting._isIdNull)
            {
                cmd.Parameters.AddWithValue("@Id", System.DBNull.Value);
            }
            else
            {
                cmd.Parameters.AddWithValue("@Id", userSetting._id);
            }

            if (userSetting._isZipCodeNull)
            {
                cmd.Parameters.AddWithValue("@ZipCode", System.DBNull.Value);
            }
            else
            {
                cmd.Parameters.AddWithValue("@ZipCode", userSetting._zipCode);
            }

            if (userSetting._isFilterChangeDateNull)
            {
                cmd.Parameters.AddWithValue("@FilterChangeDate", System.DBNull.Value);
            }
            else
            {
                cmd.Parameters.AddWithValue("@FilterChangeDate", userSetting._filterChangeDate);
            }

            if (userSetting._isUserIdNull)
            {
                cmd.Parameters.AddWithValue("@UserId", System.DBNull.Value);
            }
            else
            {
                cmd.Parameters.AddWithValue("@UserId", userSetting._userId);
            }

            cmd.Connection.Open();
            try
            {
                result = Convert.ToInt32(cmd.ExecuteScalar());
            }
            finally
            {
                cmd.Connection.Close();
            }
            userSetting.Id = result;
            return result;
        }